Incident numbering

[Michael Bachme1]

We noticed recently that our Incident numbers have grown beyond the halfway point of six-figures. What happens when our Incident number reaches 999999? Do we roll into 1000000?

[Michael Bachme1]

Chuck,

Yes, your fingerprints are on the number maintenance records   for April of 2010.

Good to know that it will just start using 7 digits. When it gets there, what will the INC number be? INC0000001, INC0000001, INC1000000, or something else?

[Chuck Tomasi · Accepted solution]

When you get to the end of your six digit numbering, the incident that follows INC999999 is INC1000000. The number will continue, it will just be a little longer.

[randrews]

it depends on the table numbering setup... look at the "number Maintenence" application in your nav menu and it will tell you how many digits your table is set to.. if you come close to that you will need to increase it.. which, if i am not mistaken, causes the table to be renumbered and reindexed <Read as a VERY long release night>

[Neeta3]

Hi,

We've finally hit the 1,000,000 mark in the INC ticket numbers! Unfortunately, when you are ordering your view by ticket number ascending/descending, it goes in ASCII order.

But this is going to make it increasingly difficult for users of ServiceNow at the time of sorting the numbers in descending of ascending order. If you order the view descending, it shows up numbers starting from 999999, 999998, 999997.....

Is this possible to view numbers as 1000010, 1000009, 1000008.....like this?

Thanks,

Neeta Patil

[Chuck Tomasi]

Short answer - no - it's a string field and the string fields are going to sort that way. All computers do that.

Go to System Definition> Number Maintenance, locate the INC record and change the number of digits from 7 to 8 or 9 and you'll get padded 0s and be able to sort. 

Docs: Record number field types