In NetSuite, some companies may need to add a Custom Field to the Location record that displays the date it was last edited. This article will guide you on how to achieve this using a Saved Search and a Custom Field.
Create the Saved Search:
Navigate to Reports > Saved Searches > All Saved Searches > New
On the Saved Search page, click on Location
On the Saved Location Search page, set the fields below:
- Search Title: <Set the name of your search here>
Results subtab:
- Field: System Notes: Date
- Summary Type: Maximum
Available Filters subtab:
- Filter: Internal ID
- Show in Filter Region: Yes
Create the Custom Field:
Navigate to Customization > Lists, Records, & Fields > Other Record Fields > New
On the Other Record Field page, set the fields below:
- Record Type: Location
- Label: <Set your label here>
- Type: Date/Time
- Store Value: Unchecked
Validation & Defaulting subtab:
- Search: <The search we created above>
Results:
Once done, it should reflect the latest date found in the System Notes. Please see my two examples below:
Now you know how to achieve this by using a Saved Search and a Custom Field.
I hope this helps! 😁
__
Want to learn more about Customization? Visit New to NetSuite: SuiteBuilder & SuiteBundler