Before users can import Entity Bank Details, Vendor records which will be updated need to have the 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.
Solution
1. Navigate to Setup > Import/Export > Import CSV Records
2. Import Type = Custom Records
3. Record Type = Entity Bank Details
4. Select your CSV template > click Next
5. Data Handling = Add (NOTE: Click on Advanced Options then under the Custom Form, select Standard Entity Bank Details Form)
6. 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.
7. Field Mapping:
- Bank Account Number <=> Entity Bank Details : Bank Account Number
- Bank Account Type <=> Entity Bank Details : Bank Account Type
- Bank Number <=> Entity Bank Details : Bank Number
- Type <=> Entity Bank Details : Type (Req) Delete
- Payment File Format <=> Entity Bank Details : Payment File Format (Req)
- External ID <=> Entity Bank Details : ExternalId
- Name <=> Entity Bank Details : Name (Req)
- Vendor ID <=> Entity Bank Details : Parent Vendor
*Select the pencil icon for Vendor ID and select Internal ID for Choose Reference Type instead of Names
8. Click Next and Add a name on the import.
9. Click Save and Run.
SAMPLE CSV TEMPLATE:
╔═══════════╦═════════╦═════════════════════╦═════════╦═════════════════════╦═════════════╦═══════════════════╦═════════════╗ ║ Vendor ID ║ Name ║ Payment File Format ║ Type ║ Bank Account Number ║ Bank Number ║ Bank Account Type ║ External ID ║ ╠═══════════╬═════════╬═════════════════════╬═════════╬═════════════════════╬═════════════╬═══════════════════╬═════════════╣ ║ 278 ║ EP Bank ║ ACH – CCD/PPD ║ Primary ║ 10101010101234500 ║ 211370545 ║ Checking ║ 123xyz ║ ╚═══════════╩═════════╩═════════════════════╩═════════╩═════════════════════╩════