Auto increment fields

RLJB

We still use the old method to auto increment a number by having a rule in the BO like:

If Invoice IS NEW Then
Invoice.InvoiceNumber=MAX Invoice.InvoiceNumber +1

Please note this can (in rare circumstances) be a problem if 2 users create a record at exactly the same time. It does happen - it happened to us.

Support has confirmed that the new auto-incremented fields were created specifically to avoid this problem - so you should use them instead.

FYI - we have found taking a field from the old method to the new method does not affect the existing data and the incrementing continues from the existing number, so it is very easy to implement.

RLJB

As a revision to my post above, when I said "and the incrementing continues from the existing number" actually I don't think it actually does, my testing got confused - since I different InvoiceNumber values in my data - it was a bit of a mess.

aware_support

The starting value of auto-incremented fields can be set using the "from" range parameter of the number attribute

RocketRod

Can we use a value from systemsettings? if not would be a good addition.

Cheers Rod

Sergej

aware_support wrote
The starting value of auto-incremented fields can be set using the "from" range parameter of the number attribute

Can we change the value of number that is added when auto-incremented from 1 to smt else?

Now we have value range from 10001 and it is auto-incremented as 10002,10003 and so on.
But we prefer to autoincrement a bit randomly an Order Number.
For example by adding not 1 but lets say 21 value, so
10001, 10022, 10043, 10064

I suppose it is possible to change auto-incremented value by editing some file?