Issue on payable ageing report

Wed Jul 24 22:48:43 EDT 2013

Hi Derek,
Thanks for your reply, this is my first approach trying to report an issue,
sorry for the inconvenience as I appreciate that it's a freeware.

I have attached the print screen with the report setting to show what
exactly the issue is here.

For me, logically with the report date set to 31 Aug 2013, the 0-30days
should be the total of all the bill due before or equal to 31 Aug 2013
minus all the credit note or payment issued before 31 Aug 2013 and the
31-60days should show the total of all the bill posted that's due on 1st
sept to 30 sept and so on..but the print screen I showed actually didn't
work as expected.

Thanks,
Philip

  DIRECTOR/PHARMACIST IN CHARGE  PHILIP TIONG ING LIK    CHENLIK PHARMACY
SDN. BHD. (1042902V)  LOT 1184,BLOCK 18, SEDUAN LAND DISTRICT,JALAN
SALIM,  96000
SIBU, SARAWAK, MALAYSIA  Phone: +60 84 217607
Fax: +60 84 218 271
 Email/Gtalk: chenlikpharmacy at gmail.com
Whatsapp: +60 16 579 5829

On Thu, Jul 25, 2013 at 12:57 AM, Derek Atkins <warlord at mit.edu> 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.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>        Member, MIT Student Information Processing Board  (SIPB)
>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>        warlord at MIT.EDU                        PGP key available
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Gnucash Vendor Report Issue.jpg
Type: image/jpeg
Size: 323432 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20130725/77e6c2cb/attachment-0001.jpg>