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.
Override Invoice Number -- Autonumbering
We are trying to work through a solution for auto-numbering and are running into an issue towards the end of the process.
We want our Invoice Number schema to be such.
Subsidiary prefix-INV-YYYY-AUTONUMBER
The catch is the auto-number needs to be unique by subsidiary.
e.g. If there are three subsidiaries with the prefixes of SUB1, SUB2, & SUB3.
The first invoice would be:
SUB1-INV-2013-00001
then:
SUB2-INV-2013-00001
then:
SUB1-INV-2013-00002
then:
SUB3-INV-2013-00001
etc...
Has anyone done something similar to this? I cant think of a good way to manage the auto-number by subsidiary.
Tagged:
0