Update Auto-Generated Numbers

A user wants to update the auto-generated numbers for case records for the first time 

Solution 

1. Go to Setup > Company > Auto-Generated Numbers 
2. Enter desired prefix, suffix minimum digits and initial number. Tick on the box for ENABLE and UPDATE
3. Click Save 

Reference for Updating Existing Records 

• UPDATE FUNCTION – being used to only update records that were never auto-numbered before, i.e. records created while Auto-Generated Numbers setting is disabled. The Update function is not used to change the numbering of records with existing numbers in order to streamline with the desired numbering sequence. 
• ALLOW OVERRIDE – when enabled, the auto-generated numbers assigned to numbered records cannot automatically be re-numbered. Instead, a user must edit all existing records then set the new desired numbering sequence. This can be done one record at a time or through CSV import (Data Handling = Update). 

Note: Once a record is auto-numbered through NetSuite’s Auto-Generated Number setting, its assigned number can no longer be changed unless Allow Override setting is enabled and the existing number is manually changed. This remains true even if a new Initial Number is set for the record type and the Update function is initiated. 

 
Important: The ability to automatically update the existing number format of records in NetSuite has been submitted as Enhancement #71541. 

To Update Auto-Generated Numbers of Existing Custom Records, to re-assign auto-generated numbers/ID of Custom Records:

Disable the Number feature of the Custom Record 

1. Navigate to Customization > Lists, Records & Fields > Record Types 
2. Edit the Custom Record 
   Example: Test Record 
3. Click Numbering subtab 
4. Enable: Un-enter Checkmark 
5. Initial Number: Enter 1 
6. Click Save 
   Note: To Save & Edit, hover on the down arrow icon on the Save button 
    
   

Re-enable the Number Feature of the Custom Record 

1. Navigate to Customization > Lists, Records & Fields > Record Types 
2. Edit the Custom Record 
   Example: Test Record 
3. Click Numbering subtab 
4. Enable: Enter Checkmark 
5. Update: Enter Checkmark 
6. Click Save