Avoid Duplicate Transaction Numbers in a Transaction CSV Import

The user is running an import and would like to make use of the transaction number that is entered in the CSV file.

Further modifications are needed to be done in the CSV file to avoid having duplicate transactions.

In the Netsuite account, Setup > Company > Auto-Generated Numbers > Allow Override is set to True.

The user only has transaction number, name, date and items in the CSV mapping.

To make sure that the transaction numbers are not duplicated when importing through csv, the user should map the transaction number of the CSV file to both External ID and Transaction Number fields in Netsuite. NetSuite does not accept duplicate External IDs in the CSV import process to add new transactions.