Formatting Document Running Numbers

Formatting Document Running Numbers

Formatting Document Running Numbers



Location

Action

Remark




Setup Activity>

Running No.

Click SETUP activity

Click COMPANY DETAILS

Click Running No. module

Select QUOTATION

Click EDIT

This is to open Quotation Running No. Registration to edit

mode.


TYPE                                                   This is the document type. In this example you are working on the Quotation running number, hence it should be set to quotation


NAME

Give a meaningful name to this running number series;

otherwise you can leave it as default.


To understand further see page 88 - 6.1.1.1 How do I setup

Multiple Running Number Series


FORMAT                                                  Format is the system Formula of the running number.

Formula is within square brackets [ and ]

Anything outside these square brackets is ignored.

                                                                                        formula:

[0000] = 4 digits running nos.

[000000] = 6 digits running nos.

[YY] = display year in 2 digits, e.g. 11

[YYYY] = display year in 4 digits e.g. 2011 [MM] = display month in 2 digits, e.g.08 [DD] = display date in 2 digits, e.g. 31 [UU] = display User ID in 2 digits, e.g. SJ Note Alpha formula must be in Caps

To see if you have set the formulae correctly, see EXAMPLE

field below.


NEXT NUMBER

You can enter your next running number for the system to run here.

 If you are starting a fresh series, set this to 1.

EXAMPLE

This will display the number that you set. 

You should not see any ‘[‘ or ‘]’ 

if you have set your formula correctly.



RESET

Auto-Reset No. to One

Note formula must have [YY]

to reset on yearly basis

must have[MM]

to reset on monthly basis Otherwise

youll generate duplicate numbers


Click UPDATE

Close the module

This is to save your changes.





    • Related Articles

    • Backdating running number.

      If you need to get back dated running numbers, you can do the following. E.g. Current date is Jan 2020. I need to enter documents in Dec 2019. This is my current running number set. Notice the "[YY]"? This is the year portion; currently in the ...
    • How do I setup Multiple Running Number Series?

      6.1 SETTINGS 6.1.1.1 How do I setup Multiple Running Number Series? This is useful if you need more than one set of running number series.Let’s say if you have 2 sales departments, each needed to have their own set of running numbers, you can create ...
    • Changing to different Printout Format

      Changing to different Printout Format ​ Location Action Remark SALES> QUOTATION  Click on LAYOUT Document Properties Dialogue box will appear  Un-Tick all the DEFAULT boxes Un-Tick the Default box release the pre-set layout format you have set in ...
    • Document Import XML format

      Version: 2.0.4 Date: 2023-04-12 XML format documentation 1. Invoice The follow sections describe the format of the Sales Invoice XML file. XML Mandatory Description <?xml version="1.0" encoding="UTF-8" standalone="yes"?> Y XML Declaration. <ociac10> ...
    • Adding a subtotal to a document.

      To create a subtotal in a document similar to the following  Step 1. Create a new item group. for Type set it to 'Remark' for Subtotal Level set it to 'Level 1 Reset' there are 9 grouping levels to use. 'Reset' means to reset the count. 'Accumulate' ...