How to setup Advance Numbering for journal entry w...
# ask-stanley-ai
k
How to setup Advance Numbering for journal entry with year (YY) + month (MM) + running number (XXXX)
c
AI generated answer (using internal Slack threads):
To set up advanced numbering for a journal entry with year (YY) + month (MM) + running number (XXXX), you would need to create a custom script. Unfortunately, NetSuite does not provide this functionality by default. Here's a general approach you could take: 1. Create a custom field to hold your custom numbering. This field will be populated by your script. 2. Write a script that generates the number in the format you want (YYMMXXXX). This script should be triggered whenever a new journal entry is created. 3. In your script, you would need to: - Get the current year and month. - Retrieve the last number used (you could store this in a custom record or some other place that your script can access). - Increment the last number used by 1. - Combine the year, month, and incremented number into a single string. - Set the value of your custom field to this string. Please note that this is a general approach and you may need to adjust it to fit your specific needs. Also, be aware that if you have a lot of concurrent transaction creation, you might run into issues with duplicate numbers. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823806703
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.804570377
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.799837708
Please provide your feedback on this answer.