How to Import Transactions with Auto-Generated Numbers in NetSuite

When importing transactions into NetSuite where auto-generated numbers are enabled, two primary methods can be employed to provide the necessary unique identifier for the import process:

1. Utilize a Dummy Unique Identifier Column:

   n

   • Create a temporary column in the import file, such as "Order #", containing unique identifiers for each transaction.n
   • These unique identifiers are crucial for grouping all line items belonging to a single transaction during the import. If identical numbers are used in this dummy column, all associated line items will be imported under the same transaction.n
   • The values in this dummy column may be imported if the 'Allow Override' setting for auto-generated numbers is enabled for the record type. Otherwise, NetSuite will generate its own numbers.

2. Leverage the External ID Column:

   n

   • Alternatively, use the "External ID" column in the import file.n
   • Map this column to the 'External ID' field in NetSuite.n
   • Ensure the "External ID" column contains unique identifiers that correspond to existing External IDs in NetSuite, if applicable, or new unique identifiers for new transactions.n
   • Values in the "External ID" column will be imported and can be used for future lookups and integrations.