Wednesday, October 10, 2018

CSV Response 'Transaction type specified is incorrect'

Use Add as the Data Handling.  The error occurs when there is an existing External ID being used in the account. If Add or Update data handling is used, NetSuite will try to update that record instead.  The External ID should be unique across different transaction types.

 

To change the data handling:

 

1.      Setup > Import/Export > Import CSV Records (or if you are using Saved CSV Import, navigate to Setup > Import/Export > Saved CSV Imports > select the Saved Import). 

2.      Select the Import Type and Record Type then select the CSV File and click Next.

3.      In the Import Options page, select Add for the Data Handling.

4.      Proceed with the import.

1 comment: