I have a customer search that is finding all customer's with a balance greater than 0. This is a grouped search and I need to have the search return all grouped by customers EXCEPT customers that have more than 3 invoices that are net15. Is this possible without 2 searches?
This is the psuedo code if statement. So we want to return everything except these.
if customer terms are prepay and have 3 or less open invoices with invoice terms of prepay or net15