Discussions
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.