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.
Filter Based on Summary Data
I have a saved summary transaction search that sums amounts on transactions per project. When the transactions balance out to zero (check for $50 and deposit for $50 = summary line of $0), I need to remove the summary line from the search results.
I thought the way to do this would be to add Summary Criteria under Criteria > Summary. I added criteria that said the Sum of Amount is greater than 0. My results has a column for Amount that is Sum (and also a column for Project that is Group). However, this returned an unexpected error. Support is working on it, but they said the unexpected error was that the criteria is conflicting. My only other criteria is the date range. Is this the wrong way to go about this?