How to setup Advance Numbering for journal entry with year (YY) + month (MM) + running number (XXXX) with journal type (custom list field)

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that setting up advanced numbering for journal entries with year (YY) + month (MM) + running number (XXXX) with journal type (custom list field) is not directly possible in NetSuite. However, you can achieve this by creating a custom script that generates these numbers and populates a custom field. Here are the steps you can follow: 1. Create a custom field for your journal entries where you will store the custom numbering. This field can be a free-form text field. 2. Write a SuiteScript that generates the numbering in the format you want (YYMMXXXX). This script should be triggered every time a journal entry is created or updated. The script should: - Get the current year and month from the system or the journal entry date. - Get the last number used for the current year and month. - Increment the last number by one to get the new number. - Combine the year, month, and new number to form the custom numbering. - Set the custom numbering to the custom field you created in step 1. 3. Deploy the script and associate it with the journal entry record type. Please note that this is a workaround and might not be the best solution for all use cases. It also requires knowledge of SuiteScript and might have performance implications if you have a large number of concurrent transactions. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******