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
Is there a suggestion already to improve search criteria?
A number of times I have thought how useful it would be to be able to select the value of a field in the Value box for a search criterion. For example, I am trying to find orders where the sum of their deposits does not equal the order total.
It's a real pain to do it, requiring some messing around with formulae and, I think, use of some non-standard methods, like a summary function in the formula itself. I think it can be done and I'll keep trying, but this would be so easy if I could just do a summary criterion that sums the applied transaction total amounts and checks if the value is the transaction total. Instead, I have to give a specific number as the value, as though every transaction I might ever want to look at has