Internal ID of Newly Create Item Is Not Always in Sequence

When user create items via UI, the Internal ID‘s of newly created items set by the system are not always in sequence. It shows that some numbers are skipped.

To determine the behavior on internal ID sequence of newly created item records user need to run some tests and observe.

Solution

1. Item A is the most recent created item – the internal id is 999
2. Created item B via UI – internal id set is 1000
3. Created item C and D via CSV- internal id set are 1001 and 1002 respectively
4. Created item E via UI – internal id set is 1102
5. Created item F via UI – internal id set is 1103
6. Created items G and H via CSV – internal id set are 1104 and 1105 respectively
7. Created item I via UI – internal id set is 1204
8. Created items J and K via CSV – internal id set are 1205 and 1206 respectively
9. Created items L and M via CSV – internal id set are 1305 and 1306 respectively
10. Created items N and O via CSV – internal id set are 1405 and 1406 respectively

Note: Based on sequence of item creation, Internal ID skip after every CSV import. Thus, for the items created either through CSV import or UI right after one CSV import, the Internal ID will jump.

In the Custom Record, Check the Enable checkbox under the Numbering tab.