Requirement
Pure care currently uses ACH Coastal but wants to switch to the electronic bank payments
NetSuite app as the Coastal option is soon obsolete. The bundle for electronic bank payments
has already been installed.
Pure care pay vendors by direct deposit into their bank account and take funds from their
customer’s bank accounts by EFT and deposit the funds into our bank account.
NetSuite can export payment in file format #1464 (CPA 005) and also ScotiaConnect bank
accepts file format #1464 (CPA 005) for uploading payments to the bank.
The file formats (#105 and #1464) attached that the bank accepts in order for the payment
file to be accepted by the bank and processed successfully.
Our Solution
The requirement can be achieved by creating an EFT template in text format using the
provided sample file for all currencies based on the requirement.
We need to create new company bank details and Entity bank details in NetSuite for the new
Payment file template
We need to link the bank info and update EFT bill payment flag on the entities record.
Then the template needs to be tested by creating the vendor bills for the test vendor and
need to do the bill processing for verification
Field Mapping
Assumptions
● The output file format will be text and all characters in the text file will be capital
letters.
● We will restrict Special characters in NetSuite fields.
● Pure care should be sharing the company bank details.
● We will extract the existing bank details from the vendor and customer record to
creating the vendor/customer bank details record for the EFT processing. If the
system restricting to retrieve any field data, pure care must be providing the
necessary information.
● We will share the sample files with required fields to create the bank for the
company and entities.
● We will share the list of Vendors/ Customers. Pure care will send back the file
which should show whether the vendor/customer prefers to pay through EFT
Risks
● We will give only the mentioned validations for fields. (Please check the
validations)