Ticket numbers not getting generated in order

[sanvi]

Hi,

I have created a custom application, but the application numbers are not getting generated in order like the below mentioned screenshot.

Here as we can see that the numbering is kind of odd numbers this is not in serial order.

What may be the problem can anyone suggest.

[sanvi]

Hi ,

I have not extended from the task table it is a custom table which does not extend any table.

Here in the form there is a mismatch .

I have checked all the solutions but its not working.

[Chuck Tomasi]

As Sergiu mentioned, by default, a new number is generated each time you open a record. If you do not save it, that number is effectively wasted. While there is no harm in this, it can leave some to wonder "I see 5, 6, 7, and 9... what happened to record number 8?"

If you want to avoid this, navigate to System Properties> System and check this box:

(I know, it says TASK - disregard this, we haven't had a chance to update it. ) NOTE: This setting applies to numbering on ALL tables on the system, not just your table. It also does not populate the number field until after the record is saved.

Managing Record Numbering - ServiceNow Wiki

[sanvi]

Hi Tomasi,

As suggested by you in the above thread i checked for " Assign a task number only upon insert", this is already checked in my instance but still i am facing the issue.

[Chuck Tomasi]

While I cannot tell what table is being used for these CPS records... is it a filtered list? (your original screenshot does not appear to show that.)

Also, what release of ServiceNow are you working on? The screen shot seems to indicate Eureka. Can you confirm?

[Mihir Mohanta]

Go to CPS tracker table and see if default value of two fields contains "javascript:getNextObjNumberPadded();".Default value of one field should contain this function.

Thanks,

Mihir