We just enabled a workflow to create a record (custom) and it was working fine in sandbox, but the numbering is off in production. I check the record page and all the settings are the same. In sandbox the IDs were order 1....2....3.  In Prod I have 1....101....201

I looked at the numbering tab in both production and sandbox and they are both disabled.

What I am saying is that you don't want to rely on internalid. It's only guaranteed to be unique, nothing more

The internal ID / ID doesn't necessarily mean anything to me, but a record is created every time a sales order comes through and if it's increasing by 100 each time I feel like the numbering is going to get out of control.

No, it's normal. Wouldn't worry

worry about it you expect to get 2^31-1 orders

I am also just interested in the reason for it. Why is sandbox increasing by 1 and prod by 100. I don't believe we have made any changes to prod recently and sandbox is a month or so old. I reached out to Netsuite but they are going to have to test internally and get back to me.

it increases by 100 since whatever is generating ids is just reserving 100 instead of trying to make 100 single unique ids

Oracle sequences can be configured to behave like that on RAC, so i imagine that's what's underneath

ok. I'll see what Netsuite says. The number itself isn't needed so hopefully it won't cause any issues I just noticed it was different from sandbox and couldn't figure out why.

doesnt really have to be a reason

ok thank you. I think it's fine to just leave as is. My OCD was getting the best of me.

I’ve encountered this exact same thing and NetSuite was basically like