Customer Balance Summary

What's on this report?

The customer balance summary report produces the correct information for the last financial year. However, the customer balance detail report displays large numbers of customers for whom there was no activity during the year. 

 

      Type   Date   Num   Account   Amount   Balance
  Ruthbell,Caroline                        
        Invoice   10/03/2013   9   Accounts Receivable    226.00   226.00
        Invoice   10/03/2013   10   Accounts Receivabe   210.00   436.00
        Invoice   10/03/2013   11   Accounts Receivabe   226.00   662.00
        Invoice   10/03/2013   12   Accounts Receivabe   226.00   888.00
        Credit Memo   10/03/2013   19   Accounts Receivabe   0.00   888.00
  Total Ruthbell,Caroline                   888.00   888.00
  Martinez,Martha                        
        Invoice   10/03/2013   5   Accounts Receivabe   226.00   226.00
        Invoice   10/03/2013   6   Accounts Receivabe   210.00   436.00
        Invoice   10/03/2013   7   Accounts Receivabe   226.00   662.00
        Invoice   10/03/2013   8   Accounts Receivabe   226.00   888.00
        Credit Memo   10/03/2013   18   Accounts Receivabe   0.00   888.00
  Total Martinez,Martha                   888.00   888.00
  Goodman,Theresa                        
        Invoice   10/03/2013   5   Accounts Receivabe   226.00   226.00
        Invoice   10/03/2013   6   Accounts Receivabe   210.00   436.00
        Invoice   10/03/2013   7   Accounts Receivabe   226.00   662.00
        Invoice   10/03/2013   8   Accounts Receivabe   226.00   888.00
        Credit Memo   10/03/2013   9   Accounts Receivabe   0.00   888.00
  Total Goodman,Theresa                   888.00   888.00
  Loyola,Peter                        
        Invoice   10/03/2013   1   Accounts Receivabe   226.00   226.00
        Invoice   10/03/2013   2   Accounts Receivabe   210.00   436.00
        Invoice   10/03/2013   3   Accounts Receivabe   226.00   662.00
        Invoice   10/03/2013   4   Accounts Receivabe   226.00   888.00
  Total Loyola,Peter                   888.00   888.00