Setting Data Sequence for Create Payment Control Groups
The Create Payment Control Groups program sequences payments within payment groups using the default template sequence and the processing option settings. You do not need to change the data sequence to sequence payments properly. It is recommended that you not change the data sequence.
When you run the Create Payment Control Groups program, the system reads records from the F0411 table in an order that is determined by the template sequence and the processing option settings. The system creates a new payment group when it encounters a change in any of the following values as it reads the records:
Payment Instrument (PYIN)
G/L Bank Account (GLBA) (optional)
The system uses the G/L Bank Account field unless you have entered a G/L Bank Account override on the Printing tab of the processing options.
Business Unit (MCU) (optional)
The system uses the Business Unit field only if you have completed the Business Unit processing option on the Process By tab of the processing options.
Currency Code (CRCD)
Within the payment groups, the system creates a new payment when it encounters a change in any of these values as it reads the records:
Payment Handling Code (CRC)
Payee Number (PYE)
Company (CO) (optional)
The system uses the Company field only if you have completed the By Company processing option on the Process By tab of the processing options.
Statement/Control Number (CTL) (optional)
The system uses the Statement/Control Number field only if either or both of the following situations is met:
The Print Contract Number option on the Report tab of the processing options is completed and the Payment Creation option on the payee's Supplier Master (F0401) record is set to By Contract (C).
The Print Job Number processing option on the Report tab of the processing options is completed, the Payment Creation Option on the payee's Suppler Master (F0401) record is set to By Contract (C), and the Business Unit Type (STYL) of the business unit on the voucher is Job Cost (JB).
Purchase Order Number (PKCO) (optional)
The system uses the Purchase Order Number field only if the Print Contract Number option on the Report tab of the processing options is completed and the Payment Creation option on the payee's Supplier Master (F0401) record is set to By Contract (C).
Address Number (AN8)
Due Date (DDJ) (optional)
The system uses the Due Date field only if you have completed the Due Date processing option on the Process By tab of the processing options.
The system also creates payments within payment groups based on the Payment Creation option on the payee's Supplier Master (F0401) record. For example, if you have specified By Supplier as the Payment Creation option for a payee and that payee is listed on vouchers for three different suppliers in the payment group, the system generates three payments for that payee.
Also, the system can print no more than 99 check stubs per payment. The number of detail lines that you print on each check stub is set up on the Set Up G/L Bank Account form. For example, if you specify 10 detail lines per check stub on the Set Up G/L Bank Account form, the system can print 990 detail lines per payment.
If a payment requires more than 99 check stubs, the system prints the additional detail lines on an attachment if you have completed the Print Attachments processing option. Otherwise, the system creates a new payment for the additional detail lines.