Filtering balances in credit


I am using an NL filter to filter out any customer records where the balance of their invoices, before a filtered due date, is greater than 0.

"=NL(""Sum"",""Cust. Ledger Entry"",""Remaining Amount"",""Customer No."",NF(,""No.""),""Due Date"",""<="&NP("eval",'Current Due'!$D$1)&""")",">0"

But it still shows customers who have a credit balance.

If I change the >0 to =0 it only shows records that have a zero balance.

If I change the >0 to <0 it shows an error.

Any ideas would be appreciated.



Please sign in to leave a comment.