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 clicking Next on the Field Mapping page.
To import new transactions, at least one of the following NetSuite fields must be mapped on the Field Mapping page to uniquely identify transactions:
-
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 are 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 that has the Line ID column. Set the column value as blank.
Sample CSV file format
Sales Order's Internal ID, Item Name, Quantity, Price, Tax Code, Line ID
Note:The Line ID of new items can be assigned a new value. The system will know these new items are added in the same transaction. For example, the last line ID in the transaction is 10. To avoid the ambiguity error, assign a Line ID of higher than 10.
-
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 ensure that the format is the same as the Date field in the Time Tracking Form found 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 are updating or creating has a contribution percentage of greater than 100.
When creating a transaction record, this error usually occurs because in the Advanced Option menu, you did not check the Overwrite Sublists box.
If Overwrite Sublists is not checked, then the system will try to use the sales team currently assigned to the entity and any sales representatives in your CSV file.