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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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