Collection Aging Query required

[Willynelly1]

Dear AR Gurus,

We are not using Advanced Collection Module, I need a query where I can query collection aging on the basis of Receipt date. For example, If I receive Kd. 1000/= from Customer No. 2030, amount applied against invoices of 0-30, 31-60, 61-90 and 91 above, like 4 bucket or 7 bucket aging in AR.

Or any standard report avilable in Receivable Manager responsibility?. Please advise.

Thanking you,

William.