Receivables Aging Misreporting

[Pablo Francesca]

I've circled what I considered a lot in the a/r screenshot file.  I quoted the term lot to indicate that i was using the term according to my understanding of the bug report.  I used the term transaction to encompass the debit/credit entries that accompany the creation of an invoice.

The customer_report file shows a zero balance (not seen on screenshot).  None of the entries created in A/R account were created w/o using normal create invoice dialog or post payment dialog. Again, I've never created an invoice for this customer (active or otherwise) for $750 or $850.  I've also never taken a payment for this customer for those amounts. 

Let me know if you need more screen shots of A/R entries.

--- On Thu, 3/18/10, Derek Atkins <warlord at MIT.EDU> wrote:

From: Derek Atkins <warlord at MIT.EDU>
Subject: Re: Receivables Aging Misreporting
To: "Pablo Francesca" <rshgeneral at yahoo.com>
Cc: "trythis" <grahamlane at gmail.com>, gnucash-user at gnucash.org
Date: Thursday, March 18, 2010, 8:16 AM

Hi,

Pablo Francesca <rshgeneral at yahoo.com> writes:

> Okay, so I see the auto pay forwards.  I read the bug report. My understanding
> is that payments and invoices are grouped in lots by invoice owner. Each lot  
> can contain either 1 invoice and any number of payments, or a lot can contain 
> any number of payments or "saved payments" (over-payments, pre-payments). and 
> no invoices.                                                                  

Correct, each lot can contain 0 or 1 invoices, and any number of payments.

> So I start looking through A/R transactions for this customer.  The first     
> transaction "lot" indicates a payment and an invoice for 850.  Well, this     
> customer has never made a payment for 850.  On the date in question, an       
> invoice was created for 100.  Doesn't make sense.                             

I'm not sure what you mean by this.  How can a "transaction" indicate a
payment and an invoice?  (I'm also not sure why you put "lot" into
quotes here).

> I deleted the payment transaction for 850 and the invoice disappeared as      
> well.  I reran the receivables aging report and there was no change.  Makes   
> sense.                                                                        

If you deleted one transaction and two things disappeared that implies
to me that you created a transaction that both debited and credited the
A/R account.  That would be bad data entry and could imply other
problems in your data.

> The next lot for the customer indicated a payment for 750 and an invoice for  
> 750.  Again this customer has never made a payment for 750.  On the date in   
> question, an invoice for 100 was created.                                     

Again, this implies bad data entry, as if you posted a payment from A/R
-> A/R instead of A/R -> Bank, or you used A/R in the line-items of your
invoice instead of Income?

> I deleted the payment transaction for 750 and the invoice disappeared as      
> well.  I reran the receivables aging report and it now showed a change of 750 
> debited to the customer.                                                      

Again, if this is happening that implies (to me) that you're not
entering your data correctly.

Or you're misreading the register.

Can you supply a screen shot?

> I'm thoroughly confused.  Why are these "lots" even in existence?             

Again, why are you quoting "lots" here?

Lots are used to tie payments to invoices.  They exist to help the
system keep track of which invoices have been paid and which have not.
As reported, there is a bug in the system which I have never been able
to reproduce myself where gnucash gets "out of sync" with payments and
invoices and starts creating unnecessary forwarding transactions.

>     >     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: ar_screenshot.PNG
Type: image/png
Size: 103171 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20100318/e8072ec9/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: customer_report.PNG
Type: image/png
Size: 84259 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20100318/e8072ec9/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: aging_report.PNG
Type: image/png
Size: 21886 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20100318/e8072ec9/attachment-0005.png>