[starcentral]

Trying to import sales orders via CSV and encountering one error after another in the CSV response.

The fields I have are customer internal ID, external ID, date, po/cheque, item ID, line ID, quantity and some other date fields as well.

Errors I get as I play with the mappings are “reference key” not found for the either the customer internal ID, or the item internal ID.

The latest error I have is “This record already exists”. If I’m using the CSV to create a new sales order, how possibly can the record already exists?

thanks for any help
This is a cached copy. Click here to see the original post.

[rnedelkow]

The error “This record already exists” will appear if the External ID was already used in a previous transaction. Use a unique External ID so that the transaction will be imported without this error. To check if an external ID is already used in the system, create a saved search:

1. Navigate to Lists > Search > Saved Searches > New.

2. Click on Transaction link.

3. On the Criteria tab > Standard subtab > add External ID = (the number of the external ID used on the csv file that has the error).

4. Click Preview.

[starcentral]

Thanks, I had no idea that the “external ID” used for reference had to be unique, that makes sense but the errors generated by netSuite could be far more clear.

[Author]

Posts