Discussions
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. Join us
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