NetSuite CSV Error Translator
Paste the error. Find out what to check.
NetSuite import errors don't always tell you where the problem is. Find the message below for an explanation and a few practical checks.
You can paste the whole message, including any record numbers.
Your search text stays in this tab unless you choose to send it for review. We count unsuccessful searches without recording the message.
Common places imports get stuck
35 matching guides covering 119 explanations.
The catalogue covers 119 error entries across 35 guides.
Transactions
An item on a received line cannot be changed
NetSuite is rejecting an item change because it considers the affected line already received. That does not establish why the import is changing the item. One possibility is that the CSV row points to a different line than you intended, even if your goal was only to update a date, price, or custom field. Compare the transaction, line, and item in the CSV with the saved transaction. Then decide whether this row should update an existing line, add a new one, or replace its item.
Inventory cost revaluations · Customers · Custom lists · Transactions
NetSuite cannot identify the record to import
Check which record the identifier belongs to and whether the import expects a name, internal ID, or external ID.
General imports · Inventory cost revaluations · Leads and prospects · Transactions
NetSuite says the record already exists
Find the existing record before deciding whether to add a new one or update what is already there.
Kits and packages · Related items · Sales orders · Invoices and credits · Manufacturing cost templates
NetSuite cannot match an item in a CSV import
Check the item reference in the right context: a transaction line, kit member, related item, or manufacturing cost template.
Item records · General imports · Inventory items
The item unit or record type does not match
Check the item type and unit type before changing purchase, sales, or stock units.
General imports · Inventory items · Item records · Chart of Accounts · Vendor-Subsidiary Relationship
NetSuite could not match a record or parent item
Check the record identifier first. For parent or matrix-item errors, use the conditional item hierarchy checks.
Item records · Website categories · Employees and expense categories · Leads and prospects
A list or custom field selection cannot be matched
Check the list behind the field, the allowed selection, and the mapping reference type.
General imports · Journal entries · Time entries · Item records · Purchase orders
An account, vendor, employee, or entity cannot be matched
Check the record identity and whether its subsidiary, currency, and active state fit the import.
General imports · Journal entries · Vendor bills
A department or location cannot be matched
Compare the reference type, hierarchy, active state, and subsidiary of the selected record.
Customers · Customers with contacts · Prospects with contacts
Customer type or linked contact data needs attention
Distinguish a customer-only import from a combined customer or prospect and contact import.
General imports · Related items · Inventory cost revaluations · Sales orders · Expense reports · Leads and prospects · Employees and expense categories · Customers
A required field is missing or cannot be written
Find the exact field, its mapping, and the form or sublist that requires it.
Sales orders · Journal entries · General imports · Expense reports · Transactions
NetSuite cannot read the date or posting period
Compare the saved CSV text with the importing user’s date format and the intended date or period.
Events
Event dates or times are missing or invalid
Check the event’s start and end values, date format, and whether it spans dates.
General imports · Customers
Country and state values do not match
Check the country name used by the account and the state or province allowed for that country.
Journal entries · General imports
NetSuite cannot read the CSV file or its columns
Inspect the saved file for encoding, separators, quoted fields, headers, and unintended records.
General imports · Item records · Vendor bills · Journal entries · Single Journal Entry import · Intercompany journal entries
Numbers or identifiers changed in the CSV
Inspect the saved value and compare it with the original before changing precision or number formatting.
Expense reports · General imports
NetSuite CSV import says an amount is missing
Check which field supplies the amount and whether the expense line also needs a rate or quantity.
Vendor bills
The header amount disagrees with the lines
The supplied header amount disagrees with the lines. Review whether that header mapping belongs here.
Inventory adjustments
Inventory status does not match the stock being removed
NetSuite could not use that status with the inventory detail on this line. The status might exist elsewhere, but the import still needs the correct item, location, lot, bin, and status combination. Verify how Status is mapped. If the file contains an internal ID, the mapping must use that reference type. Then inspect the exact inventory balance the line is meant to reduce.
Inventory adjustments
Inventory adjustment quantity exceeds available stock
The requested quantity exceeds the quantity NetSuite will allow for the selected inventory detail. The difference can be too small to notice in the spreadsheet. Compare the full saved quantity with the available quantity using the same unit. Check other rows drawing from the same balance too.
Inventory worksheets
A worksheet asks for inventory detail
This inventory worksheet is encountering a bin-detail requirement. Confirm that this is the worksheet import, rather than an inventory adjustment, before using worksheet-specific guidance.
Item records · Sales orders · Transactions
NetSuite cannot match a transaction or location line
Decide whether to update, add, or replace lines, then use the keys for that specific sublist.
Sales orders · Invoices and credits · Assemblies · Manufacturing cost templates · Expense reports · Manufacturing routings
The import has no linked item, expense, or member lines
Check the detail mapping and how each item, expense, member, or operation row connects to its parent record.
Vendor bills
Vendor bill files or purchase order mappings conflict
Check bill headers, linked detail files, and whether the bill is sourced from a purchase order.
Vendor payments · Invoices and credits · Customer payments
NetSuite cannot apply a payment or credit
Identify the payment separately from the bill or invoice, then check the document’s open amount and application rows.
General imports · Inventory items · Item records · Manufacturing routings
Multiple selections are split, repeated, or missing
Check the separator and the complete intended set. Routing locations have their own whitespace requirements.
Item records
Item prices or quantity breaks cannot be imported
Check the starting price, price level, and existing matrix before deciding how the pricing should change.
Custom lists · Inventory items · Item translations
Item or custom list translations cannot be imported
Check language setup, translation mappings, and whether the main record needs to be created first.
General imports
NetSuite import failed after the record was created
Check what saved before retrying. A script or later processing step can fail after the record exists.
General imports
A saved search cannot be accessed
A field depends on an inaccessible search. Check existence and audience.
Item translations · Assemblies
NetSuite reports an unexpected error during import
Choose the import context before following a documented example. A generic error alone does not establish the cause.
General imports
Personal language settings differ
Language settings may slow the import. Compare preferences.
Item demand plans
An item demand plan has an identity or date mismatch
Distinguish the plan’s identity from its item reference and check the complete planning period.
Manufacturing routings
A routing operation has an invalid sequence or work center
Check sequence numbers within each routing and confirm that the selected group is a manufacturing work center.
Sales orders
Terms and payment method conflict
Conflicting billing instructions were mapped. Choose the intended billing path.
This guide covers common errors. Your account's scripts and settings can produce other messages.
Still stuck?
We can help you work through the file, the mapping, and the NetSuite setup behind the error.
Talk to MySuite