Solved: Receivables Aging Misreporting

[Derek Atkins]

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