Development > Utilities > Miscellaneous > Sequence number values 

The sequence number counters are used to number those documents containing an incremental numeric segment, the current value of this segment can be unique or depend on the site, company, month, period, an additional code or a combination of these parameters, according to the case.

When a sequence number counter is newly created, or when it has never issued a number (for a combination of parameters defined by the context), the first number allocated is by default 1. But by using this function it is possible to define an initial value using another number to start the numbering sequence.

This function is particularly useful in the case of data recovery, so that the system restarts the number sequence with the number after the last one used.  

Warning, the modification of this sequence must be locked during normal exploitation by users, and is used only in the initial phase of recovery.

Screen management

A single dialogue screen appears on launching this function.

Entry screen


The entry is carried out in a window. Firstly the sequence number counter code is entered. As a function of the sequence number counter, it can be necessary to enter one or more additional parameters (company, site, year, month, financial year, additional code). Those parameters that are not relevant to the sequence number counter are greyed out.

Once this entry is made, the next value that will be used to number the elements linked to the sequence number counter in the given context is displayed in the field Next value. If no value has been allocated, this field contains 1.

It is possible to modify this value. An increase in the value proposed does not in principle cause any problems. A decrease in the value should not be made except in a well defined technical context, because elements may already have been numbered with the numbers that the system is looking to re-allocate. This will result in errors, because it will not be possible to create the elements in question .




The following fields are present on this tab :

Block number 1

This code identifies a counter, which can be used for the automatic numbering of these documents. A counter is an alphanumeric field with 1 to 20 characters. It is composed of a concatenation of sub-fields that can be of different types, and which are concatenated from left to right to form the counter value.

Block number 2

Wen a sequence number counter is defined by company, there is a sequence number counter per company code. The company code is therefore part of the key that determines the record of the table where the current chrono number is stored.

Wen a sequence number counter is defined by site, there is a sequence number counter per site code. The site code is therefore part of the key that determines the record of the table where the current chrono number is stored.

  • Year (field YEA)

This field contains the year, in up to 4 digits.

  • Month (field MON)

This is the Month, represented in a maximum of 2 digits.

  • Fiscal year (field EXE)


Accounting financial year number.

  • Add. info. (field CMP)

This is a Component of the sequence number.

Block number 3

  • Next value (field VAL1)

This field initially displays the next value that the system will assign to the related transaction or document. It may be changed to a new value of the Sequence Number as is appropriate to the situation.

Generally, incrementing the number should create no problems beyond the obvious "gap in the series" that will result. But decrementing the number should be avoided except in very well-defined technical contexts, since collisions will result between the new sequence numbers and ones that already exist in the database (e.g., two sales orders with potentially the same number).



Error messages

The only messages displayed are generic messages linked to the existence controls in the tables. It should be noted that no control is possible on the additional code value.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation