Autogeneration skipping numbers on Custom table

[Subhajit1]

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

[Subhajit1]

EDIT:

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 PQR0018, 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

[Pradeep Sharma]

Hi Subhajit,

By default, numbers are generated every time a new record is created. When records are created but not saved, a gap in the numbering is created.

To generate numbers only when records are saved, navigate to System Properties > System and set the property Assign a task number only upon insert (prevents unused numbers) to true.

NOTE:This would be set as global

Thanks,

Pradeep Sharma

[Subhajit1]

Hi Pradeep,

I am aware of this system property and it is set to False on our instance and still the numbering is working fine for other Applications.

What i am trying to say is what is working properly for other applications is not working for the Custom Application.

Ex: I press on Create New Incident Module twice and I get INC00025 and INC00026 (Inserted or not, doesn't matter)

But when i create New Record from Custom app twice, i get PQR00025 and PQR00027. That's where the issue is.

Thanks,

Subhajit

[Subhajit1 · Accepted solution]

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.