In NetSuite, some companies may need to add a Custom Field to their transactions to know when it was Approved or set to Pending. This article will guide you on how to achieve this using a Saved Search and a Custom Field.
In this scenario, we'll be using a Custom Field as the Status field:
Saved Search:
Criteria subtab:
- Type: is Sales Order
- System Notes : Field: is <Your Custom Field>
- System Notes : New Value: starts with Pending Accounting Approval
Results subtab:
- Sort By: System Notes : Date
Columns - Field: System Notes Date
- Summary Type: Maximum
Available Filters subtab:
Custom Field:
- Type: Free-Form Field
- Store Value: Unchecked
Validation & Defaulting subtab:
- Search: <The Saved Search you created>
Results:
Once done, this is how it should look like:
If we go to the System Notes, we can see that it captured the latest date when it was set as Pending Accounting Approval.
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