3 Working with BI Publisher for Payment Formats in Brazil

This chapter provides includes these topics:

3.1 Understanding Payment Format Processing Options for the Brazilian Check 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 Brazilian check payment format, make a copy of version ZJDE0001 only. If you use a copy of any other version, the system will not use the correct report definition or payment format template.

3.2 Setting Processing Options for the Brazilian Check Payment Format

This section discusses how to set processing options for version ZJDE0001 (Brazilian Check) of the Payment Information Extractor program (R704001).

3.2.1 General

Translation Program

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.

3.2.2 Performance

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

1. Bank Account Information

Enter Y (yes) or leave this processing option blank to include the extraction of bank account information, which is required for this payment format.

2. Payee Information

Enter Y (yes) or leave this processing option blank to include the extraction of payee information, which is required for this payment format.

3. Payee Bank Account Information

Enter N (no) to suppress the extraction of payee bank account information, which is not required for this payment format.

4. Payer Information

Enter Y (yes) or leave this processing option blank to extract payor information, which is required for this payment format.

5. Document Payable Information

Enter N (no) to suppress the extraction of document payable information, which is not required for this payment format.

3.2.3 Validations

1. Supplier's IBAN

Enter N (no) or leave this processing option blank to suppress the validation of the supplier's IBAN (international bank account number), which is not required for this payment format.

2. Company's Account IBAN

Enter N (no) or leave this processing option blank to suppress the validation of the IBAN for the company's account, which is not required for this payment format.

3. Supplier's SWIFT

Enter N (no) or leave this processing option blank to suppress the validation of the supplier's SWIFT number, which is not required for this payment format.

4. Company's Account SWIFT

Enter N (no) or leave this processing option blank to suppress the validation of the company's account SWIFT, which is not required for this payment format.

5. Currency Code

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.

6. Special Validation Rules

Enter a value that exists in the Special Validation Rules (70/VL) UDC table to have the system apply a special validation routine.


Note:

Because the Brazilian check format does not require a special validation routine, you should leave this processing option blank so that no validation is applied.