Using code at settings reference numbers

MJA Updated by MJA

You need to create a reference number for records in Newbase. You can do this within the Reference Number module. The code is set up in de widget serial info.

Below an example of a reference number of a sales quotation:

Below an example of how this reference number is set up within the module ref. numbers:

Before you start setting up reference numbers, we recommend that you think carefully about this. Click here for more information about reference numbers before you start.

Below the codes that can be used:

{YYYY}

Can be used to represent a year. This code is replaced by the four digits of a year

{YY}

Can be used to display the last two digits of a year

{MM}

Can be used the display the month

{DD}

Can be used to display the day

{9999}

Can be used to number the document. {9999} will become 0001 for the first document.

The document number must be at least 3 digits long

Example for a reference number for an invoice:

FA.2021.0001

Code used: FA.{YYYY}.{9999}

If you work with multiple companies in Newbase you should consider using a distinction between the companies in the code.

​Why use curly brackets?​

Use curly braces to avoid problems! The code used in Newbase is M for month, Y for year and 99999 for number. If you want to have an M, Y or 9 in the reference number without it ever being seen as anything else, you need to use curly brackets around the code.

Suppose we are in the year 2029 and the code contains YYYY without curly braces, so OFYYYY9999, then the 9 of 2029 will be seen as part of the referencel number. So then the first quotation of 2029 becomes OF20299999, while you had intended OF20290001. Use OF{YYYY}{9999} avoids this problem.

How did we do?

Before you start setting up reference numbers

What is the program translations?

Contact