Aged Retainage Report — Printing

The Aged Retainage report lets you print reports of outstanding retainage amounts owed to vendors.

For information on the contents of this report, see Aged Retainage Report - Features.

When to print

Print the report when you need to review retainage that is due to vendors, such as at the end of a fiscal year or period.

To print the report

1. Choose the Aged Retainage icon from the A/P Transactions Reports folder.

2. Select report options as follows:

   Report Type. You can choose:

   • Aged Retainage By Due Dateto print a report that shows all outstanding retainage amounts that are due for each aging period, including Future and Current.
     
     For job-related documents, if one of the document details becomes due in a future period, the outstanding retainage amount for that detail appears in the Future period.
   • Future Retainage By Due Dateto print a report that shows outstanding retainage amounts that will become due in future aging periods, beginning with the Age As Of date.
   • Overdue Retainage By Due Dateto print a report that shows only outstanding retainage amounts that became overdue in each aging period.

   Age As Of. Specify the date on which to report the retainage. The program uses this date to assign retainage to an aging period by calculating the number of days between its due date and the date entered in the Age As Of field.

   Cutoff By. The report includes only those transactions or balances that have a due date before or on the cutoff date you specify. There are three methods for selecting a cutoff date:

   • Document Date

     Select this option to include documents based on their document date (regardless of the fiscal period to which you assigned them). Enter a date in the Cutoff Date field. If you enter zeros for the month, day, and year, the report includes all transactions, regardless of date.

   • Posting Date

     Select this option to include documents based on their posting date. Enter a date in the Cutoff Date field. If you enter zeros for the month, day, and year, the report includes all transactions, regardless of date.

   • Year/Period

     Use this method if you want to include all transactions up to the end of a fiscal period. Make your selections in the Year and Period fields.

   Print Transactions In. Indicate whether to print a summary or a detailed report, and whether to print the detailed version of the report by document date (Detail By Document Date), by due date (Detail By Retainage Due Date), or by document number (Detail By Document).

   Use Aging Periods. Aging periods are used to group outstanding retainage amount. The aging periods entered in the Options form appear, but you can assign different periods for individual reports, if you want.

   • On the Aged Retainage By Due Date report, all outstanding retainage amounts are grouped according to the dates on which they become due.
   • On the Overdue Retainage By Due Date reports, overdue outstanding retainage amounts are grouped according to the dates on which they became due.
   • On the Future Retainage By Due Date report, outstanding retainage amounts are grouped according to the future dates at which they will become due.

   Select Vendors By. Specify up to four criteria to select the vendor accounts to list on the report.

   For the first selection criterion, choose from:

   • Vendor Number
   • Vendor Group
   • Short Name

   For the remaining three selection criteria choose from the above, and:

   • Account Set
   • Vendor Balance
   • Vendor Equivalent Balance (multicurrency ledgers only)
   • Vendor Name
   • Currency Code (multicurrency ledgers only)
   • Start Date
   • Vendor optional fields, if you use optional fields

   If you do not specify selection criteria, the report includes amounts for all vendors that use the account type you select.

   Show Group Title. If you want to include a title for each sorted group, select the Title check box for each group of records you are sorting by.

   Sort Vendors By. You can choose up to four orders by which to list (sort) records for the report. If you do not specify sorting criteria, the report orders the records by vendor number.

   Show Group Subtotal. If you want to include subtotals for each sorted group, select the Show Group Subtotal option for groups of records you are sorting by.

   Include Taxes. Select this option to include tax information on the report.

   Print Amounts In.  Use this option to select the currency for the report. You can list transaction amounts in the vendor currency or the functional currency.

   If you list transactions in the functional currency, and you have performed a revaluation, the report shows the new functional amounts.

3. Click Print.

   If printing to a printer, Accounts Payable displays the print destination form to let you confirm your printer selection and change the number of copies to print. Choose OK if the settings are correct; otherwise, choose Cancel or Setup.

   If printing to a file, Accounts Payable displays the name of the file, so you can change it or cancel printing.

   If printing to the screen (preview), Accounts Payable displays the report. If you want, you can then export it to a file or send it to the printer.

   If printing to e-mail, Accounts Payable displays an e-mail message form for you to fill in, and inserts the report as an attachment when you choose Send.

   If printing to a schedule, Accounts Payable displays the Schedule Report form.

Related Topics