4 Setting Up Payment Formats

This chapter contains the following topics:

Section 4.1, "Understanding Payment Formats"
Section 4.2, "Prerequisites"
Section 4.3, "Setting Up Standard Payment Formats"

Note:

Country-specific payment formats exist for these European countries.

"Setting Up Payment Formats for Austria" in the JD Edwards EnterpriseOne Applications Localizations for Austria Implementation Guide.
"Setting Up Payment Formats for Belgium" in the JD Edwards EnterpriseOne Applications Localizations for Belgium Implementation Guide.
"Setting Up Payment Formats for Denmark" in the JD Edwards EnterpriseOne Applications Localizations for Denmark Implementation Guide.
"Setting Up Payment Formats for Finland" in the JD Edwards EnterpriseOne Applications Localizations for Finland Implementation Guide.
"Setting Up Payment Formats for Germany" in the JD Edwards EnterpriseOne Applications Localizations for Germany Implementation Guide.
"Setting Up Payment Formats for Ireland" in the JD Edwards EnterpriseOne Applications Localizations for the United Kingdom and Ireland Implementation Guide.
"Setting Up Payment Formats for Italy" in the JD Edwards EnterpriseOne Applications Localizations for Italy Implementation Guide.
"Setting Up Payment Formats for the Netherlands" in the JD Edwards EnterpriseOne Applications Localizations for the Netherlands Implementation Guide.
"Setting Up Payment Formats for Norway" in the JD Edwards EnterpriseOne Applications Localizations for Norway Implementation Guide.
"Setting Up Payment Formats for Spain" in the JD Edwards EnterpriseOne Applications Localizations for Spain Implementation Guide
"Setting Up Payment Formats for Sweden" in the JD Edwards EnterpriseOne Applications Localizations for Sweden Implementation Guide.
"Setting Up Payment Formats for Switzerland" in the JD Edwards EnterpriseOne Applications Localizations for Switzerland Implementation Guide.
.

Note:

Country-specific payment formats exist for Australia and Singapore:

"Setting Up Payment Formats for Australia" in the JD Edwards EnterpriseOne Applications Localizations for Australia and Singapore Implementation Guide.
"Setting Up the Payment Format for Singapore" in the JD Edwards EnterpriseOne Applications Localizations for Australia and Singapore Implementation Guide.

Note:

Country-specific payment formats exist for these Latin American countries:

"Setting Up Payment Formats for Argentina" in the JD Edwards EnterpriseOne Applications Localizations for Argentina Implementation Guide
"Setting Up Payment Formats for Brazil" in the JD Edwards EnterpriseOne Applications Localizations for Brazil Implementation Guide.
"Setting Up Payment Formats for Colombia" in the JD Edwards EnterpriseOne Applications Localizations for Colombia Implementation Guide.
"Setting Up the Payment Format for Ecuador" in the JD Edwards EnterpriseOne Applications Localizations for Ecuador Implementation Guide.

4.1 Understanding Payment Formats

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.

4.2 Prerequisites

Before you complete the tasks in this section:

Assign print programs to payment instruments.

See Setting Up Payment Instruments and Print Programs.
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.

4.3 Setting Up Standard Payment Formats

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).
Create A/P Bank File – IAT Format (R04572T3).

4.3.1 Understanding Standard Payment Formats

JD Edwards EnterpriseOne software provides these standard payment formats:

Format	Description
R04572	Print automatic payments in the standard format.
R04572N	Print automatic payments in draft format.
R04572T1	Print US-based electronic payments.
R04572T2	Create a bank tape in the corporate trade exchange (CTX) format.
R47052T	Create a bank tape in the Electronic Data Interchange (EDI) format.
R04572J	Print automatic payments for subcontract processing.
R04572T3	Generates bank files using the ACH International ACH Transaction (IAT) format. It creates all records defined by IAT for NACHA. This report supports payment transactions only if the currency code is USD.

4.3.2 Setting Processing Options for Print Automatic Payments - Standard Format (R04572)

Processing options enable you to specify the default processing for programs and reports.

4.3.2.1 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.

4.3.2.2 Defaults

1. Address Format (FUTURE): This processing option is not used.

4.3.2.3 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.

4.3.2.4 Print

1. Form Type (FUTURE): This processing option is not used.

4.3.3 Setting Processing Options for Print Automatic Payments - Draft Format (R04572N)

Processing options enable you to specify the default processing for programs and reports.

4.3.3.1 Address

Address Format (FUTURE): This processing option is not used.

4.3.3.2 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.

4.3.3.3 Print

Form Type (FUTURE): This processing option is not used.

4.3.4 Setting Processing Options for Create A/P Bank Tape - PPD Format (R04572T1)

Processing options enable you to specify the default processing for programs and reports.

4.3.4.1 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.

4.3.4.2 Print

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.

4.3.4.3 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.

4.3.5 Setting Processing Options for Create A/P Bank Tape - CTX Format (R04572T2)

Processing options enable you to specify the default processing for programs and reports.

4.3.5.1 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.

4.3.5.2 Print

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.

4.3.5.3 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.

4.3.6 Setting Processing Options for Create A/P Bank Tape - EDI Format (R47052T)

Processing options enable you to specify the default processing for programs and reports.

4.3.6.1 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:

EDI Payment Order Header - Outbound (F47056).
EDI Payment Order Bank N & A - Outbound (F470561).
EDI Payment Order Vendor N & A - Outbound (F470562).
EDI Payment Order Payee N & A - Outbound (F470563).
EDI Payment Order Remittance Advice - Outbound (F47057).

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).

4.3.6.2 Print

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.

4.3.7 Setting Processing Options for Print Automatic Payments - Subcontract Processing (R04572J)

Processing options enable you to specify the default processing for programs and reports.

4.3.7.1 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.

4.3.7.2 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.

4.3.7.3 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.

4.3.7.4 Print

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.

4.3.8 Processing Option for Create A/P Bank File - IAT Format Program (R04572T3)

Processing options enable you to specify the default processing for programs and reports.

4.3.8.1 Process

1. File ID Modifier

Specify the one-character file identification modifier. The system uses this value in the File Header Record to differentiate between multiple files created on the same date and between the same participants that are to be distinguished. You can enter any alphanumeric character.

If you leave this processing option blank, the system uses the default value of 1.

2. Company Entry Description

Specify a description for the purpose of the entry.

3. Immediate Origin

Specify the immediate origin on the File Header Record. This value has the routing number of the ACH operator or sending point that is sending the file. The 9 character field begins with four digit Federal Reserve Routing symbol, followed by the four digit ABA Institution Identifier, and then the check digit.

If you leave this field blank, the system uses the Tax ID for the payment company. This value is mandatory for the File Header Record.

4. Originator Identification

Specify the 10 character Originator Identification number. The Originator Identification is an alphanumeric code used to uniquely identify an originator. For an originator who is not a natural person, this field must contain the IRS Taxpayer Identification Number (TIN). For an originator that is not a natural person and is not established or organized under the laws of a State or the United States, this field must contain an identification number as defined by Treasury regulations.

If you leave this fiels blank, the system uses the Tax ID for the payment company. This value is mandatory for the IAT Company/Batch Header Record.

4.3.8.2 Print

1. Pre-Note Print Program: Specify the payment print program to use if the pre-note status is set to P.
2. Pre-Note Print Program Version: Specify the payment print program version to use if the pre-note status is set to P. If you leave this blank, the system uses ZJDE0001.

4.3.8.3 Tape

1. Device Name: Specify the type of device to be used for copying data to tape.
2. Tape Density: Specify the density of the tape, for example, 1600 or 6250.
3. Label Name: Specify the label for the copied tape.
4. Block Size: Specify the block length that the system uses when copying data to tape.
5. New Volume Name: Specify the new volume name that the system uses when copying data to tape.
6. New Owner ID: Specify the new owner ID to be used when copying data to tape.
7. File Name: Specify the name of the flat file identified by the program that reads the file.