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

Is there a way to reference an inactive record? By which I mean, to set the value of a List/Record field to a record that is inactive.

I often need to do this and it's always a hassle to work around it.

no, you could reactivate and set it, and itll stay there when you deactivate it.... I am not sure why you would to select an inactive record

E.g. An asset is at a customer that is inactive. I need to represent that, even if the asset should have been assigned to the customer when it was active. (It was there before it was made inactive - but no one updated NS to record this.)

We have workflows that run when a record is made inactive. I don't want to pointlessly activate and inactivate it

customer doesn't sound like it should inactive if something should be there

That's just one example. My current issue is that I am importing a million historical asset event records into NS and many of them need to reference customers that are now inactive in NS

only real options are variations of activating and then inactivating the record

Thank you <@U5TF1GQ20>. I had suspected as much. My workarounds for this issue are always such a pain