This chapter includes these topics:
Section 4.1, "Understanding Payment Format Processing Options for European Payment Formats"
Section 4.2, "Setting Processing Options for the SEPA Credit Transfer Initiation Payment Format"
Section 4.3, "Setting Processing Options for the French Promissory Note Payment Format"
Section 4.4, "Setting Processing Options for the German Check Payment Format"
Section 4.5, "Setting Processing Options for the Netherlands Domestic EFT Payment Format"
Section 4.6, "Setting Processing Options for the Spanish EFT Payment Format"
The system uses the Payment Information Extractor program (R704001) to extract the data from JD Edwards EnterpriseOne tables that you need for payment formats. You use a different version of the Payment Information Extractor program for each payment format. Because the processing option template is the same for every version of the Payment Information Extractor program, you set the processing options for each version to specify the information that you want to extract and the validations that you want the system to perform. Setting the processing options to suppress the extraction of information that is not needed for a specific payment format increases system performance.
You can access the processing options for each version of the Payment Information Extractor program from the Accounts Payable Setup menu (G700441). However, you run the Payment Information Extractor program when you use the Write function in the Work with Payment Groups program (P04571).
|
Important!: Each version of the Payment Information Extractor program is associated to a specific report definition and payment format template. If you need to create a new version of the Payment Information Extractor program, be sure to create a copy of the version that corresponds to the payment format that you want to use. For example, if you need to create a different version to use for the SEPA credit transfer initiation payment format, make a copy of version ZJDE0002 only. If you use a copy of any other version, the system will not use the correct report definition or payment format template. |
Before you use the French promissory note format, you should:
Set up your G/L bank account with information about the number of alignment forms and the number of detail lines per stub.
Set the Summarized Pay Item processing option in the Create Payment Control Groups program (P04570) to 1.
EnterP04576N as the payment register program in the Payment Instrument Defaults program (P0417).
This section discusses how to set processing options for version ZJDE0002 (SEPA credit transfer initiation) of the Payment Information Extractor program (R704001).
Enter a value from the Check Translation (98/CT) UDC table to specify the translation program to use to convert numbers to words. If you leave this processing option blank, the system uses the translation program that is associated with the currency of the payment.
Specify whether to use replacement characters from UDC 70/RS. Values are:
Y: Yes
N or Blank: No
Specify whether the system includes multiple occurrences per remittance information. Values are:
Y: Inform several invoices.
N or Blank: Inform only one invoice.
Specify the next number the system uses for matching document with document type PT. Values are:
Blank: Use the payment next number from the General Ledger (G/L) Bank Account Information program (P0030G).
1: Use the standard next number from the Next Numbers program (P0002).
Depending on the Next Number constants, the system retrieves the information from the system 04 and line 5; or from the Company, Fiscal Year and Document Type PK, PT, or P1.
Use these processing options to limit the data that is extracted from the JD Edwards EnterpriseOne tables.
See How to Specify Information to Include in the Extract Overview
Enter Y (yes) or leave this processing option blank to extract payor information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of bank account information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of ultimate debtor information.
Enter Y (yes) or leave this processing option blank to include the extraction of payee information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of payee bank account information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of ultimate creditor information.
Enter Y (yes) or leave this processing option blank to extract document payable information, which is required for this payment format.
Enter Y (yes) to validate the supplier's IBAN (international bank account number), which is required for this payment format.
EnterY (yes) to validate the company's account IBAN, which is required for this payment format.
EnterY (yes) to validate the supplier's SWIFT number, which is required for this payment format.
EnterY (yes) to validate the company's account SWIFT number, which is required for this payment format.
Enter the currency code that you want to include in the payment format output. If you do not specify a currency code, the system uses the currency of the payment.
|
Note: The currency code for SEPA credit transfer files must be EUR. If your internal currency code for the euro is not EUR, you must set up a cross-reference between your internal currency code and the value EUR in the 70/CC UDC table. |
Specify VLSEPA to have the system apply the validation routine for SEPA credit transfer files.
When you enter VLSEPA in this processing option, the system validates the IBAN and BIC code (SWIFT) for the supplier's and company's accounts. If the any of the IBANs or BICs are invalid, the system writes an error message to the Work Center. The system stops processing if it issues an error message.
The system also writes a warning message to the Work Center if the country of the company or supplier is blank. The system continues processing records if it issues a warning message.
Specify a value from UDC table (70/UD) that identifies the address number line that the system uses for the ultimate debtor.
This processing option can have a value from 1 to 5. For example, if the Ultimate Debtor Addr Line Number processing option is equal to 2, then address number 2 from the address book is the ultimate debtor address number.
Specify a value from UDC table (70/UC) that identifies the address number line that the system uses for the ultimate creditor.
This section discusses how to set processing options for version ZJDE0003 (French promissory note) of the Payment Information Extractor program (R704001).
Enter a value from the Check Translation (98/CT) UDC table to specify the translation program to use to convert numbers to words. If you leave this processing option blank, the system uses the translation program that is associated with the currency of the payment.
Use these processing options to limit the data that is extracted from the JD Edwards EnterpriseOne tables.
See How to Specify Information to Include in the Extract Overview
Enter Y (yes) or leave this processing option blank to include the extraction of bank account information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of payee information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of payee bank account information, which is required for this payment format.
Enter N (no) or leave this processing option blank to prevent the extraction of payor information, which is not required for this payment format.
Enter Y (yes) or leave this processing option blank to extract document payable information, which is required for this payment format.
Enter N (no) to suppress the validation of the supplier's IBAN (international bank account number), which is not required for this payment format.
EnterN (no) to suppress validation of the company's account IBAN, which is not required for this payment format.
EnterN (no) to suppress the validation of the supplier's SWIFT number, which is not required for this payment format.
EnterN (no) to suppress the validation of the company's account SWIFT number, which is required for this payment format.
Enter the currency code that you want to include in the payment format output. If you do not specify a currency code, the system uses the currency of the payment.
Enter a value that exists in the Special Validation Rules (70/VL) UDC table to have the system apply the validation routine.
|
Note: Because the French promissory note format does not require a special validation routine, you should leave this processing option blank so that no validation is applied. |
This section discusses how to set processing options for version ZJDE0004 (German check) of the Payment Information Extractor program (R704001).
Enter a value from the Check Translation (98/CT) UDC table to specify the translation program to use to convert numbers to words. If you leave this processing option blank, the system uses the translation program that is associated with the currency of the payment.
Use these processing options to limit the data that is extracted from the JD Edwards EnterpriseOne tables.
See How to Specify Information to Include in the Extract Overview
Enter N (no) or leave this processing option blank to prevent the extraction of bank account information, which is not required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of payee information, which is required for this payment format.
Enter N (no) or leave this processing option blank to prevent the extraction of payee bank account information, which is not required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of payor information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to extract document payable information, which is required for this payment format.
Enter N (no) to suppress the validation of the supplier's IBAN (international bank account number), which is not required for this payment format.
EnterN (no) to suppress validation of the company's account IBAN, which is not required for this payment format.
EnterN (no) to suppress the validation of the supplier's SWIFT number, which is not required for this payment format.
EnterN (no) to suppress the validation of the company's account SWIFT number, which is required for this payment format.
Enter the currency code that you want to include in the payment format output. If you do not specify a currency code, the system uses the currency of the payment.
Enter a value that exists in the Special Validation Rules (70/VL) UDC table to have the system apply the validation routine.
|
Note: Because the German check format does not require a special validation routine, you should leave this processing option blank so that no validation is applied. |
This section discusses how to set processing options for version ZJDE0005 (Netherlands domestic EFT) of the Payment Information Extractor program (R704001).
Enter a value from the Check Translation (98/CT) UDC table to specify the translation program to use to convert numbers to words. If you leave this processing option blank, the system uses the translation program that is associated with the currency of the payment.
Use these processing options to limit the data that is extracted from the JD Edwards EnterpriseOne tables.
See How to Specify Information to Include in the Extract Overview
Enter Y (yes) or leave this processing option blank to include the extraction of bank account information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of payee information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of payee bank account information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of payor information, which is required for this payment format.
Enter N (no) or leave this processing option blank to prevent the extraction of document payable information, which is not required for this payment format.
Enter N (no) to suppress the validation of the supplier's IBAN (international bank account number), which is not required for this payment format.
EnterN (no) to suppress validation of the company's account IBAN, which is not required for this payment format.
EnterN (no) to suppress the validation of the supplier's SWIFT number, which is not required for this payment format.
EnterN (no) to suppress the validation of the company's account SWIFT number, which is not required for this payment format.
Enter the currency code that you want to include in the payment format output. If you do not specify a currency code, the system uses the currency of the payment.
Enter VLNETH to have the system apply the validation routine for the account ID code.
The system validates the bank account ID's length for bank account types P and B. If the length is invalid, the system issues an error message. If an account with an account type of B has a valid length (10 characters), the system runs an algorithm to valid the number. If the number is not valid, the system issues an error message.
Error messages appear in the Work Center.
This section discusses how to set processing options for version ZJDE0006 (Spanish EFT) of the Payment Information Extractor program (R704001).
Enter a value from the Check Translation (98/CT) UDC table to specify the translation program to use to convert numbers to words. If you leave this processing option blank, the system uses the translation program that is associated with the currency of the payment.
Use these processing options to limit the data that is extracted from the JD Edwards EnterpriseOne tables.
See How to Specify Information to Include in the Extract Overview
Enter Y (yes) or leave this processing option blank to include the extraction of bank account information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of payee information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of payee bank account information, which is required for this payment format.
Enter Y (yes) or leave this processing option blank to include the extraction of payor information, which is required for this payment format.
Enter N (no) or leave this processing option blank to prevent the extraction of document payable information, which is not required for this payment format.
Enter Y (yes) to validate the supplier's IBAN (international bank account number), which is required for this payment format.
EnterY (yes) to validate the company's account IBAN, which is required for this payment format.
EnterY (yes) to validate the supplier's SWIFT number, which is required for this payment format.
EnterY (yes) to validate the company's account SWIFT number, which is required for this payment format.
Enter the currency code that you want to include in the payment format output. If you do not specify a currency code, the system uses the currency of the payment.
Enter a value that exists in the Special Validation Rules (70/VL) UDC table to have the system apply the validation routine.
|
Note: Because the Spanish EFT payment format does not require a special validation routine, you should leave this processing option blank so that no validation is applied. |