https://netsuiteprofessionals.com logo
Join SlackCommunities
Powered by
Does anyone know if line unique keys of records th...
# general
b
Does anyone know if line unique keys of records that have been deleted can ever be reused? I’m currently working with a consultant that thinks they can be, but only for specific transaction types (e.g. currency revaluations). I have yet to find any evidence of this being true
k
This sounds like a remarkably bad idea
b
to be clear - i’m hoping the answer is “no, that’s impossible”
I just want to confirm that those line unique keys will ALWAYS be unique, no matter what
k
I wouldn't trust line unique key as a tool
If you are looking for a reference that you can use when exporting to another system - I'd probably use a combination of transaction internal ID and line unique key - however - it should be noted that line unique key can change for a line if certain things happen.
i.e. someone removing and adding a line back. someone inserting a line before last line.
b
oh yeah?
k
The only use I can think of for line unique key is for performing updates of existing lines in an export/reimport situation
b
someone removing and adding a line back.
In other words, someone deleting a line then adding a new line that’s effectively a dupe of the orifinal?
k
Right.
b
perfect
that’s EXACTLY what we need it for actually
The only use I can think of for line unique key is for performing updates of existing lines in an export/reimport situation
this is literally our use case
k
NS does not give very much insight into how that field is generated though.
b
our customers import data from netsuite into our product. the way we currently handle deletions is really inefficient so we’re looking into new methods
someone inserting a line before last line.
what does this mean?
yeah NS doesn’t give much insight into a lot of things haha
k
When editing a transaction like a sales order - I believe you can insert a line between 2 lines.
4 Views
Open in Slack
PreviousNext
Powered by