Bill Payments/Vendor Payments – CSV Import

Generating Bill payments from existing Bills through CSV Import. The Objective is to facilitate the seamless upload of Bill Payment creation files into the NetSuite (NS) system. Upon uploading these files, the system should autonomously generate bill payment records based on the enclosed data.

File Upload Mechanism and Automated Record Generation:

Determined the steps when importing vendor payment data. The CSV file contains the following fields :

External ID
Vendor ID
Payment Amount
ID of the Bill
Date

We must map external ID or internal ID to serve as a unique ID per record.

Vendor Payment transaction data can be imported in a single CSV file, or in multiple files.

Each imported Vendor Payment record should include a reference to a NetSuite Vendor record, mapped to the Vendor Payment’s Payee field. This reference should match exactly the Vendor ID field value in the Vendor Record.

Existing Bills in OPEN status>>