Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
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