Import Sales Order with Multiple Items

SCENARIO

User wants to import sales orders into NetSuite and wants to know how to create the CSV file so multiple line items are assigned to the correct sales order number.

SOLUTION

Create the CSV file as follows. All related line items should have the same External ID and Customer.

External ID	Item	Qty	Amount	Customer
ABC123	jelly	5	3.15	A
ABC123	Item B	6	20	A
XYZ123	Item C	2	5.25	B
XYZ123	Item D	3	10.25	B

Notes:
1. External ID is any alphanumeric combination that you can assign to each transaction. This information is not viewable anywhere in the transaction form.
2. To prevent import errors due to duplicates, it is advisable to use External ID as key field instead of Sales Order #. The latter requires you to find the latest Sales Order # created in the system and prevent any user from creating sales orders until the import is finished.