Receivables Historical Aged Trial Balance
This report shows a breakdown of customer balances on a previous date, including transaction amounts, retention withholding, retention billing, and aging. Similar to Receivables Aged Trial Balance, which reports the most recent aging and amounts that are currently outstanding, the Receivables Historical Aged Trial Balance report allows you to review past transactions, previous balances, and payment history. You can group information by job/master ID, or you can view transactions by customer, totaling all jobs/master IDs assigned to that customer. You can also view report totals for all customers. You can select to include information from Service Management, Job Cost, and/or Equipment Management. A job/master ID can be a Job Cost job or project invoice, a Service Management maintenance contract, master contract, or service call invoice, or an Equipment Management rental invoice. You can also specify whether you want to show credit balance and zero balance information, no activity, fully paid documents, and unposted applied credit documents. In addition to using this report to help with collections, the transaction detail on the Receivables Historical Aged Trial Balance report supports the balance in your Accounts Receivable and Retention Receivable GL accounts. You can print this report from its location in the Report Manager, or from Microsoft Dynamics GP by opening the Administration page and locating this report on the Custom Report List.
