running "aged receivables in the past"

CobaltSS

Hi all,

I searched using the above phrase and received no results. One of my users is trying to run an aged receivables report for May 31. One of the filters she's using is "balance <> 0". As of May 31, there was this specific customer that had an outstanding invoice, but has since paid the invoice, so the balance is currently 0. She wants to see this customer on the report. Is there a way to run this "in the past"?

Any advice appreciated.

cheers,

Savatage

I don't think you can use a filter like that on the A/R Aging.

It's filtering the balance on the customer card "right now" not what it was on a specific date.

even adding
Date Filter ..05/31 doesn't seem to calc the Balance as of that date.

Maybe you can play with the PrintOnlyIfDetail property on a copy of the report :-k