Invoice Aging Report - As of Date
My company has a requirement, to cusotmise the Invoice aging report to be run at any given date-time. We are on 11.5.10 version.
I am struggling with the SQL query. I am trying to customise the standard one to accomodate it by adding the following 2 tables;ap_invoice_payments & ap_checks
Does any one have such existing report? If so can you please share. Also am I going in the right direction or missing some tables
Appreciate if someone can please help urgently
Thanks & Regards