When cases are created, auto numbering is not incrementing correctly?

[Daniel R2]

Hi,

We have noticed that when cases are being created. 

Auto numbering of cases is missed?

For e.g.

We have cases that go CS0001047, CS0001048, CS0001049, CS0001050.

then it will go directly from CS0001050 to CS0001058, and will miss out the 7 numbers in between? 

Can anybody please explain the reasoning for this. 

When we search up a record number that seems to be missing, there is no such record. Is this just an issue with the auto numbering? how can we resolve this?

[SatyakiBose · Accepted solution]

Hello @Daniel R2 

The reason being, the numbering does not actually depend on a record actually being created.

Say for example you opened a new case form, and the number is CS0001051.

But you did not save the case, for system it is assumed that CS0001051 is already taken.

The next user who opens up a new case form the number will start from CS0001052, and so on.

[SatyakiBose]

If you wish to avoid the numbering gap, please check this article:

https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/field-administration...

[SatyakiBose]

Procedure

1. Navigate to System Properties > System.
2. Set the property Assign a task number only upon insert (prevents unused numbers), glide.itil.assign.number.on.insert, to true.
3. Click Save.

Or you can  write  After BR to create Inc number only after creating a record.

If you wish to go with a BR, you can check this post:

https://www.servicenow.com/community/developer-forum/business-rule-insert/m-p/1583451