Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Suppressing Zeros in a transaction search
Hi All
Can anybody help, with how to suppress the results of a search to ignore any result with a zero value?
We have a search which we run on a daily basis to ensure that the balance on an account summed by a custom field (T No) is equal to zero. Where it is not zero, we need to investigate. Over time the number of zeros has now reached 5,000 lines, so users have to look through a lot of zero entries to to find the problem entries.
The best I can do so far is highlight all the zero balances in one colour and all the non-zero balances in another colour. All I want is that the rows which are currently coloured green to not be displayed.