I'm getting this error when doing a sales order im...
# ask-stanley-ai
v
I'm getting this error when doing a sales order import to add items. The record has been deleted since you retrieved it. I mapped line id and have the same item more than once to add to an order. is there a specific set of fields to add to a csv import when adding multiple of the same item to an existing order?
c
AI generated answer (using internal Slack threads):
Based on the conversations, it seems that you are encountering an issue when trying to add multiple line items of the same item to an existing sales order via CSV import. The error message 'The record has been deleted since you retrieved it' is typically encountered when there is an ambiguity in the line items being added. To resolve this, you need to include the Line ID in your CSV file. The Line ID should be unique for each line item in the order. For example, if your order already has:
Copy code
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). However, if you are updating an existing sales order and want to add new lines, you need to ensure that the Line ID for the new lines does not match the Line IDs of the existing lines in the order. Please note that the Line ID is not the same as the unique line id that NetSuite generates. You should use the Line ID field with the key next to it on the mapping screen during the import process. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.872497559
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.86553961
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.859558105
Please provide your feedback on this answer.