Numbering Scheme - 000.000.000 up to 999.999.999

[js10000]

Hi,

How is it possible to define a numbering scheme that allows us to use sequential numbering up to 999.999.999 while using "." every 3 digits for better readability?

We also want to add .XX for Work in Progress and .01 - .99 for revisions

So for example 123.456.789.XX

We cannot get this to work because the auto-generated sequence does not seem to have an option to "interrupt" the numbering every 3 digits.

Thank you very much!

Best regards

[johan.degreef]

No experience, but can't you create 4 seperate fields?

000.111.222.333.44

[js10000]

Yes, but only one field can increment by itself. The other fields would have to be entered manually.

[Gabriel_Watson]

For more intricate solutions you will probably need to set a custom numbering scheme in SQL at the ADMS (see post below and research further into how numbers could be broken down with periods or how multiple fields could act as a single number):
https://resources.imaginit.com/manufacturing-solutions-blog/using-a-common-numbering-scheme-for-file...