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
System notes searches - any help???
Hello everyone,
I would like to be able to do a saved search that would look to the system notes for a particular custom record on our customer records, and return a listing of customers where the "old value" for the field is equal to one thing and the "new value" for the field is equal to something else.
For example, on our customer record, we have a check box field called "Is this a demo," which allows us to tag certain customer records as demo customers in the case we set them up with a demo/trial account of our software product. Upon purchasing our software, we then uncheck this field. I would want to be able to do a search into the system notes for this field to return the results of all customers who went from "is this a demo" = True to "is this a demo" = False, and to pull in transaction information.