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 |