Solved: Receivables Aging Misreporting

Pablo Francesca rshgeneral at yahoo.com
Thu Mar 18 22:41:04 EDT 2010


>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.

Well, my solution was, as Derek had forewarned, not a valid solution.  However, in trying to delete all the payments, I discovered the original reason for the problem.

Again, to save others time in the future, be aware that the customer report will not (by default) display the results for an invoice whose post date is in the future.  

My problem was arising because my partner had entered an invoice on 3/09/10 for services rendered on 2/24/10 and used a post date of 3/24/10. The receivables aging report was catching this mistake and reporting correctly.  (The invoice was posted and active). The customer report obviously wont report this because it
 only displays by default to the current date.

Unfortunately, now I have to tell the customer he owes me more money after he thought he had paid in full. 


--- 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



      
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this
 by using Reply-To-List or Reply-All.



      


More information about the gnucash-user mailing list