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

Hello all, just wondering where to start on this, I'm assuming its fairly simple..

I need to source the date the status changed on a custom record, and display it in a custom field.. I'm a little stumped on where to start. I was assuming it would be similar to a basic formula in a saved search, but that is obviously not working..

if you have very restricted requirements, you can do this without suitescript

<https://system.na0.netsuite.com/app/help/helpcenter.nl?fid=section_3746191995.html>

primarily if you are ok with the value not being stored

otherwise the approach is to either update your date changed field duing a user event before submit

or do a search on the system notes to figure out when status field changed and set that value

I made a saved search to show the 'date fulfilled' so to speak and it looks good, but then I could not find my saved search in the custom field options when setting default values