Scenario
A user encountered an error while importing Purchase Orders through CSV Import in NetSuite.
The import failed with the message: “Invalid billaddresslist reference key xx for entity xx”
The user verified that all Vendor records already had default billing addresses configured and wanted to determine whether the billing address fields should be included in the CSV import mapping or whether NetSuite should automatically use the Vendor’s default billing address.
Solution
If the Vendor record already contains a default billing address, there is no need to map the Vendor Select field during the Purchase Order CSV Import.
The error occurs because the import mapping includes:
The Vendor Select field is used to specify a billing address from the Billing tab of the Purchase Order transaction.
When this field is mapped incorrectly or contains invalid values, NetSuite returns the invalid billaddresslist reference key error.
Recommended Approach
- Remove the Vendor Select mapping if the default Vendor billing address should be used automatically.
- NetSuite will automatically source the default billing address from the Vendor record during the import.
When to Use Vendor Select
Only map the Vendor Select field when a specific non default Vendor billing address needs to be used.
In that scenario:
- Use the actual Address Internal ID for the Vendor address record
- Ensure the address belongs to the selected Vendor
This setup allows the import to correctly assign a specific Vendor billing address during Purchase Order creation.
-----
If you find this information useful, let us know by reacting or commenting on this post!
