How to tip Sage 100 ERP: AR Balance Sheet and AR Aged Invoice Report

Common Question:  In Sage 100 ERP (formally Sage MAS90) the Accounts Receivable Aged Invoice Report does not agree with the Accounts Receivable amount on the balance sheet.  It balanced at the end of last month, what  did I do or how can I correct this?

Answer:  

1. The first step is run the Accounts Receivable Trial Balance Report for the same period. Does this report balance to the balance sheet? Yes
2. Second step, If the Accounts Receivable Trail Balance Report balances, then this normally means there are dating issues with the input of Accounts Receivable Invoice data entry. In other words an invoice with an invoice date of 5/31/2012 should be posted with an accounting date of May 2012. If it was posted with an accounting date of 6/1/2012 this would case the Accounts Receivable balance to not agree with the Accounts Receivable Aged Report.
3. Third step, through Accounts Receivable Customer Maintenance, Invoices check each of the Accounts Receivable Invoices in question that are showing up on the Aging Report. Trouble shoot them, match the invoice date with the accounting posting date. If there is an error do a reversing entry to the invoice in question and correct the date until the report balances.