This chapter contains the following topics:
The Common Global Implementation (CGI) Initiative aims to extend the scope of multi-bank payment format implementation guideline based on the ISO 20022 XML payment. The initiative provides a forum for global, multi-country, multi-bank, and multi-instrument implementations.
The conditions that are specific to the ISO 20022 CGI payment file format are:
The payment currency can be any currency.
There is no restriction on the disbursement bank branch location and payee bank branch location.
The payee bank account is required for all electronic funds transfers (EFTs).
To create the CGI payment XML file in the JD Edwards EnterpriseOne system, you set up your company and supplier bank accounts with the BIC number and IBAN. When you use the Write process in the automatic payment process, the system writes records to an XML file for accounts. You then send the XML file to the bank.
The JD Edwards EnterpriseOne system supports the creation of the credit transfer XML payment format. The XML file is created for CGI credit transfer payments when you run the automatic payment process. However, the system does not support the transmission of the XML file to the bank.
When you use the automatic payment process in the JD Edwards EnterpriseOne software, you specify the payment print program to use. The payment print program controls how the system writes records to the database tables.
For CGI payments, you set the payment print program to P744003, version ZJDE0001, and run the Write process of the automatic payment process to create the XML file.
|
Note: JD Edwards EnterpriseOne software does not support the transmission of the XML file to the bank. The software includes only the functionality to generate the XML file. |
When you run the automatic payment process that is set to use the R744003 program for CGI payments, the system:
Generates a PDF file that shows whether the process completed successfully or with errors.
Generates the XML file.
Changes the payment status of the group from WRT (write) to UPD (update) if the process was completed successfully.
You can also write single payments of a group by using the Work With Payment Group - Write Status program (P04572W). The system generates the CGI Credit Transfer XML file only for payments written in the Work With Payment Group - Write Status form.
To write single payments:
Launch the Work With Payment Groups program (P04571).
Select the payment control group.
Access Payments from the Row menu.
In the Work With Payment Group - Write Status form, select one or multiple payments of the group, and select Write from the Row menu.
The XML includes three blocks of records. Block A is the message root. Block B is the Group Header block, which includes a description of the XML file and the initiating party. Block C is the Payment Information block and includes a set of parameters, which apply to the debit side of the credit transfer transaction. Block C also includes the Credit Transfer Information elements, which can have one or multiple transaction records.
See Bank Payment ISO20022 CGI Format - XML Layout (Doc ID 2259096.1)
The system displays an error in the following circumstances:
The Category Purpose processing option is blank.
The Payment Purpose processing option is blank.
The Debtor element is blank.
The Debtor ID element is blank.
The Ultimate Debtor element is blank.
|
Note: If the Ultimate Debtor address book number is equal to Debtor address book number, the system does not print this tag or display an error. |
The Ultimate Debtor ID element is blank.
The Creditor element is blank.
The Creditor ID element is blank.
The Ultimate Creditor element is blank.
|
Note: If the Ultimate Creditor address book number is equal to Creditor address book number, the system does not print this tag or display an error. |
The Ultimate Creditor ID element is blank.
The Address Line element is blank.
The payment currency specified in the Currency Code processing option for R744003, ZJDE0001 version is different from the currency of the payment group.
The IBAN and BIC (SWIFT Code) elements of the debtor and creditor are blank. This error message is displayed only if you set the processing options to validate the IBAN and the BIC for the debtor and the creditor bank accounts.
If there are errors, the system does not advance the payment group next status to UPD (update).
The system includes the Payment Group Control Number in error messages written to the Work Center. This number helps you identify payments that have errors.
If the system determines that the country of the company or supplier is blank, the system writes a warning message to the Work Center, and changes the status of the payments from Write to Update.
If a payment control group has two or more payments and some of them have errors, the system advances the payments without errors to the update status, but does not advance the payments with errors to the update status. In this case, the system generates the XML only for those payments that are written (the ones without errors).
The Payment Information Extractor program (R744003) for CGI generates an XML file that you submit to the banking system. The program generates some information, such as addresses, using the language that is set up in your system. The banking system cannot process all of the special characters that exist in all languages. If your JD Edwards EnterpriseOne system generates the XML file with unacceptable characters, you can set up your system to substitute acceptable, alternative characters for the unacceptable characters.
You set up the Replace Character In String (70/RS) UDC table with the acceptable characters to use in place of the unacceptable characters. You then specify in a processing option in the ZJDE0001 version of the Payment Information Extractor program (R744003) that you want to use the 70/RS UDC table to substitute characters in the XML output file.
When you set up the 70/RS UDC table, you can specify one or more alternative characters. When you specify multiple alternative characters, the length of the string that is altered does not change; if the original string is three characters, the modified string is three characters. The system drops certain characters from the string if inserting all of the alternate characters will result in the modified string exceeding the allowed length of the string.
These examples illustrate how the system replaces a single character with multiple characters:
Original string is ABC.
Modified string is FGB.
To retain the field length of three, the system drops the C from the string.
Processing options enable you to set default processing values for programs and reports.
|
Note: You can access the processing options by selecting CGI Credit Transfer Processing Options (P744003) from the General CGI XML menu (G74CGICT). |
Before you begin, review the processing options for this program.
Specify an ISO standard code from the UDC table (74/PC) to identify the purpose of the collection. If you leave this field blank, the system displays an error in the report and does not advance the payment to the update status.
Specify an ISO standard code from the UDC table (74/CP) to identify the category purpose of the collection. The categories can include salary payment, supplier payment, or tax payment. If you leave this processing option blank, the system displays an error in the report and does not advance the payment to the update status.
Specify a value from the UDC table (74/IP) that indicates the level of urgency applied to the processing of the instruction. Values are:
HIGH: Priority level is high.
NORM: Priority level is normal.
Specify if the batch booking element in the XML is TRUE or FALSE. Values are:
TRUE: It is a batch entry for the sum of the amounts.
FALSE: It is a single entry for each of the transactions in the message.
If you leave this processing option blank, the system does not populate <BtchBookg> tag in the XML file.
Specify a local instrument or a local clearing option or both to further qualify the service or service level as published in an external local instrument code list.
Specify the mode that the system uses for the remittance information. Values are:
Blank: Structured
1: Non-structured
Specify the field that the system uses to retrieve the remittance identification issuer if the remittance information mode is structured. Values are:
Blank: Mailing name of the supplier
1: Country of the supplier
The system retrieves the value from UDC 74/IC based on the supplier's country.
2: User-defined value
If you specify this value for this processing option, you must set the Remittance Identification Issuer value processing option.
If the remittance information mode is unstructured, you do not need to specify a value for this processing option.
If Remittance Information Mode is structured and the Remittance Identification Issuer processing option is set to the user-defined value, specify the value to populate the remittance identification issuer value into the XML. If you leave this field blank, the Issuer field will not be populated.
Specify whether to include the XML element tag Town Name <TwnNm> for the Debtor in the XML output file. Values are: Blank: Include it. You must have a value set up in the Address Book.
1: Do not include it.
Specify whether to include the XML element tag Postal Code <PstCd> for the Debtor in the output XML file. Values are:
Blank: Include it. You must have a value set up in the Address Book.
1: Do not include it.
Specify whether to include the XML element tag Town Name <TwnNm> for the Creditor in the output XML file. Values are:
Blank: Include it. You must have a value set up in the Address Book.
1: Do not include it.
Specify whether to include the XML element tag Postal Code <PstCd> for the Creditor in the output XML file. Values are:Blank: Include it (default). You must have a value set up in the Address Book.
1: Do not include it.
Processing options enable you to set default processing values for programs and reports.
|
Note: You can access the processing options by selecting the CGI XML Credit Transfer (R744003) program from the General CGI XML menu (G74CGICT). |
Before you begin, review the processing options for this 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.
Specify whether to use replacement characters from UDC 70/RS. Values are:
Y: Yes
N or Blank: No
Specify if there will be single or multiple invoice occurrences per remittance information. Values are:
Y: Inform several invoices.
N or Blank: Inform only one invoice.
Specify the next number that the system will use for matching document with document type PT. Valid 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)
Use these processing options to limit the data that is extracted from the JD Edwards Enterprise One tables.
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.
Enter Y (yes) to validate the company's account IBAN, which is required for this payment format.
Enter Y (yes) to validate the supplier's SWIFT number, which is required for this payment format.
Enter Y (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.
Specify VLCGI to have the system apply validations for CGI credit transfer files and to print XML tags.
This is a mandatory field.
The system 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 the 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.