creating auto numbering on custom fields

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Creating auto numbering on custom fields in NetSuite can be achieved through a combination of custom records and workflows or scripts. Here's a general approach: 1. Create a custom record with a single integer field. This will serve as the storage of the reference number with a starting value of 1. 2. Create a workflow or script that triggers on the creation or update of the record you want to auto-number. In the beforeSubmit event, get the value from the custom record and set it to the custom field within the transaction record. 3. After the record is submitted, update the integer field in the custom record by incrementing the value by 1. Please note that once you enable auto-numbering, numbers cannot be removed from records. Disabling auto-numbering in the future only prevents future records from being numbered. If you want to start numbering from 1 for future records, you may need to create a new custom record type with auto-numbering enabled and an initial number set to 1.