This chapter provides an overview of payment formats, lists prerequisites, and discusses how to Set up standard payment formats.
Note. Country-specific payment formats exist for many countries. Refer to the section about setting up payment formats for each
country in these books:
JD Edwards EnterpriseOne Country-Specific Setup and Processes for Asia and Australia 9.0 Implementation Guide.
JD Edwards EnterpriseOne Country-Specific Setup and Processes for Europe Localization 9.0 Implementation Guide.
JD Edwards EnterpriseOne Country-Specific Setup and Processes for the Americas 9.0 Implementation Guide.
After you assign payment print programs to payment instruments, you must review and revise, if necessary, the processing options for the formats used by the print programs.
The payment print program that you assign to a payment instrument launches the version of the payment format when you process payments. For example, P04572 launches the R04572 program. To make changes to the processing options for the payment formats, access them from the Batch Versions program (P98305), entering R instead of P in the first position of the name of the payment format program. The processing options further define the format of each component of a payment instrument.
Before you complete the tasks in this section:
Assign print programs to payment instruments.
Verify that codes for the payment formats for the countries with which you conduct business exist in the Produce Bank File (04/PP) user-defined code (UDC) table.
This section provides an overview of the standard payment formats and discusses how to set up processing options for:
Print Automatic Payments - Standard Format (R04572).
Print Automatic Payments - Draft Format (R04572N).
Create A/P Bank Tape - PPD Format (R04572T1)
Create A/P Bank Tape - CTX Format (R04572T2).
Create A/P Bank Tape - EDI Format (R47052T).
Print Automatic Payments - Subcontract Processing (R04572J).
JD Edwards EnterpriseOne software provides these standard payment formats:
Format |
Description |
Print automatic payments in the standard format. |
|
Print automatic payments in draft format. |
|
Print US-based electronic payments. |
|
Create a bank tape in the corporate trade exchange (CTX) format. |
|
Create a bank tape in the Electronic Data Interchange (EDI) format. |
|
Print automatic payments for subcontract processing. |
Processing options enable you to specify the default processing for programs and reports.
Translation
1. Translation Program |
Enter a value that exists in the Check Translation (98/CT) UDC table to specify the translation program to use when translating the amount of the payment into words. If you leave this processing option blank, the system uses the translation program that is associated with the payment currency. |
Defaults
1. Address Format (FUTURE) |
This processing option is not used. |
Select
1. Company Information |
Enter 1 to print the company name and address on the payment stub. |
2. Payee Information |
Enter 1 to print the payee name and number on the payment stub. |
3. Purchase Order |
Enter 1 to print the purchase order number. Leave this processing option blank to print the supplier invoice number. |
4. Alternate Stub Information |
Specify alternate information for the system to print on the payment stub. Values are: Blank: Print a remark. 1: Print the supplier name. 2: Print the supplier invoice number. |
1. Form Type (FUTURE) |
This processing option is not used. |
Processing options enable you to specify the default processing for programs and reports.
Address
Address Format (FUTURE) |
This processing option is not used. |
Payment
Print Information |
Enter 1 to print the supplier name. Enter 2 to print the supplier invoice number. Leave this processing option blank to print the remark. |
Form Type (FUTURE) |
This processing option is not used. |
Processing options enable you to specify the default processing for programs and reports.
EFT
File ID Modifier |
Specify the file ID modifier to distinguish between multiple files created on the same date. If you leave this processing option blank, the system uses 1. |
Tape Payment Detail Description |
Enter up to ten characters to describe the tape payment detail. For example, you could enter EXP REIMB for expense reimbursements. This description may be used by the bank and printed on the supplier's bank account statement. |
Immediate Origin |
Enter up to ten characters to describe the immediate origin. The system uses this value for position 14-23 in header record 1. If you enter fewer than 10 characters, the system right justifies your entry and places blanks in the preceding spaces. If you leave this processing option blank, the system uses the tax ID for the bank account's company as the value. Note. If you leave this processing option blank and no tax ID is available, the tape will be rejected by the clearing house. |
Identification Code Designator |
Enter 10 characters for the company ID number. The system uses this value for positions 41–50 in record 5 and in positions 45–54 in record 8. Optionally, precede the ID number by one of these ID Code Designators (ICDs) or a value of your own: 1: Specifies an IRS Employer ID No. (EIN). 3: Specifies the Data Universal No. System (DUNS). 9: Specifies a user-assigned number. If you leave this processing option blank, the system uses the tax ID for the bank account's company. Note. If you leave this processing option blank and no tax ID is available, or the value entered is less than 10 characters, the tape will be rejected by the clearing house. |
Discretionary Data |
Enter up to 20 alpha characters that the system prints in the Discretionary Data processing option on the Company/Batch Header Record (Record 5, position 21-40) of the file. If you leave this processing option blank, the positions in the records are blank. |
Bank Account Reference Roll Number |
Enter 1 to print the Vendor's Bank Account Reference Roll Number in the Individual ID Number (Record 6, position 40-54). If you leave this processing option blank, the system prints the payee name. |
Balancing Debit Entry |
Enter 1 to print a balancing debit entry (record 6) to the current bank account. If you leave this processing option blank, the system does not write a balancing record. If a balancing record is written, the system uses the routing and account numbers for the bank account from the F0030 table. |
Print Program |
Specify the payment print program that the system uses when prenote status is P. |
Print Program Version |
Specify the version on the print program that you specify in the Print Program processing option. |
Tape
Devise Name |
Specify the devise name |
Tape Density |
Specify the tape density. |
Label Name |
Specify the label name. |
Block Size |
Specify the block size. |
New Volume Name |
Specify the new volume name. |
New Owner ID |
Specify the new owner name. |
File Name |
Specify the file name. |
Processing options enable you to specify the default processing for programs and reports.
Process
1. File ID Modifier |
Specify the one-character file identification modifier. This value is used to differentiate between multiple files created on the same date on the tape. You can enter any alphanumeric character. If you enter more than one character, only the first character is used. The default value is 1. |
2. Tape Payment Detail Description |
Specify the tape payment detail description of the tape. You can enter up to 10 characters. For example, you can enter EXP REIMB to indicate that the payment is an expense reimbursement. The bank might print this description on the supplier's bank account statement. |
3. Immediate Origin |
Specify the 10-character immediate origin. The system populates this value in positions 14 through 23 of Header Record 1. If you enter only nine characters or digits, the system right justifies the information and places a blank space in the first position of this processing option. If you leave this processing option blank, the system uses the tax identification number contained in the address book record for the bank account's company. If you leave this processing option blank and the address book record for the bank account's company does not contain a tax identification number, the clearing house rejects the tape. |
4. Identification Code Designator |
Specify the 10-character company identification number. The system populates this value in positions 41 through 50 of Record 5 and positions 45 through 54 of Record 8. For the identification code designators (ICDs), you can enter either a user-defined value or enter one of these values to precede the company identification number: 1: Specifies an IRS EIN. 3: Specifies a DUNS. 9: Specifies a user-assigned number. If you leave this processing option blank, the system uses the tax identification number contained in the address book record for the bank account's company. If you leave this processing option blank and the address book record for the company does not contain a tax identification number or is less than 10 characters, the clearing house rejects the tape. |
5. Discretionary Data |
Enter the text that the system prints in the Discretionary Data processing option on the Company/Batch Header Record (Record 5, position 21-40) of the file. You can enter up to 20 characters. If you leave this processing option blank, the positions in the records are blank. |
1. Print Program |
Specify the payment print program for the system to use if the Pre-Note Code check box on the supplier master record is selected. |
Tape
Use these processing options to specify the default values for the bank tape.
Devise Name |
Specify the devise name |
Tape Density |
Specify the tape density. |
Label Name |
Specify the label name. |
Block Size |
Specify the block size. |
New Volume Name |
Specify the new volume name. |
New Owner Name |
Specify the new owner name. |
File Name |
Specify the file name. |
Processing options enable you to specify the default processing for programs and reports.
Defaults
1. EDI Transaction Set |
Enter a value that exists in the EDI – Transaction Set Number (40/ST) UDC table to specify the default EDI transaction set. |
2. EDI Translation Format |
Enter a value that exists in the EDI – Transaction Set Number (40/ST) UDC table to specify the default EDI transaction format. |
3. EDI Document Type |
Specify the EDI document type. Enter any alphanumeric value. The system populates the EDI - Document Type field (EDCT) in these tables with the value:
|
4. EDI Trading Partner ID |
Specify the EDI trading partner ID. The system populates the Trading Partner ID field (PNID) in the EDI Payment Order Header - Outbound (F47056) and EDI Payment Order Remittance Advice - Outbound (F47057) tables with this value. |
5. EDI Transaction Handling Code |
Specify the EDI transaction handling code. Enter a valid code from the Transaction Handling Code (47/TH) UDC table. |
6. Identification Code Designator |
Specify the company identification number. This number must be 10 characters. It is the identification code designator (ICD) followed by a nine-digit identification number. Valid ICDs are: 1: Specify an IRS EIN. 3: Specify a DUNS. 9: Specify a user-assigned number. If you leave this processing option blank, the system uses the tax identification number for the company of the bank account. If this processing option is blank on the tape, the banking clearing house rejects the tape. |
7. File Name |
Specify the file name for the system to use when populating the File Name field (FILE) in the A/P Payment Tape table (F0457). |
1. Print Program |
Specify the payment print program to use if the Pre-Note Code check box in the supplier master is selected, requiring the system to print a check. |
Processing options enable you to specify the default processing for programs and reports.
Translation
Translation Program |
Enter a value that exists in the Check Translation (98/CT) UDC table to specify the translation program to use when translating the amount of the payment into words. If you leave this processing option blank, the system uses the translation program that is associated with the payment currency. |
Address
Address |
Specify an override address format to use for the payee, the company addresses, or both. If you leave this processing option blank, the system uses the country format. |
Payment
Company Name |
Enter 1 to print the company name and address on the payment. If you leave this processing option blank, the system does not print company information. |
Form Type |
Specify the form type for the payments spool file. If you leave this processing option blank, the system uses the SUBCHECKS form type. |