Printing the A/R Aged Retainage Report

The Aged Retainage report lists outstanding retainage amounts.

Note: It does not include retainage that has been invoiced or applied to a debit note or a credit note.

In multicurrency ledgers, you can print the report in your functional currency or in the customer currencies used in posted transactions.

For more information, see A/R Aged Retainage Report.

When to Print

Print the report periodically, or whenever you want to analyze outstanding retainage.

  • Verify the print destination and, if necessary, turn on and connect the printer.

To print the A/R Aged Retainage report:

  1. Open Accounts Receivable > A/R Transaction Reports > Aged Retainage.
  2. Select report options. More...

    • Report Type. You can choose the following options:

      • Aged Retainage By Due Date. 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 is due in a future period, the outstanding retainage amount for that detail appears in the Future period.

      • Future Retainage By Due Date. Print a report that shows outstanding retainage amounts that are due in future aging periods, beginning with the Age As Of date.
      • Overdue Retainage By Due Date. 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 on the A/R Options screen appear, but you can assign different periods for individual reports.
      • 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 By. Specify up to four selection criteria, to indicate the customer accounts to list on the report. If you do not specify selection criteria, the report includes amounts for all customers that use the account type you select.
    • Sort 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 customer number.
    • Title. If you want to include titles for each sorted group, select this option for groups of records you are sorting by.
    • Total. If you want to include totals for each sorted group, select this 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 customer 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 you are printing to a physical printer, the Print window appears. Confirm your printer selection and the number of copies to print, and then click OK. Otherwise, click Cancel or Setup.
    • If you are printing to the screen (preview), the report appears in a new window. You can print the report or export it to a file.

      Note: For Web-based clients, the preview screen appears first when you click the Print button.

    • If you are printing to a file, the Export window appears. Specify the file format (for example, PDF, DOC, or XLS). Also, specify a destination for the file:

      • Application. View the report in an application that can open files of the specified format (for example, if you specify PDF as the file format, the report opens in Adobe Acrobat). You can then save the file.
      • Disk file. Save the report to a location you specify.
      • Microsoft Mail. Send the report as an e-mail attachment.

      You can enter the name of a non-existent file or directory to be created by the system when you print. When you print to a file, the report is assigned a unique name, for example, CS1000.TXT.

    • If you are printing to e-mail, an e-mail message appears with the report attached.