Once the EF documents have been processed, all accepted EF documents are passed to an EFT file generation process (EF ACH Generation job). This process generates an EFT file in record formats consistent with The Electronic Payments Association (NACHA) standards. The formats supported by CGI Advantage Financial are:
Cash Concentration and Disbursement (CCD+): Developed by NACHA for the electronic transfer of funds between companies and trading partners.
Corporate Trade Exchange (CTX): An electronic funds transfer format compatible with ANSI ASC X12 that carries information about both payments and transferring values.
Prearranged Payment or Deposit (PPD+): Developed by NACHA for the electronic transfer of funds between companies and trading partners.
International ACH Transactions (IAT): Developed by NACHA for the electronic transfer of funds between countries.
This process posts the EFT Number assigned by the AD Chain process for successfully submitted EFT documents to the ID Number of the credit payment record (“6”) on the ACH file. This process only selects those EFT documents that are greater than zero and includes them in the output file that will be sent to the Banks.
This process also posts detailed information on the Addenda records where it generates a single Addenda record for each Accounting Line associated with an EFT Document. If an EFT Accounting Line has any adjustments (for example, intercept, discount, interest), then each adjustment amount associated with the Accounting Line is also posted to a separate Addenda record. The following information is posted to the ACH CTX Addenda Records:
Payment Request ID
Vendor Invoice Number
Amount (Payment, Discount, Intercept, etc.)
The first 20 characters of the Check Description or one of the following values based on the amount type in case of adjustments (Discount, Backup Withholding, 3402(t) Cntrc Wthhld, Penalty, Interest, Retainage, Freight, Intercept, Tax or Use Tax).
However, the information posted to the Addenda records is not formatted based on the Exchange Data Interchange (EDI) ANSI ASC X12 Transaction Set 820 Remittance Advice/Payment Order.
Additionally, this process generates a summary debit payment (“6”) within each Batch in the ACH file. The amount posted to this record represents the sum amounts of all the credit payments within a Batch.
If the EFT Payments are disbursed from more than one Bank Account Code during an AD Chain run, then the EF ACH Transaction process will group the EFT payments having the same Bank Account Code together (i.e. in a separate ACH batch) within the ACH file.
The Advantage 3 baseline EF ACH Transaction batch process has the parameter 'REGEN_ACH_FILE' which can be set to 'yes' or 'no' (default value) as well as the parameters 'From Run ID' and 'To Run ID'. These parameters can be utilized to regenerate an ACH file with EFT payment for specific Run ID or a range of Run ID’s. In this case the parameter 'REGEN_ACH_FILE' must be set to 'yes'.