Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
NSC | How to track if there are any changes made by a User in an Invoice?
Users can track UI changes made by a user in an Invoice by creating a Saved Search.
Here are the steps users can take:
1. Navigate to Reports > Saved Searches > All Saved Searches > New
2. Search Type: Select Transactions
3. Title: Enter Name
4. Click Criteria > Standard
5. Mark the Use Expressions checkbox
6. Add the following filters:
Parens | Filter | Parens | And/Or
Type = Invoice | And
Main Line = True | And
( | System Notes Fields… = Context = UI | And
System Notes Fields… = Type = Change | )
7. Under the Results, add the following fields:
Field | Summary Type | Formula
Document Number | Group
System Notes Fields… = Set by | Group
Formula (Numeric) | Sum | CASE WHEN {systemnotes.newvalue} <> {systemnotes.oldvalue} AND {systemnotes.context} = 'UI' AND {systemnotes.type} = 'Change' THEN 1 ELSE 0 END
