Invoice aging report Query/ tables involved

[syrara]

Hello All

Any one pls let me know wat is da procedure 2 check the query/(tables involved) behind the invoice aging report, i want to customize this report.

Regards

[cschaik]

Hi,

Basically the main tables involved will be RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL and AR_PAYMENT_SCHEDULED_ALL.

However the report itself is taking also receipts on account etc.....

Please see also my private message on how to get the detailed query ran by the report (Debug Flag of the request on and pick the query from the Log output written by the concurrent manager).

Cyriel