I have a custom record type. Just noticed that the...
# generalj
jen
03/05/2021, 10:16 PMI have a custom record type. Just noticed that the internalids are incrementing by 100, and not by 1…..
🤔 1
p
Philip Denys
03/05/2021, 10:34 PMSetup?
j
jen
03/05/2021, 10:44 PMnothing special
jen
03/05/2021, 10:44 PMmessage has been deleted
b
battk
03/05/2021, 10:55 PMpretty normal, especially when the records are being created outside of the ui
j
jen
03/05/2021, 10:57 PMwhy would it be “normal” to not increment by 1?
b
battk
03/05/2021, 11:03 PMits something netsuite does
j
jen
03/05/2021, 11:04 PMthat doesn’t make it normal
jen
03/05/2021, 11:04 PMusually the opposite 😉
b
battk
03/05/2021, 11:04 PMmy guess is that its reserves batches of ids
battk
03/05/2021, 11:05 PMbasics about internal ids is to only expect it to be a unique number
battk
03/05/2021, 11:05 PMdont expect to sort by it, dont expect to count via it
battk
03/05/2021, 11:08 PMbe glad that it appears to have stopped doing annoying things like releasing previously reserved ids and having new internal ids with lower numbers than older internal ids
battk
03/05/2021, 11:08 PMwas a very bad day for sorting when that happened
j
jen
03/05/2021, 11:14 PMI still get that with autonumbering
jen
03/05/2021, 11:14 PMsame autonumber will get reused
jen
03/05/2021, 11:14 PMit’s a fucking nightmare
b
battk
03/05/2021, 11:18 PMhow are you getting duplicates with auto numbering?
j
jen
03/05/2021, 11:25 PMdelete the record. Number gets reused.
jen
03/05/2021, 11:25 PMsomething to do with timing
jen
03/05/2021, 11:26 PMif another record isn’t created before you delete the last one the number gets used again
jen
03/05/2021, 11:26 PMI think
b
battk
03/05/2021, 11:26 PMthat sounds about right
j
jen
03/05/2021, 11:26 PMit’s awful
jen
03/05/2021, 11:26 PMwas VERY problematic with the original Box-for-NetSuite system
jen
03/05/2021, 11:26 PMwhich used record name to look up Box Folder
jen
03/05/2021, 11:27 PMwe ended up with files attached to the wrong records a fair bit
jen
03/05/2021, 11:27 PMwas ultra confusing every time
jen
03/05/2021, 11:27 PMalso if someone replied to an auto-email sent to them, referencing the number
jen
03/05/2021, 11:27 PMbut it had been merged into something (therefore deleted), and that number now referenced something else entirely
k
KevinJ of Kansas
03/06/2021, 12:20 AMIs it a sublist? Those increment ids by 100
✔️ 1
j
jen
03/08/2021, 9:49 PMoh really? Why?
k
KevinJ of Kansas
03/08/2021, 10:32 PMI don't know entirely. My guess is the same logic behind the incrementing of line IDs on regular sublist IDs
KevinJ of Kansas
03/09/2021, 3:14 AMWhat happens if you use the insert function to drop a line between two existing ones? does it still increment by 100? or does it put it in the gap between the two other records?
5 Views