Has anyone encountered this error during a CSV imp...
# general
v
Has anyone encountered this error during a CSV import? 'Ambiguity error on logical key multi-match' I am trying to add lines to an existing sales order. Nothing useful on suiteanswers that I saw.
s
This is normally when you are trying to add multiple line items of the same item - it is am ambiguity error because NetSuite doesn't know if you want to update an existing line item or add a new one. You'll need to get the Line IDs from the original order, and then on your CSV add Line IDs to the new line items that do NOT match line IDs from the order
For example, if your order already has: LINE ID | ITEM 1 Item X 2 Item Y 3 Item Z And you want to add another line with Item X, you'll need to set the Line ID for that row in your CSV to 4 (or 5, 6, 7, etc., just not the existing line IDs)
v
Thanks for the tip, that allowed me to proceed with the import but then I came across this error: 'The record has been deleted since you retrieved it' SA ID 37516 says the solution is to not map the line id during the import.
s
Hmmmmm I found the same info - are you doing an add and update, or just update import?
v
Update, can't overwrite existing lines either. I've had this error in the past and usually just suck it up and do it manually. I'm thinking I'll have to do the same here.
182 Views