Need a Query to find all those Invoice which was cancelled Invoices in Ap Aging report in back date
Hi Experts,
I need a Query to find all the Prepayment Invoices which are cancelled to be shown in back dated date in Ap Aging report.
Example:
Invoice created in Jan-2017
Cancelled in May-2017
When I run the aging for Feb-2017, this Invoice need to be shown in Feb 2017 which was acive
Please provide a Query