Add Multiple Line Items with the Same Item on a Transaction Through CSV Import Throws Ambiguity Error

The user wants to add line items to an existing transaction (e.g Sales Order) via CSV Import. The line item information in the CSV import uses the same Item record.

The Sales Order has the following items:

• Item X -- Quantity 1
• Item Y -- Quantity 2

User wants to update the Sales Order to:

• Item X -- Quantity 10
• Item X -- Quantity 11
• Item X -- Quantity 12

To accomplish this, perform the following steps:


     1. Create a CSV file that has the Line ID column. Set the column value as blank.

     Sample CSV file format:

     Sales Order's Internal ID, Item Name, Quantity, Price, Tax Code, Line ID

     Note: The Line ID of new items can be assigned a new value. The system will know these new items added in the same transaction. Ex. Last line ID in the transaction is 10. Users can assign Line ID higher than 10 so it would not return an 'Ambiguity Error' message.

     2. Navigate to Setup > Import/Export > Import CSV Records.
     
     3. Select Transactions in the Import Type field.
     
     4. Select the transaction type in the Record Type field (e.g. Sales Order).
     
     5. Click Select.
     
     6. Locate the CSV file then click Open.
     
     7. Click Next.
     
     8. Select Update for Data Handling.
     
     9. Click Next.

   10. In the Field Mapping, map the following:   

 

Your Fields	NetSuite Fields
SO Internal ID	Internal ID
Item Name	Items: Item
Quantity	Items: Quantity
Price	Items: Rate
Tax Code	Items: Tax Code
Line ID	Items: Order Line

     

     11. Click Next.
     
     12. Provide an Import Map Name.
     
     13. Click Save & Run.