The primary purpose of this document is to provide all parties with guidance within regards to the core functionality in relation to the COINS – any ABA File transfer Integration with bank and COINS (from different modules such as Cash Book, Accounts Payable, Subcontract Ledger, Payroll and Expenses).
General Information of Functionality
The functionality transmits any ABA file transfer from COINS to bank.
The ABA files will transfer from COINS different modules - Cash Book, Accounts Payable, Subcontract Ledger, Payroll and Expenses.
The ABA files will be encrypted using public key and transfer to bank’s secure folder.
Configuration/Setup of Functionality
The following three values are to be updated in COINS BACSEXEC parameter in the different modules:
For Payroll (PR) – Format is BACS<Bank>PR (If it’s CBA then BACSCBAPR).
For all finance modules - Accounts Payable (PL), Subcontract Ledger (SC) and Expenses (EX), Cash Book – Format is BACS<Bank>AP (If it’s CBA then BACSCBAAP).
Payroll
Cash Book
Accounts Payable
Subcontract Ledger
Expense Module
Setting the respective module’s BACSEXEC parameter to the supplied values will enable the transfer of ABA files from COINS into banks.
To switch off the automatic aba file transfer from COINS, you need to remove the above values from the modules. It’s recommended to create the parameter as Company Specific to manage the parameter BACSEXEC.
Note: By default, non-live environments will NOT transmit any ABA files to any bank. For UAT in the non-live environment, the clients should contact COINS Technical team and confirm the non-live environment for testing so that we will flip a switch that forces the routine to ignore the fact that it is not running in LIVE and send the file anyways to bank for test confirmation.
EFT Forms – The EFT forms on the bank account set up maintenance to be changed to SSABA01 for the aba file automation.
Process
Create EFT from different modules
The process is to run the standard EFT process in COINS from different modules such as Cash Book, Accounts Payable, Subcontract Ledger, Payroll and Expenses.
Refer to the sample Screenshots from Accounts Payable and Subcontract Ledger:
Accounts Payable:
Note: It’s highly recommended and the client needs to ensure that the EFT file has been received and validated by the banks before posting the payment batch in COINS ERP+.
Subcontract Ledger:
Note: It’s highly recommended and the client needs to ensure that the EFT file has been received and validated by the banks before posting the payment batch in COINS ERP+.
2. Email notification to users
Email notifications can be enabled, and different users can be added/notified to the different modules. The users list needs to be provide to the COINS Technical Team.
Refer to the below sample email notification: