Solved: Receivables Aging Misreporting

Pablo Francesca rshgeneral at yahoo.com
Thu Mar 18 17:31:48 EDT 2010


Well, to be more precise.  I should have said I deleted all auto-pay forwards that did not correspond with an actual payment from this customer starting from the earliest payment until the two reports reconciled.  I did not mean to imply I deleted all auto-pay forwards from this customer.  It turns out there actually was another, but it was the last and latest one. It did not need to be deleted.

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

From: Derek Atkins <warlord at MIT.EDU>
Subject: Re: Solved: 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, 3:05 PM

Hi,

Pablo Francesca <rshgeneral at yahoo.com> writes:

> I had kept a backup copy, so  I wasn't worried about messing up anything.     
>                                                                               
> In summary, (while I dont understand the math behind it, nor the reason it was
> caused), your advice did resolve the issue.  However, it was not necessary to 
> delete all the payments.  All I needed to do was delete any auto-pay forward  
> that did not correspond with an actual payment. There were three, the two we  
> discussed and another one more recently.                                      
>                                                                               
> For anyone who can benefit from this discussion in the future, be aware that  
> the amount of the discrepancy between the two reports will not necessarily be 
> related to the auto-pay forwards that you delete. For example, I initially    
> started with a discrepancy of +125. I deleted an auto-pay forward for 850 with
> no effect on this amount.  I deleted an auto-pay forward of 750 and the       
> discrepancy changed to -625.  Finally, I deleted an auto-pay forward for 500  
> and the two reports matched.                                                  

Just a note to those reading this in the future -- be very careful if
you are JUST deleting the auto-payment-forward transactions...  It might
leave your invoice lots out of balance so the next payment might wind up
creating them again.

One way to check that you've got it correct is to perform a search for
invoices for this customer and make sure they are all marked as Paid.

-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



      


More information about the gnucash-user mailing list