Aged Trial Balance (ARR715)

Using Reports

Use this program to print an Aged Trial Balance from the information stored in the Open Documents file.

Templates that store "current period" (or similar values like "system date") resolve to the "current period at the time the report is run" rather than what the "current period" was at the time the template was created. For example: If you save a template for the Aged Trial Balance and select "System Date" for the aging Date field, when that template is selected to run again (either manually or via Job Stream) the current date is determined using the FACTS system date when the listing is run not the date when the template was created.

Report information includes the following:

• Summary: for each customer the customer number, name, last payment date, last sale date, customer balance and the total amount due in each aging column.
  
• In Summary mode, the *Disputed Invoices* indicator prints on the Aged Trial Balance Report when a customer has any disputed invoices on file, unless the report is to only print disputed invoices, then the indicator is not needed. If the report is printing disputed invoices only, this will be indicated at the top of the first page.
  
• In Summary mode, the "Over Credit Limit of " indicator, the credit limit, and the customer balance and transactions prints on the Aged Trial Balance Report when a new customer is encountered. The open documents balance is also included. If the report is printing over credit limit only, this will be indicated at the top of the first page.
  
• Detail: all open documents for each customer. Printed information consists of document number, disputed invoice marker, type, entry date, due date, current amount and amount in the appropriate aging column. Also included is a report total.
  
• Detail with transactions: everything in the detail report plus the original amount, transaction date, type and amount and customer total for all transactions.
  
• *Returns Pending Credit* prints underneath the customer’s name if there are open customer returns documents for the customer listed on the report.
  

The report also includes the total number of customers listed, as well as the customer and report totals.

FACTS Report Formatter and Multiple Output Options

This report has access to the FACTS Report Formatter and Multiple Output option. The Multiple Output option allows you to print to more than one output for each instance of a report. For example, a report can print to Excel, the viewer, and to a printer all in one print run. To access the multiple output feature simply choose the Multiple option from the Print Options screen. The FACTS Report Formatter allows you to expand your reporting capabilities beyond defining a printer (in Printer F/M). To access the FACTS Report Formatter, select Custom Report Layout--> Customize Report from the menu bar.

Access this program by choosing Accounts Receivable-->Reports & Prints-->Aged Trial Balance.

Click Field Descriptions for information on each field.

See Also

Using Reports

Using print options

Using report templates

Viewing reports on screen (using the viewer)

Using reports and prints as audit trails