This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

image.png

Hi All I have a process that creates bins in sequence but ID seems to have jumped. First time it has happened in like 4 months of this script being  run.
• 1st process ran at  25/7/2024 11:31 AM and created 2 bins =  WO56216-003, WO56216-004
• 2nd Process ran at  25/7/2024 11:51 AM created the next 2 bins WO56216-005, WO56216-006
• But when I sort by BIN ID it showing that the older bins have a newer ID casing my next binNo logic to go out of whack
• I might have to add a check Exist logic and try to keep getting the next number for now but has anyone seen  something like that happen before where the lasted ID is not the latest ?


ids arent safe to be used to order records

dont expect the ids to increase by 1 for every new record

dont expect them to always increase at all

the only thing you really rely on is them being unique