Number Sequences

Number sequences are used to generate readable, unique identifiers for master data records and transaction records that require identifiers. These can be used for applications like serial numbering products.

Before you can create new records that require these identifiers, you must set up a number sequence and assign it to the process.

Adding a new Number Sequence

• Navigate to ‘Number Sequences’
• Using the ‘New Number Sequence’ fill the form with the details of your new number sequence.
• For the ‘Format’ refer to the reference below.
• Set the starting number for the sequence.

Changing the next number of a sequence

• Using the ‘Restart Sequence’ action on the list of sequences you can select the next number of the sequence.

Format

The format options allow you to define how the identifier generated will look.

Make sure the you specify enough number characters for your sequence otherwise you will get errors.

You can use the # character to replace a number or the 0 character to replace a number but pad it with a zero if the number is too short.

When using sequences for identifiers that will be rendered as a barcode it is advisable to use a fixed length pattern.

Format	Output	Notes
2025-000000000	2025-000047438	This applied a prefix
000000000/ABC	000047438/ABC	This applies a suffix
#########/ABC	47438/ABC	This applies a suffix without zero padding
000000000	000047438	This will pad with zeros
#########	47438	This will not pad the output with zeros
###-###-###	680-747-438	You can create separators for the number elements.
000-000-000	000-747-438	As above but with zero padding for smaller numbers
#std	47438std	A single # will output the whole number
\#1-#########	#1-47438	Use \ for the next character to be interpreted as a literal rather than as a custom format specifier

Scriban

The format also support Scriban syntax, allowing you to dynamically generate formatted values using dates and incrementing numbers.

A parameter called number is passed into the model.
This represents the next value in the sequence.

A parameter called local_now is also passed into the model.
This represents the local date and time. The standard date.now  will return the UTC date and time.

You can combine this with date functions and formatting.

Example

{{ date.now.year }}-{{ number | math.format "D6" }}

Output

2026-000536

Explanation

• date.now.year → Current year
• number → Sequence number
• "D6" → Pads the number to 6 digits with leading zeros

Custom Date Formats

You can format dates using the date.to_string function:

{{ local_now | date.to_string "%Y-%m-%d" }}

Example Output

2026-04-22

Date Format Specifiers

Use the following format parameters inside date.to_string:

Format	Example	Description
%a	Thu	Short weekday name
%A	Thursday	Full weekday name
%b	Sep	Short month name
%B	September	Full month name
%d	12	Day of month (01–31)
%H	22	Hour (24-hour format, 00–23)
%I	10	Hour (12-hour format, 01–12)
%m	09	Month (01–12)
%p	PM	AM/PM
%Y	2013	Year (4 digits)
%y	13	Year (2 digits)
%U	50	Week number (Sunday as first day)
%W	49	Week number (Monday as first day)

Combining Date and Sequence

You can mix date formatting with number sequences:

text{{ date.now | date.to_string "%Y%m%d" }}-{{ number | math.format "D4" }}

Example Output

text20260422-0123