Setting Up Payment Formats

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.

Click to jump to parent topicUnderstanding 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.

Click to jump to parent topicPrerequisites

Before you complete the tasks in this section:

Click to jump to parent topicSetting Up Standard Payment Formats

This section provides an overview of the standard payment formats and discusses how to set up processing options for:

Click to jump to top of pageClick to jump to parent topicUnderstanding 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.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Print Automatic Payments - Standard Format (R04572)

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.

Print

1. Form Type (FUTURE)

This processing option is not used.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Print Automatic Payments - Draft Format (R04572N)

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.

Print

Form Type (FUTURE)

This processing option is not used.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Create A/P Bank Tape - PPD Format (R04572T1)

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

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.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Create A/P Bank Tape - CTX Format (R04572T2)

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.

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.

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.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Create A/P Bank Tape - EDI Format (R47052T)

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:

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

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.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Print Automatic Payments - Subcontract Processing (R04572J)

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.

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.