ANS-1863 · CSV IMPORT & DATA MIGRATION
How to Ensure Sales Order Addresses Source from Customer in NetSuite CSV Imports
When importing sales orders via CSV, proper handling of address fields is crucial to ensure Bill To and Ship To details are automatically populated from the associated customer record.
Short answer
To ensure NetSuite sales orders automatically source Bill To and Ship To addresses from the customer record during CSV import, it is essential to omit these specific address fields from your CSV file. By not including them, NetSuite's default behavior will populate the addresses directly from the linked customer, preventing blank or incorrect address data on the sales order.
Scenario
Users importing sales orders into NetSuite via CSV may encounter issues where Bill To and Ship To addresses are not correctly populated from the customer record. This can lead to sales orders with missing or incorrect address information, requiring manual correction and potentially impacting downstream processes like shipping and billing.
Solution
To ensure that Bill To and Ship To addresses on sales orders are correctly sourced from the associated customer record during a CSV import, follow this guideline:
Do not include the Bill To and Ship To address fields in your CSV file. By omitting these fields, NetSuite will automatically retrieve and populate the addresses from the customer record linked to the sales order, leveraging its default address sourcing mechanism.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support