NetSuite cannot match a transaction or location line
Decide whether to update, add, or replace lines, then use the keys for that specific sublist.
A location-specific update is missing the location key
Message looks like
Adding New Line to Sublist Locations is not Allowed
What it means
The import is trying to add a new row to the item Locations sublist, and this import can only update the rows that already exist.
Import context: Item records.
Check this first
Map the location key inside the sublist so each row updates the existing location line.
Show the steps
Steps for this error
- Open the item’s Locations sublist and find the location row that should change.
- Map the location key inside that sublist along with the reorder point or stock value.
- Retry one item update and confirm that NetSuite changed the existing location row rather than trying to add one.
If that looks right
Documentation checked September 16, 2026.
A sales order reports a deleted line
Message looks like
The record has been deleted since you retrieved it
What it means
The update references order lines that no longer match what was retrieved, which Oracle resolves with the overwrite-sublists update setup.
Import context: Sales orders.
Check this first
Review the update setup: Update data handling, Overwrite Sublists checked, and no Line ID mapped.
Show the steps
Steps for this error
- This update path uses Overwrite Sublists: with Transactions as the import type, Sales Order as the record type, and Data Handling on Update, check Overwrite Sublists on the Advanced Options menu. Oracle marks that option with a caution because it replaces the existing lines.
- Confirm Line ID is not mapped to anything.
- Retry one order and verify its lines afterward.
If that looks right
Documentation checked September 16, 2026.
An update asks you to choose an item
Message looks like
Please choose an item to add
What it means
The update cannot tell which existing item line the row should change, so NetSuite asks for an item to be chosen.
Import context: Sales orders.
Check this first
Check how the rows identify existing lines before adding any item values.
Show the steps
Steps for this error
- Export the saved sales order’s Line or Order Line values.
- Match the failed CSV row to the intended existing line and keep its item reference consistent.
- Retry one update using the actual line identifier instead of the spreadsheet row number.
If that looks right
Documentation checked September 16, 2026.
Repeated items make line matching ambiguous
Message looks like
The exact wording varies. Messages for this case mention Ambiguity error.
What it means
The rows add or update several lines that use the same item on one transaction, and without line IDs NetSuite cannot tell them apart.
Import context: Transactions.
Check this first
Include a Line ID column: blank for new lines, or values above the highest existing line ID.
Show the steps
Steps for this error
- This appears when a file adds or updates several lines that use the same item on one transaction.
- Include a Line ID column. Leave it blank for lines NetSuite should treat as new, or use values above the highest existing Line ID.
- Import with Transactions as the import type and the matching record type, set Data Handling to Update, then verify the changed lines on one transaction.
If that looks right
Documentation checked September 16, 2026.
Sales-team contributions exceed 100%
Message looks like
Total contribution for sales reps cannot exceed 100%
What it means
The sales team already on the record plus the imported rows adds up past 100 percent, because without overwriting NetSuite merges the two teams.
Import context: Transactions.
Check this first
Add the imported contributions to the existing team before deciding whether to overwrite or adjust.
Show the steps
Steps for this error
- Add the imported contributions to the sales team already on the record; the combined total cannot exceed 100%.
- Without Overwrite Sublists checked, NetSuite combines the existing team with the rows in the file, which is the usual cause.
- Establish the complete intended team before choosing whether to overwrite or adjust contributions.
Documentation checked September 16, 2026.
Related errors
- An item on a received line cannot be changed
- The import has no linked item, expense, or member lines
- Vendor bill files or purchase order mappings conflict
- NetSuite cannot apply a payment or credit
Book a free 30-minute look at your import error
Bring the error and your file to a screen share and I will dig into it live. Thirty minutes is usually enough to find what is wrong and tell you what fixing it takes. Sometimes that settles it on the call; when it does not, you leave with a straight answer instead of a mystery. No cost and no obligation.
An import that keeps failing is often the first visible sign of a larger setup problem. Most of my client work starts exactly here: somebody mid-import, a file that will not load, and nobody on their side to email. If a migration or implementation sits behind this error, that is the work I do every week.