Add/ Remove Multiple Line Items on a Transaction via CSV Import

Having trouble with the error: “Ambiguity error on logical key multi-match”? This article helps you to add multiple line items with the same item on a transaction via CSV Import or you would like to add new line items to existing transactions using CSV file uploads.

When you need to update existing transaction records through CSV import, you might have encountered the error: “Ambiguity error on logical key multi-match”. It could confuse you when you insert a new line in an already existing transaction, such as a sales order (opportunity, estimate, quote, return authorization, invoice, credit memo) or purchase order (vendor bill).  

Typically, you would use Line ID to help you key on and reference specific transaction lines. The MUST action item is to leave the Line ID blank (null) during your CSV Update so that NetSuite acknowledge this as a new line insert request. You will need to add the blank column (field) to your CSV upload so that you can assign the NetSuite’s Item Line ID as null.   

For example, you want to add the line items to an existing sales order via CSV import. Also, you have the same line items multiple times. 

1. The Sales Order has the following items: 
   1. 1. Item A - Quantity 10 
      2. Item B - Quantity 20 
         
      
      
2. User wants to update the Sales Order to: 
   1. 1. Item A - Quantity 10 
      2. Item B - Quantity 20 
      3. Item A - Quantity 10 
      4. Item A - Quantity 20 
         
      
      
3. Steps to update the example transaction: 
   1. 1. Create a CSV file that has the Line ID column. Set the column value as blank. 
         1. 1. Sales Order's Internal ID 
            2. Item Name 
            3. Quantity
            4. Price
            5. Tax Code 
            6. Line ID 
      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: 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:
          
          
          
      11. Click Next. 
      12. Provide an Import Map Name. 
      13. Click Save & Run. 

This completes the upload. To share my experience, I uploaded the same line items via CSV import. Using the above example, I uploaded “b) 4. Item A - Quantity 20”. I will also briefly show you how to remove specific line item(s) in a Sales Order through a CSV Import. 

1. Create a CSV Import File with the following columns/values: 
   1. 1. Sales Order Internal ID 
      2. Item Line ID (Refers to all Line Items to be retained) 
         
      
      
2. You may create a Sales Order Transaction Saved Search to pull up above fields.    
   1. 1. Lists > Search > Saved Searches > New. 
      2. Click on Transaction link. 
      3. Under Criteria tab > Standard subtab, add the following fields:  
         1. 1. Type = is Sales Order 
            2. Main Line = is false 
            3. Tax Line = is false 
            4. Shipping Line = is false 
      4. Under Results tab > Columns subtab > Add the following filters: 
         1. 1. Internal ID 
            2. Line ID 
      5. Edit the Search Title as desired 
      6. Click Save & Run. 
      7. Click Export - CSV button to export the file. 
      8. Modify the exported file to only show the row(s) referencing to the Item Line ID(s) to be retained after the import. 
         
      
      
3. Navigate to Setup > Import/Export > Import CSV Records. 
   1. 1. Scan & Upload CSV File 
         1. 1. Import Type = Transactions 
            2. Record Type = Sales Order 
            3. Charter Encoding = Western (Windows 1252) 
            4. Select One file to Upload 
      2. Import Options 
         1. 1. Data Handling = Update 
            2. Under Advanced Options > Overwrite Sublists = TRUE 
            3. Click Next.  
      3. Field Mapping 
         1. 1. Internal ID = Internal ID (Could be found under the Sales Order folder) 
            2. Line ID = Item: Line ID (Could be found under the Sales Order Items folder) 
      4. Click Next 
      5. Enter an Import Map Name. 
      6. Click & Save Run. 

Note: It is highly suggested to update one sales order record first to check on the result and for testing purposes 

If you want to learn more about NetSuite CSV import or need help with Saved Search, please contact Concentrus today to discuss your needs. 

About Us

Concentrus is a complete NetSuite solutions provider that guides organizations through how to use NetSuite to reach highly focused business goals and objectives. We provide NetSuite implementation, developer, integration, and customization services to ensure that you have a long-term solution that is tailored to fit your systems, people, and processes.

Read About Our Implementation Methodology

Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos