Add the Bank Details to the vendor record via CSV.

Scenario: Client needs make create a bank detail via CSV import which needs be attached to the vendor record that already exist.

Solution:

Navigate to Setup > Import/Export > Import CSV Records

Import Type: Select Custom Records
Record Type: Select Bank Details
Click Select button
Click on the preferred CSV file
Click Open
Click Next

Data Handling: Add
Click Advanced Options
Custom Form: Select Standard Entity Bank Details Form
Run Server SuiteScript and Trigger Workflows: Enter Checkmark
Click Next

Configure the following on Field Mapping:
Your Fields

CSV File : NetSuite Fields

Employee ID : Parent Employee
Bank Account Number : Bank Account Number
Branch Number : Branch Number
Type : Type
Payment File Format : Payment File Format

Click Next
Import Map Name: Enter Name
Click Save & Run

Leave a comment

Your email address will not be published. Required fields are marked *