Sorry . I want to make a new report. The current one is by provider. I want the new report by year. So all providers would be on one page.
For category Accounts Receivables>90days and Gross Days outstanding in A/R i would need to show those valve based on the last month. So for example for 2011 i would display valve from December 2011. For 2012 since the numbers are up to July 2012 i would display valve for July 2012.
2011. Category Doe Smith Gross A/R Beginning $ 20,000.00 $ 13,936.74 Total Charges $ 10,000.00 $ 20,000.00 Payments $ 5,000.00 $ 10,000.00 All/Adj $ 2,000.00 $ 3,000.00 Gross A/R Ending $ 23,000.00 $ 20,936.74 Accounts Receivables>90days 80% 83% Based on December 2011 Gross Days outstanding in A/R 40 50