Answer: After a customer's payment has been received and posted to their account, we are often asked how to print a report to show exactly how much has been paid over a time period and which invoices were paid along with it. The solution to this question lies in one of the most powerful reports available in Solid Route Accounting™ - Enterprise Edition of the Bill Analysis Report. This powerful report can not only cover a broad range of reporting needs. Still, it can be tailored to report on a specific sales transaction type, including Received On Account (ROA) payments, for any desired date range.
- To begin, in Solid Business Central™, navigate to [Accounting / Report / Bill Analysis]. Set '00' for the workstation and '000' for the route numbers, unless this report is to be more restrictive than All ROA transactions. Use <CTRL+END> to accept these settings.
- For 'Choose Order', select [Date] and set the starting and end date for this report to cover. Notice that this report can also be set for a range of transaction numbers by choosing [Number] instead.
- 'Print Bill Info', when set to Y, will print a one-line summary of each ROA created within the set period, including the transaction number, date of creation, ROA amount, and grand totals at the bottom.
- 'Print Item Detail', when set to Y, will also print the breakdown of each ROA's total, including the amount paid for each invoice, the invoice number, and the customer number to which the invoice belongs.
- Set 'Include ALL bills or one type' to 'R' for ROA. This will include only ROA-type transactions for that period.
- All other fields will not affect this report. When ready, use <CTRL+END> to print this report.