Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 18, 2026, at 8:00 PM Pacific Time, our Case Management System will undergo a scheduled maintenance for approximately 15 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Document number & Workflow
Hello everybody,
I am trying to create a specific number each invoice document following the logic :
posting period + .Subsidiary prefix + "the current month invoice number with 4 numbers".
E.g.:
The very first invoice of february for a Canadian subsidiary would be 2018FEBCA0001
The 32th invoice of june for an Italian subsidiary would be 2018JUNIT0032
At the beginning of each new month, the four last numbers would have to go back to 0001. This is actually the part where I am stuck in right now and I am not really sure this is actually doable:h_a_w:
Regarding the begining of the formula I would start like this :
Tagged:
0