Vendor Reports

[Sutton Hill Church]

To Derek Atkins

I assure you that I entered the correct dates, as indicated on the attached
image of the bill I entered for future payment by me.

I accept that the 'Current' column, would contain the values of any bills
which need paying and which are still within the terms of payment.

The results shown on the report do not imply I've got the dates wrong.  It
implies that the source code, written to generate the report, is incorrect
and needs rewriting. 

Further to this, I also have a customer who has  2 outstanding invoices to
be paid, and I got the same results when I generated the customer report to
show how much he still owed me.
i.e. the date I raised the invoices is given as the 01/01/2012, when I
actually raised them on the 6th and 7th, June respectively, the dates I
expect the invoices to be paid aren't shown, and according to the report
they are 61 to 90+ days overdue for payment, when they should be in the
'Current' Column. 

This also implies that the source code for the Customer Report is the same
code, and that an 'If, Then, Else, End if' or 'Select , End Select'
statement has been included in the code to generate the report with the
required Heading (Bill or Invoice)

Treasurer


-----Original Message-----
From: Derek Atkins [mailto:derek at ihtfp.com] 
Sent: 30 June 2012 22:11
To: Sutton Hill Church
Cc: gnucash-user at gnucash.org
Subject: Re: Vendor Reports

Hi,

On Sat, June 30, 2012 4:58 pm, Sutton Hill Church wrote:
[snip]
> I wanted to check how many days I was overdue paying a particular 
> invoice and opened the Vendor report (Reports – Business – Vendor 
> Reports) for the vendor concerned, and got the following:-
>
> You will note the date is given as 01/01/2012, The due date is not 
> reported and the account is reported as being 91+ days overdue.
>
> However, I only entered the details of the vendor’s invoice and posted 
> it to the Accounts Payable account on the 11th June 2012, with a due 
> date of the 25th June 2012.
>
> Surely, the ‘Current’ column should show the sum of all outstanding 
> payments to be paid, in this case £54.15, and the £54.15 should also 
> be shown in the
> 0-30 days Column, as I am only 6 days overdue in paying the invoice.

The fact that the bill does not show up in the listing, and that the
£54.15 shows up as a "Balance" implies that you got the date wrong on the
bill, and that it is before your 1/1/12 date.  Can you show us the actual
bill as posted?  I bet that the date posted (and therefore date due) is not
what you think it is.

> Regards
>
>
>
> Treasurer

> 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                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant



-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2178 / Virus Database: 2437/5102 - Release Date: 06/30/12
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Untitled.png
Type: image/png
Size: 150858 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20120701/7074c22f/attachment-0001.png>