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 #

• Adding Multiple Line Items with the Same Item on a Transaction Through CSV Import Throws Ambiguity Error

• This record already exists

• 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

• Total contribution for sales reps cannot exceed 100%

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:

1. 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.

2. Go to Setup > Import/Export > Import CSV Records.

3. In the Import Type field, select Transactions.

4. In the Record Type field, select the transaction type, for example, Sales Order.

5. Locate and open the CSV file, and then click Next.

6. Set the Data Handling field to Update, and then click Next.

7. On the Field Mapping page, map the following fields:

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.

1. Go to Lists > Search > Saved Searches > Net.

2. Click Transaction.

3. On Criteria > Standard subtab, add a filter of External ID = XXX (where XXX is the external ID that had the error).

4. 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.

General Notices