Collection Aging Query required
Posted: Sun Oct 19, 2008 2:24 am
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.
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.