General Transaction Import Errors
This section describes errors that you might see on any transaction import. See the following:
You must map one of the following NetSuite fields to a column in your CSV file, to be a unique identifier: External ID, Internal ID, or a transaction number field, such as Order # or Invoice #
The error occurs when you click Next on the Field Mapping page.
To import new transactions, you must map at least one of these fields on the Field Mapping page to uniquely identify each transaction:
-
External ID (for more information, see External IDs Overview).
-
Internal ID (for more information, see Setting the Internal ID Preference.)
-
Order #, Invoice #, or another transaction number field
For more information, see also Select Reference Types.
Adding Multiple Line Items with the Same Item on a Transaction Through CSV Import Throws Ambiguity Error
The error occurs when you're adding line items to an existing transaction (for example, sales order). The line item information in the CSV import uses the same item record, as shown in the following example.
The sales order has the following items:
-
Item X -- Quantity 1
-
Item Y -- Quantity 2
You want to update the sales order to:
-
Item X -- Quantity 10
-
Item X -- Quantity 11
-
Item X -- Quantity 12
To perform the import:
-
Create a CSV file with the Line ID column and leave the column value as blank.
Sample CSV file format
Sales Order's Internal ID, Item Name, Quantity, Price, Tax Code, Line ID
Note:For new items, give them a new Line ID. The system will know these are new lines in the same transaction. For example, if the last Line ID is 10, use a number higher than 10 for your new items to avoid ambiguity errors.
-
Go to Setup > Import/Export > Import CSV Records.
-
In the Import Type field, select Transactions.
-
In the Record Type field, select the transaction type, for example, Sales Order.
-
Locate and open the CSV file, and then click Next.
-
Set the Data Handling field to Update, and then click Next.
-
On the Field Mapping page, map the following fields:
Your Fields |
NetSuite Fields |
---|---|
SO Internal ID |
Internal ID |
Item Name |
Items: Item |
Quantity |
Items: Quantity |
Price |
Items: Rate |
Tax Code |
Items: Tax Code |
Line ID |
Items: Line ID |
This record already exists
The error appears if the external ID was already used in a previous transaction. To successfully import the transaction, use a unique external ID.
Use a saved search to see if an external ID is already used in the system.
-
Go to Lists > Search > Saved Searches > Net.
-
Click Transaction.
-
On Criteria > Standard subtab, add a filter of External ID = XXX (where XXX is the external ID that had the error).
-
Click Preview.
Date field not in your preferred date format for field "Date" – You have entered an Invalid Field Value x/x/xxxx for the following field: trandate
In the CSV file, highlight the Date column and make sure the format is the same as the Date field in the Time Tracking Form in Transactions > Employees > Track Time.
Total contribution for sales reps cannot exceed 100%
The error occurs when the sales team assigned to the record you're updating or creating has a contribution percentage over 100.
When you're creating a transaction record, this usually happens because you didn’t check the Overwrite Sublists box in Advanced Options.
If Overwrite Sublists isn't checked, NetSuite tries to use the sales team currently assigned to the entity and any sales representatives in your CSV file.