NetSuite lets you enable auto-generated numbering for many record types, including many types of transactions, so that records are numbered automatically in the order they are created. Auto-generated numbering is set up and recorded at Setup > Company > Auto-Generated Numbers.
- After auto-generated numbering is set up for a record type, NetSuite generates IDs for all records of that type. These IDs are stored in the name field of each record.
- If you need to import legacy IDs for a record type that has auto-generated numbering enabled, be sure to check the Allow Override box. Otherwise, your import job may return errors.
If auto-generated numbering is enabled for a record type, you may not be able to import values for ID field data, even if you map the field in the Import Assistant, depending on the record type’s Allow Override setting on the Set Up Auto-Generated Numbers page.
- If you have enabled auto-generated numbering for a record type and disabled Allow Override, any ID field values in the CSV file are ignored, and auto-generated numbers are saved with imported records.
- If you have enabled auto-generated numbering for a record type and enabled Allow Override, ID field values can be imported.
For example, if you import a customer with a Customer ID of jack1 listed in the CSV file:
- If Allow Override is disabled, the new customer record has a Customer ID of CUST0001.
- If Allow Override is enabled, the new customer record has a Customer ID of jack1.