Printing the A/R Overdue Receivables Report

The Overdue Receivables report groups outstanding transactions or balances into a current period and four aging periods by document date or due date. Use the report to analyze your overdue receivables.

You can print the report with transactions listed by due date or by document date.

When to Print

Print the Overdue Receivables report when you need a listing of overdue receivables on a given date, such as at the end of a fiscal year or period, or when you want to identify documents or balances on which to charge interest, to take action to collect, or to write off.

  • Select printing destinations and, if necessary, turn on and connect the printer.

To print the report:

  1. Open Accounts Receivable > A/R Transaction Reports > Aged Trial Balance.
  2. Make your selections in the following fields:
    • Report Type. You can age overdue documents or balances by their document or due dates (Overdue Receivables By Due Date, or Overdue Receivables By Document Date).
    • Age As Of. Specify the date on which to report the receivables. The program uses this date to assign transactions or balances to aging periods. For example, if you print the report by due date, the program assigns each transaction to an aging period by calculating the number of days between its due date and the Age As Of date.
    • Cutoff By. The report includes only transactions or balances for which the document date, posting date, or year/period (depending on your selection for this field) 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.
    • Account Type. You can list Open Item customers or Balance Forward customers, or All Customers.
    • Print Transactions In. Indicate whether to print a Summary or detailed report, and whether to print the detailed version of the report by document date (Detail by Document Date) or by document number (Detail by Document).
    • Use Aging Periods. The aging periods entered on the A/R Options screen appear, but you can assign different periods for individual reports.
    • Select Customers By. Specify up to four selection criteria, to indicate the customer accounts to list on the report. For the first selection, choose from Customer Number, National Account, Customer Group, Billing Cycle, and Short Name.

      For the remaining three selection criteria choose from the above, and Customer optional fields, if any, Territory, Account Set, Currency Code (multicurrency ledgers only), Current Balance, Current Functional Balance (multicurrency ledgers only), Customer Name, Salesperson, and Start Date.

      If you do not specify selection criteria, the report includes all customer records with the account type you select.

    • Sort Customers By. You can choose up to four orders by which to list (sort) records for the report. You can sort by customer optional fields (if any), Territory, National Account, Customer Group, Billing Cycle, Account Set, Currency Code (multicurrency ledgers only), Current Balance, Current Functional Balance (multicurrency ledgers only), Customer Name, Salesperson, and Short Name. If you do not specify sorting criteria, the report orders the records by customer number.

      If you do not specify sorting criteria, the report orders the records by customer number.

    • Show Group Subtotal. If you want to include subtotals for each sorted group, select the Show Group Subtotal option for the groups of records you are sorting by.
    • [Include] Contact/Phone/Credit. Choose this option if you want to list the customer's contact person and the customer's phone number and credit limit.
    • [Include] Space for Comments. Choose this option to leave a blank space at the end of each customer record for your notes.
    • [Include] Only Customers Over Their Credit Limits. Choose this option to restrict the report to customers whose outstanding account balances exceed their credit limits or whose transactions are overdue by more than the number of days stipulated in the customer record.
    • [Include] Customers With A Zero Balance. Choose this option to include accounts with a zero balance.
    • Select Transaction Types. Select the types of transactions to include on the report. (You can include any or all of the transaction types listed.)

      If you select Adjustment, adjustments are listed separately from the transactions to which they were applied.

    • [Show] Applied Details. Choose this option to include all the documents such as receipts and credit notes that were applied to each reported invoice. If you do not select this option, the report shows only the balance owing for each outstanding transaction.
    • [Show] Fully Paid Transactions. Choose this option to list documents that are fully paid, but not yet cleared from Accounts Receivable.

      If you select this option, you can specify the earliest date for which to show fully paid transactions, if you want to see only recent fully paid transactions.

    • Aged Retainage. Select this option if you want to include aged retainage balances for each customer. (This option appears only if you are printing the report by due date.)

      Sort Transactions By Transaction Type. Select this option if you want to group transactions by type for each customer.

    • Print Amounts In. Use this option to select the currency for the report (for multicurrency ledgers). 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.