Receivables Aging Misreporting

[Derek Atkins]

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