How to Create New Number Series

Modified on Fri, Jun 1, 2018 at 5:41 PM

Number series is used to have a multiple kinds of document numbering depending on its use.  In Optimum, we call it “Running Number”. It will allow the user to use the latest document number upon creating a transaction. 

 

In the Optimum main window, go to Maintenance using the menu bar.

 

 

Once done, look for the Running Numbers in the ribbon selection and click to open.


 

When the Running Numbers window appears, all of the system’s transaction forms by modules will list down together its number series format. 

  


To create a new number series, click the New icon in the Records Creation. 

A window will appear that allows the user to create a new number series. 


 

In the Table field, select a transactional form you want to have a new number series format using a drop-down list.


 

Once selected, provide a name that described to the new running number series. 



In the format field, it allows you to modify the number series look and display on the transaction form. You may use a date stamp on the document by using the available format below. 

 

Note: Details should be enclosed in curly braces due to its variable properties (changing).   

 

Date:

 

{d} = Day (1, 2, 3, ... 31)

{dd} = Day (01, 02, 03, ... 31)

{m} = Month (1, 2, 3... 12)

{mm} = Month (01, 02, 03, ... 12)

{yy} = Year (99, 00, 01, ... 98)

{yyyy} = Year (1999, 2000, 2001, ... 2098)

 

 

For the number series, we will be using {nb} formula where “n” states that it is a next number and the “b” is the fixed length of the number series.

 

Sample:

 

{n2} = 01, 02 ... 99

{n3} = 001, 002 ... 999

{n4} = 0001, 0002 ... 9999


 

In the Date Type, select which date will the number series get. By default, it will be the transaction date. 

  

The Start Sequence is where the number series starts when it is being first used in the transaction.  The Sample shows how it will looks like in the transaction as a document number series format.


For  Space Holder, the default value is always '0'



Once done, click the “Save and Close” to save the new number series/running number format.

 


Now to check its effect, go to the transaction form where the new Running Number is linked. 



In the Invoice No. field, check the drop-down button and select the New Running Number format you created. 

 


Once done, continue creating your transaction by using your own Running Number! 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article