Summary amounts in Customer Report and Receivable Aging Report use wrong dates

[DonM]

-------- Original Message --------
Subject: Re: Summary amounts in Customer Report and Receivable Aging Report  use wrong dates
From: Derek Atkins <derek at ihtfp.com>
To: DonM <dm413-gc at intielectronics.com>
CC: gnucash-user at gnucash.org
Date: 1/2/2011 8:41 AM

> Hi,
>
> On Sun, January 2, 2011 8:27 am, DonM wrote:
>> The summary numbers in the Customer Report and the Receivable Aging Report
>> seem wrong to me.
>>
>> These reports list amounts in categories 0-30 days, 31-60 days, etc. But
>> the numbers are calculated relative to the invoice date. Normally in such
>> reports, the numbers are calculated relative to the *due* date, not the
>> invoice date.
>>
>> I would expect to have a summary box labeled "current", which contains the
>> amount invoiced but that is not due yet (before the due date). Then the
>> box labeled "0-30 days" would be amounts that are between 0 and 30 days
>> past the due date. This is what Quickbooks does, for example, and also
>> other accounting systems I have used. This is also what customers expect
>> when they receive an overdue notice.
>>
>> This becomes more significant if you don't invoice net-30. If you invoice
>> net-15, for example, then some of the amount in the 0-30 days box is
>> current, and some is overdue.
>>
>> Searching the bugzilla list, it looks like this was reported 3 years ago
>> in #502066, 2007-12-06. There is one comment from a developer, but no
>> follow-up from the original reporter. Should I add a comment? Post a new
>> bug? Or do people believe it is correct as is?
>
> Please follow up to the existing bug report.  Preferably add the requested
> information:  An example data file that shows the bug, and the report
> output showing what happens.  (Also feel free to explain what the report
> should show based on the data, and the exact report option settings in
> order to reproduce the bug).

Thanks Derek,

I have posted a comment and two attachments (sample data file and exported report html file) to bug 502066.

Don