7.17 Maintain Document Number Reset by Monthly or Yearly

New Feature applied to SQL Acc version 4.1.2011.668 and above.

Maintain Document Number able to have separate set of running number by Monthly or by Yearly.

Steps:

1. Tools | Maintain Document Number...

2. Create new document type, eg. Customer Invoice.

3. You must input the Format contains with the date format like this "{@mmyyyy}".

4. You can tell the system to reset the running number in Frequency, either Reset Monthly or Reset Yearly. See the screenshot below.

TIPS: You can leave the Year, Month & Next Number table "BLANK". System will auto generate the table like this as shown below screenshot.

A. Reset Monthly

Assume the Format remains like this "IV-{@mmyyyy}/%.5d" and Frequency set as Reset Monthly.

Results,

Conclusion:

You will found that EACH MONTH the running number will be reset to 00001.

B. Reset Yearly

Assume the Format remains like this "IV-{@mmyyyy}/%.5d" and Frequency set as Reset Yearly.

Results,

Conclusion:

You will found that EACH YEAR the running number will be reset to 00001.

Google Sites

Report abuse