Aged Payables Report (APR730)

Using Reports

Use the Aged Payables Report program to obtain a printout of open payables grouped into aging columns. It may also be used to print only past due amounts.

You have the option to:

Select the order to print - vendor, alpha or vendor class.
Select beginning and ending order choice.
Select the branch(es) to print.
Select the document group(s) to print.
Enter the aging date.
Select up to 999 days past due to print.
Print next period’s information.
Print vendor phone numbers and contacts.
Print year-to-date and prior year figures.
Print in summary or detail format.

Ü The Aging Column headings are determined by what is entered in the Aging 1, Aging 2 and Aging 3 controls in the AP Static Control F/M.

Report information includes the following:

Summary: Vendor number, name, date of last payment, balance, current amount and the total amount in each aging column.
Detail: Vendor number, name and date of last payment. Then information regarding each open document for the vendor is printed including document number, entry date, due date and the invoice amount. Phone numbers, contacts and historical data may be included on either the summary or detail formats.

Report totals are included for each time period and total vendors listed. The total number of vendors listed is also included.

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.

Unform Archiving

The Aged Payables Report can archive information to Unform. The document ID is automatically generated as a sequential number and all copies are printed to the Unform Archive.

Use the following fields to print the Aged Payables Report:

1. Order

Select the order in which to print the report. Options are vendor, alpha or vendor class.

2. Beginning order choice

Enter the beginning order choice to print. Press F1 or $image\ex_allft_shg.gif$ to default to FIRST. Press F2 or $image\find_shg.gif$ to search for vendors and vendor classes.

3. Ending order choice

Enter the ending order choice to print. Press F1 or $image\ex_allrt_shg.gif$ to default to LAST. Press F2 or $image\find_shg.gif$ to search for vendors and vendor classes.

4. Branch

Enter branch number to print. The entry must be a valid branch. 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.

5. Document groups

Enter up to 10 two-character document groups side by side to print. Press F1 or $image\all_shg.gif$ to default to ALL. Document groups are established in Vendor F/M on the Miscellaneous tab. Note that you may also select "Documents that have no document group" for this option.

6. Aging date

Enter the aging date to be used in determining which column an invoice belongs to. Press $image\ex_allft_shg.gif$ to default to the system date.

7. Days past due

Enter the number of days past due an invoice must be to appear on this report (0 - 999). Select $image\none_shg.gif$ for no cutoff (NONE), in which case all documents, including current invoices, will print.

8. Next period

Indicate whether documents and transactions posted to the next AP period should be included. The program defaults to selected.

9. Contact information

Indicate whether to print the vendor’s phone number and contact. This information may be useful in making calls about invoices or payments. The program defaults to unselected.

10. Purchase information

Indicate whether to print year-to-date and prior year invoice totals for each vendor. The program defaults to unselected.

11. Scope

Enter whether the report is to print Summary or Detail information. The program defaults to S.

Aged Payables Report (APR730)

Using Reports

Use the following fields to print the Aged Payables Report:

See Also

Using Reports