Autogeneration skipping numbers on Custom table

Subhajit1
Giga Guru

I have setup auto generation of Record Numbers using the getNextObjNumberPadded() function.

But i have observed that the system is skipping a number while creating a new one. Suppose the last one was PQR0016 then the next one is coming as PQR0018.

Also, when approvals are generated for PQR0014, then in the Approval form for the Approval For field, PQR0017 is being shown. When clicked on the PQR0017, the system is redirecting me to PQR0018. Why is that and how can this be resolved?

 

Thanks,

Subhajit

1 ACCEPTED SOLUTION

Subhajit1
Giga Guru

Found the Reason:-



Actually i had made a custom u_number column on my Custom table and had set getNextObjNumberPadded() on it. This table is extending the Task table, hence the above function was getting called Twice.


View solution in original post

6 REPLIES 6

Hi Subhajit,



Is there a way we can remove the dependency and avoid skipping numbers?



Thanks,


Venkatraman.


hookerdonte1
Giga Contributor

Thanks for this.