Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Invoice Saved Search - # of $ Edits
Hi,
Im trying to create a saved search that looks at the number of times the total/amt of an invoice has been edited/changed and WHO made the change. Date is anything after 11/1/25. The customer should be included along with the old and new total/amts if possible (but only the new amounts can be included if easier).
Im looking at the system information tab but need help creating a case/when formula. My thought is CASE WHEN sys.notes type = Change AND sys.notes = Total, THEN return sys.notes Set by (user who changed the total).
Below is a snapshot of the system notes i reference. My logic might be incorrect so i appreciate any help.
0