Skip to Content
0
Former Member
Apr 20, 2009 at 08:24 AM

Can using query create aging report for GL Account

525 Views

Hi all expert,

I have a challenge scenario which customer request print out aging report for the following GL Account.

This is not a business partner account. However, customer want display like aging report.

30 days aging report for the following GL accounts by projects:-

i) WIP (Work In Progress) account

ii) Accrued Revenue account

iii) Accrued Cost account

Examples:

Current Balance 30 day 60 day 90 day 120 day

Account WIP 10000 2000 3000 5000 0

Any idea or example given? If yes, can you provide a query here?

Regards,

Eric Tan