Thursday, March 28, 2019

Importing ACH - CCD/PPD Entity Bank Detail does not Auto Populate Fields: Check, Bank Code, Processor Code

1) Ensure that the Run Server SuiteScript and Trigger Workflows preference is enabled under Setup > Import/Export > CSV Import Preference. This will help populate fields: Check, Bank Code, Processor Code, in the Entity Bank Detail form. Users may go back and disable it when done with the import.

2) Get the Internal ID of the already imported Entity Bank Detail under List > Search > Saved Searches > New

---> Choose Entity Bank Details

---> In the Criteria tab > choose ACH - CCP/PPD

---> Click Results tab > add :

* Internal ID

* Parent Vendor

* Type

* Bank Account Number

* Bank Number

* Bank Type

3) Export to CSV > Save as CSV file

4) Import the file above via Setup > Import/Export > Import CSV Records

---> Import Type = Custom Records

---> Record Type = Entity Bank Details > choose file > Next

---> Handling Option = Update

---> Click on Advanced Options > Custom form = choose Standard Entity Bank Details from > Next

---> Map CSV Fields to NetSuite fields

----> Next > Save & Run

No comments:

Post a Comment