Hi ! I can't figure out how I can set the invoice numbering to be as : "invoice-ddMM-CUSTCODEXX-invoicenumber", where : dd : day number MM : month number CUSTCODe : a customer code (Reference) XX : the invoice number for that customer invoicenumber : the invoice number
In accounting setup I already try to configure the pattern "INVOICE-(%day)(%month)", but didn't work...
Do I have to create a sales journal for each customer ?
Any idea ?
Thanks in advance
You can change the formatting of any sequence.
This includes Purchase Orders, Sales Orders, Delivery Orders, Manufacturing Orders, Invoices, etc.
Do this via the menu sequence
Settings -> Technical -> Sequences and Identifiers -> Sequences
For Invoices via the Sales Journal, you will see the following when you open the relevant record:
You can see that the only things you can incorporate into a sequence this way are:
- Fixed or date/time based prefix characters
- Fixed or date/time based suffix characters
- The total number of numerals in the number (padding) ie: 001 or 000001
- The increment used for the next number in the sequence
- The next number used for the numeric part of the sequence
- Whether to allow gaps in the sequence
You can see at the bottom the format for various components of the data and time.
Including a customer reference number can't be done this way - you need customization.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/17/13, 12:23 PM|
|Seen: 15957 times|
|Last updated: 9/9/16, 5:11 AM|