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
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?