As of date status of Invoice(s)

Hi All,

We are running a customized report to fetch the latest invoice payment status with other required info. Now need to modify the report on 'As Of Date'. I.e. if user enter 31-DEC-2015, then report should fetch the status of invoice as on 31-DEC-15 (not the latest status if the invoice is paid after 31-DEC-2015 & before the 'As Of Date' entered in report parameter (e.g. 18-NOV-2016).

Please share the respective tables form which we fetch the data. As currently the report is fetching data form table(s) where the latest status of invoices are placed.

Regards,

Abdul Rehman.