Overdue column on the
Unpaid Invoices report is not always calculated correctly.
If the Statement date (the one you enter in the
Until field and which is printed on the statement itself) is chosen as today’s date, the calculation is correct. If the Statement date is chosen as any other day (e.g., tomorrow or next week or the first of last month), the
Overdue column still reflects the number of days overdue through today, rather than through the date that appears on the statement.
In other words, it should be:
Statement Date -
Instead, it currently is:
Today's Date -
Sometimes there is a need to run a set of statements in advance, such as when doing an advance print-and-envelope-stuff run. At any rate, since the only date shown on the Statement is the Statement date, the
Overdue column should be based on Statement date. This also matters if I ever need to regenerate a previous Statement, as invoices that weren’t even past due yet appear to have been.
(The ageing of the receivables in the table on the top of the statement, on the other hand, correctly reflects the Statement date.)