On the Accounts Payable report the "Past Due" column always seems to be relative to TODAY. How do I change it to be relative to the REPORT DATE ?
Assume that a Supplier Bill is dated 2 July 2018, with a Due Date of 1 Aug 2018.
Assume that the user runs an Accounts Payable Report on the 7 August 2018, using "Last Month" (ie 31 July 2018) as the report date.
The "Past Due" column always shows 6 days. The "Past Due" column is relative to the date the report is run. How do you make it so that the Past Due column is relative to the Report Date?
The column should show -1 as Report Date (31 July) minus Due Date (1 Aug) is -1 day.
I need the number of days the invoice was Past Due as at the Report Date.