The following article is a guide on how to import vendor entity bank details via csv
Before users can import Entity Bank Details, Vendor records which will be updated need to have EFT Bill Payment checkbox enabled under Bank Payment Details subtab. This can be done via CSV Import or Mass Update.
After updating this field, users can now do a CSV Import for the Custom Record called Entity Bank Details.
The association happens by selecting the Vendor ID of the Vendor on the Parent Vendor field during the mapping stage.
Create the CSV template to be used for CSV Import. This should contain the Vendor ID of the Vendors to be updated and all the Entity Bank Details for the specific Payment File Format to be imported.
Limit each import file to 1 type of Payment File Format as it is not possible to import Entity Bank Details with different Payment File Format at the same time.
Before starting the import, make sure that Run Server SuiteScript and Trigger Workflows checkbox is enabled in CSV Import Preferences.
Note: You will need to contact JCurve Support in order to enable the above setting 'Run Server SuiteScript and Trigger Workflows'.
Here are the steps for the import process:
- Navigate to Setup >Import/Export > Import CSV Records
- Import Type = Custom Records
- Record Type = Entity Bank Details
- Select your CSV template> click Next
- Data Handling = Add (NOTE: Click on Advanced Options then under the Custom Form, select Standard Entity Bank Details Form)
- By this point, you will see a lot of fields for Entity bank Details. This is because Payment File Formats have different fields and they are all listed here.
- Field Mapping:
Primary = Type (Req)
<Select the Payment File Format you want to Import. Please take note that some Payment File Templates have duplicates in the list as the list in the dropdown does not filter by type so choose carefully [EFT vs DD]> = Payment File Format (Req)
Vendor ID = Parent Vendor
Then map all the fields for your specific Payment File Format you will upload. For this sample, let's use ABA:
Bank = Bank Number
Branch = Branch Number
Bank Account Number = Bank Account Number
Bank Account Name = Bank Account Name
Bank Account Payment Description = Bank Account Payment Description
- Click Next
- Put a name on the import
- Click Save and Run
Once import is done, Entity Bank Details for Vendors become available.