I have a portal that shows all invoices activity for a specific customer. Within that portal I have a summary field that gives a running balance for their account. Is there any way to filter out all of the invoices that were before the most recent zero balance on their account? I feel like I should be able to filter by any invoiceID>Nthrecord (where Nth record is the invoiceID of their last zero balance).
I hope that makes sense. Thanks in advance.