Receivables Aging Misreporting

Derek Atkins warlord at MIT.EDU
Wed Mar 17 10:05:32 EDT 2010


Hi,

Pablo Francesca <rshgeneral at yahoo.com> writes:

> We'll, doing a manual calculation of the customer's invoices and payments     
> yields equal amounts; 5k in debits and 5k in credits.  So it's the receivables
> aging report that is wrong.                                                   
>                                                                               
> Not sure what an auto-payment-forward transaction, but this customer does     
> prepay for service, so most, if not all A/R transactions for this client are  
> split transactions.                                                           

Take a look in your A/R account and you'll see them.

> How do I got about fixing this?                                               

Sounds like https://bugzilla.gnome.org/show_bug.cgi?id=488035 or
https://bugzilla.gnome.org/show_bug.cgi?id=143418

-derek

> --- On Tue, 3/16/10, Derek Atkins <warlord at MIT.EDU> wrote:                    
>
>     From: Derek Atkins <warlord at MIT.EDU>                                      
>     Subject: Re: Receivables Aging Misreporting                               
>     To: "trythis" <grahamlane at gmail.com>                                      
>     Cc: gnucash-user at gnucash.org                                              
>     Date: Tuesday, March 16, 2010, 9:10 AM                                    
>                                                                               
>     Another possibility is that you hit the bug where GnuCash thinks          
>     the invoices weren't paid properly and you've got lots of                 
>     auto-payment-forward transactions in your A/R account throwing            
>     off all your balances.                                                    
>                                                                               
>     -derek                                                                    
>                                                                               
>     trythis <grahamlane at gmail.com> writes:                                    
>                                                                               
>     > The only thing that comes to mind is the possibility of dates being     
>     different                                                                 
>     > in the two reports.                                                     
>     > Could it also be possible that one of the payments is not applied       
>     properly                                                                  
>     > within an invoice?  I am only guessing here, but maybe one of the       
>     payments                                                                  
>     > has been entered many days past the due date of the invoice as because  
>     you                                                                       
>     > made the payment entry a year after the actual payment was made and     
>     forgot                                                                    
>     > to backdate the payment and the aging report added the interest.  I am  
>     also                                                                      
>     > guessing that a regular report might also show such a debt so that idea 
>     is                                                                        
>     > probably terrible.                                                      
>     >                                                                         
>     >                                                                         
>     > Pablo Francesca wrote:                                                  
>     >>                                                                        
>     >> When I run a receivables aging report, one of my clients shows an      
>     >> outstanding debit balance of $125.  When I run a customer report for   
>     this                                                                      
>     >> same customer, the report shows a $0 balance.                          
>     >>                                                                        
>     >> How could this be possible?                                            
>     >>                                                                        
>     >>                                                                        
>     >>                                                                        
>     >>                                                                        
>     >> _______________________________________________                        
>     >> 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.                   
>     >>                                                                        
>     >>                                                                        
>                                                                               
>     --                                                                        
>            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.                      
>

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