Ticket numbers not getting generated in order

sanvi
Tera Expert

Hi,

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

find_real_file.png

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.

11 REPLIES 11

sergiu_panaite
ServiceNow Employee
ServiceNow Employee

Hi Nivedita,



The problem is when clicking New (or Create New) button which generates a new number, but not submit the form. That number if it's not submitted gets lost, so you have then missing number in the saved records.



Regards,


akashsrm100
Kilo Guru

Hi nivedita


Every time you open your form this generated next value.


and if you don't submit and reopen again this will generate another value.


you may write business Rule to avoid this issue.



Thanks


AKash Sharma


avinash kumar
Tera Expert

Hi,



Please check the number maintenance in service now instance. You will come to know about the reason other than specified above (i.e. unsaved tickets).



There is nothing beside this which could be handy.



Regards,


Avinash


Mihir Mohanta
Kilo Sage

1.I think you have extended   this custom table from Task table.



In Task table there is a number field present which is increment by 1(javascript:getNextObjNumberPadded(); function is used in default value).



2.You have used a field Oportuniti ID which is also incrementing by one using javascript:getNextObjNumberPadded(); function.




So in your table now there are two fields which are using javascript:getNextObjNumberPadded(); function.



Thats why this number is always incrementing   by 2.




Thanks,


Mihir