Issue on payable ageing report

[Geert Janssens]

On 24-07-13 18:57, Derek Atkins wrote:
> Hi,
>
> Philip Tiong <chenlikpharmacy at gmail.com> writes:
>
>> 10:07Philiphelp on payable aging report10:07Philipon GnuCash 2.5.310:08
>> Philipi entered a credit note using the new invoice feature10:09Philipeg
>> 10:10Philip11/06/2013 10/08/2013 5070112344 Bill JV1306084 MYR 397.50 MYR
>> 397.5010:10Philiplet's reset this10:10PhilipDate Due Date Reference Type
>> Description Credits Debits Amount10:10Philip11/06/2013 10/08/2013
>> 5070112344 Bill JV1306084 MYR 397.50 MYR 397.5010:10Philip12/06/2013
>> 11/08/2013 5070112429 Bill JV1306043 MYR 1,692.00 MYR
>> 1,692.0010:10Philip12/06/2013
>> 11/08/2013 5070112432 Bill JV1306044 MYR 107.50 MYR 107.5010:10Philip22/06/2013
>> 21/08/2013 000008 Bill JV1306084A -MYR 234.00 -MYR 234.0010:10Philip02/07/2013
>> BPV1307001 Payment, thank you MBB029927 -MYR 1,858.50 -MYR 1,858.5010:11
>> Philip02/07/2013 31/08/2013 5070113099 Bill JV1307028 MYR 7,253.76 MYR
>> 7,253.7610:11Philip02/07/2013 31/08/2013 5070113100 Bill JV1307027 MYR
>> 95.00 MYR 95.0010:11Philip15/07/2013 13/09/2013 5070113740 Bill JV1307076
>> MYR 52.60 MYR 52.6010:11Philip15/07/2013 13/09/2013 5070113743 Bill
>> JV1307075 MYR 278.00 MYR 278.0010:11PhilipTotal Due MYR
>> 9,642.3610:11PhilipCurrent
>> 0-30 days 31-60 days 61-90 days 91+ days10:12PhilipMYR 96.60 MYR 9,545.76
>> MYR 0.00 MYR 0.00 MYR 0.0010:12Philipwith setting of due date set to
>> 31/8/201310:13PhilipIt should show up on 0-30days as MYR 9545.76 -MYR234
>> (the credit note) 10:14Philipbut it deduct the credit note entered only
>> from the bill due in september which is MYR 52.6+MYR 278 -MYR 234=MYR96.6
>> 10:14Philipwhich isn't really make sense as I don't wanna overpaid as the
>> credit note is already pass through at 22/6/201310:14Philiphelp please~
> Wow, this is hard to read.  It's clearly a cut-and-paste from IRC..
>
> I'm not exactly sure what a "Due Date" means for a Credit Note.  Nor do
> I know how the Report handles Credit Notes.
>
> Geert, the guy who worked on Credit Notes, is currently on holiday so
> hopefully he'll get to your question within a few days.  Please be
> patient.
Hi Philip,

I had to edit your mail in a text editor to make sense of it.I have 
copied a cleaned up version below so others can follow as well:

<quote>
help on payable aging report
on GnuCash 2.5.3
i entered a credit note using the new invoice feature
eg
11/06/2013 10/08/2013 5070112344 Bill JV1306084 MYR 397.50 MYR397.50
let's reset this
Date       Due Date   Reference  Type Description Credits       Debits Amt
11/06/2013 10/08/2013 5070112344 Bill JV1306084   MYR 397.50  MYR   397.50
12/06/2013 11/08/2013 5070112429 Bill JV1306043   MYR 1,692.00  MYR 1,692.00
12/06/2013 11/08/2013 5070112432 Bill JV1306044   MYR 107.50  MYR   107.50
22/06/2013 21/08/2013 000008     Bill JV1306084A -MYR 234.00 -MYR   234.00
02/07/2013            BPV1307001 Paym MBB029927  -MYR 1,858.50 -MYR 1,858.50
02/07/2013 31/08/2013 5070113099 Bill JV1307028   MYR 7,253.76  MYR 7,253.76
02/07/2013 31/08/2013 5070113100 Bill JV1307027   MYR 95.00  MYR    95.00
15/07/2013 13/09/2013 5070113740 Bill JV1307076   MYR 52.60  MYR    52.60
15/07/2013 13/09/2013 5070113743 Bill JV1307075   MYR 278.00  MYR   278.00
Total Due MYR 9,642.36

Current   0-30 days    31-60 days   61-90 days   91+ days
MYR 96.60 MYR 9,545.76 MYR 0.00     MYR 0.00     MYR 0.00

with setting of due date set to
31/8/2013

It should show up on 0-30days as MYR 9545.76 -MYR234
(the credit note)
but it deduct the credit note entered only
from the bill due in september which is MYR 52.6+MYR 278 -MYR 234=MYR96.6
which isn't really make sense as I don't wanna overpaid as the
credit note is already pass through at 22/6/2013
help please~
</quote>

Firstly I'm confused as to what is your credit note. From your 
introductory text, you suggest that Bill JV1306084 (397.50) is your 
credit note. But from the payable aging report you paste ,the credit 
note is Bill 000008 for a different amount: 234.00.

Unfortunately even then the numbers don't add up. On 31/8 your Current 
value should be
397.50 + 1,692.00 + 107.50 - 234.00 - 1,858.50 = 104.50 instead of 96.60

Similarly 0-30 days should be
7,253.76 + 95.00 + 52.60 + 278.00 = 7,679.36

(Note that I don't use this report myself, so my interpretation of the 
due amounts may be wrong as well).

So in my opinion the report is wrong indeed. Unfortunately I can't see 
if this is due to the report interpreting the data incorrectly or due to 
the invoice payment logic messing up.

Can you create a bug report for this in our bugzilla database please ?
This page explains how to use bugzilla: 
http://wiki.gnucash.org/wiki/Bugzilla

Please attach a simple gnucash data file that illustrates this problem 
if you can That will make it easier to debug.

Thank you,

Geert