Aged Trial Balance (ARR715)

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 Reportfrom the menu bar.

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

To set up an Aged Trial Balance report:

1. Select the order in which to print the report. The options are Customer, Alpha, Salesperson/Territory and Customer Class (K).

2. Select the Over Credit Limit Only checkbox to run the report for customer that are over their credit limit only.

3. Select the beginning order choice to print. For instance, if you set the report to print in Customer order, select the first customer that should appear. Press F1 or $image\ex_allft_shg.gif$ to default to FIRST. Press F2 or $image\find_shg.gif$ to search of customers, salespeople and classes.

4. Select the ending order choice to print. For instance, if you set the report to print in Customer order, select the last customer that should appear. Press F1 or $image\ex_allrt_shg.gif$ to default to LAST. Press F2 or $image\find_shg.gif$ to search of customers, salespeople and classes.

5. Select which branches to include. The entry must be a valid in the system. The program defaults to the branch assigned to the terminal. Press F1 or $image\all_shg.gif$ to default to ALL. Press F2 or $image\find_shg.gif$ to search.

6. Enter the date upon which aging will be based. Press F1 or $image\sysdate_shg.gif$ to default to the system date.

7. Indicate whether or not to include Next Period documents and transactions. The program defaults to selected.

8. Indicate whether or not to include Delinquents Only on the report. The program defaults to unselected.

9. If you selected the Delinquents Only checkbox, enter the number of days a document must be past due in order for it to appear on this report (0-999). The program defaults to 10.

10. Indicate whether to include Credits on the report. The program defaults to selected.

11. Select the Disputed Only checkbox to run the report for disputed invoices only.

13. Indicate whether to check if the customer is over their credit limit by selecting the Credit Limit Check prompt, or leave unselected to skip the credit limit check.

14. Enter whether to include Contact information and/or Sales figures. The program defaults to NONE.

15. Select the document’s scope. Options are Summary, Detail or detail with Transaction information. Press Enter (CR) to default to S.

16. Select OK or press Enter (CR) to run the report.

Aged Trial Balance (ARR715)

To set up an Aged Trial Balance report:

See Also