Numbering format - How to maintain multiple running number?

Top  Previous  Next

 

(Source: AutoCount Forum, 02 Feb.2009)

 

How to set the following 3 sets of running number format of Invoice:

Set 1: starts with constant 'B', followed by 2-digit of 'year', ending with 4-digit running number. e.g. B09-0001

Set 2: starts with constant 'C', followed by 2-digit of 'year', ending with 4-digit running number. e.g. C09-0001

Set 3: a free format so that I can key in anything I like (alpha-numeric).

 

 

The Steps:

There has already a default running number, we can change its format (for Set 1), and create a new format for Set 2.  
1. Go to General Maintenance > Document Numbering Format Maintenance

2. Look into Category: Sales > DocType: Invoice ... click to highlight IV Default, click on Edit

 

 

      HowTo-Multiple Bunbering01

 

 
      HowTo-Multiple Bunbering02

 

 

3. Key in format: B{@yy}-<0000> , set Next Number to '1', click on OK
   'B' and '-' are static text, {@yy} is the last 2 digit of year, <0000> is 4-digit running number

 
4. To create the 2nd set of invoice running number, click on New. key in a name for this format, and the format is: C{@yy}-<0000>, click on OK.

 

 

      HowTo-Multiple Bunbering03
 

You need to log out and login again for new formats to take effect.

 

 

5. As for Set 3, it requests no running number, thus no setting is needed. User can enter any invoice number (alpha-numeric) when issuing invoice, just click on <<New>> and key in document number directly in Invoice No. field.

 

    HowTo-Multiple Bunbering04

 

 

Now issue a new invoice, you can choose running number format (the chosen format and next possible number will be displayed on the top of the invoice windows. Should you key in the invoice number directly onto Invoice No. field, all running formats will be ignored.

 

 

 

 

 

_____________________________________________________________

Send feedback about this topic to AutoCount. peter@autocountSoft.com

© 2013 Auto Count Sdn Bhd - Peter Tan. All rights reserved.