Troubleshooting Print Sequence Set Up (P0415)

Purpose

This document helps troubleshoot Print Sequence Set Up or Errors (P0415)

Scope

This document is intended for users who are configuring the JD Edwards EnterpiseOne system to process Automatic Payments.

Details

Print Sequence Set Up (P0415)

Print Sequences give users control over the order payments are printed. For example, payments may need to be printed in descending order by amount so that the largest payment amounts print first. Sequence IDs configured in Work with Payment Sequences (P0415) are used to establish the printing order and can contain up to six data items from fields in the A/P Payments Worktable that are defined in UDC table H04/SF (Auto Payment Sequence Items).



A Sequence ID (data dictionary item SQID) is required for each desired print sequence. When running the Create Payment Control Groups (R04570),  Processing Option 1: Sequence ID on the Print tab should reflect the desired payment sequence for this batch of payments.

Use the following steps to set up different Print Sequences to match your business requirements:

1. From the Automatic Payment Setup menu (G04411), choose Payment Sequence. On Work With Payment Sequences, click Add. You can add a new sequence by copying an existing one and modifying it as needed. On Work With Payment Sequences, choose the existing payment sequence and click Copy.
2. On Set Up Payment Sequence, complete the following fields:

• Sequence ID
• Description

1. Enter a data dictionary item in at least one of the following fields:

• Sequence 1
• Sequence 2
• Sequence 3
• Sequence 4
• Sequence 5
• Sequence 6

1. For each sequence that you set up, choose either Ascending or Descending.
2. Click OK

If you want to print payments based on criteria outside of the Accounts Payable system, you can use special handling codes. Special handling codes are user defined and assigned at the time of voucher entry. You can use them to sort payments by including them in your Sequence ID.

Frequently Asked Questions

Question 1: When creating a new Print Sequence to add to sort by DOC, it errors out value does not exist, why?

Answer 1: Value must appear in the UDC table H04/SF and the UDC for higher releases must be cached to accept the change. Once UDC was cached issue was resolved.

Question 2: Is it possible to set an AP Check Sequence (P0415) to sort by Mailing Address?

Answer 2: Unfortunately, it is not possible to set up an AP Check Sequence (P0415) by Mailing address because this information is stored in the Address By Date (F0116) table and the fields available for sequencing are found in the AP Payment Temporary Tables (F04571, F04572, F04573). In particular, most fields available are found in the A/P Payment Processing - Summary (F04572) table.

You could possibly use one of the category codes, AC01-AC05 for these purposes, which would need to be populated in the address book and supplier master and then in the related vouchers prior to creating the Payment Control Groups (R04570).