A/R Overdue Analysis Print (AR83)

The Print Overdue Analysis Report (AR83) produces the Overdue Analysis report. The Overdue Analysis considers the Terms of the Invoice in the age calculation, for example:

  • An Invoice that is 59-days old with terms of 'Net 60 Days' is a 'current' Invoice.
  • An Invoice that is 31 days old with terms of 'Net 30 Days' is aged into the 1-30 days overdue category.

  1. The Printer Selection screen automatically opens. Select the Printer destination and click OK.

  2. The Report Parameters screen for AR83 opens.

    • The Format field defaults to 'Overdue Analysis Report'. You cannot modify the Format field.

    • Select a Sequence from the drop down list. Valid options include:
      • Customer - prints in Customer code order.
      • Class of Trade - prints in Class of Trade order.
      • Tax Group - prints in Tax Group order.
      • Territory - prints in Territory order.
      • Salesrep - prints in Sales Rep order.
      • Sales Grouping - prints in Sales Group order.
      • Customer Alpha Ref. - prints in Customer Name order.

    • If a New Page for each Break is required, select the checkbox.

    • The Levels list box displays the various Levels of detail available for the report. All Levels are automatically selected in AR83; the '>' before each Level option indicates the Level is selected. Double click on the line to remove the selector. AR83 includes the following Levels:
      • Detail Line
      • Invoice
      • Customer
      • Report/Class of Trade/Tax Group/Territory/Sales Rep/Sales Grouping/Customer Name (This Level varies depending on the Sequence selected.)

    • Select the Restrictions that apply to the Report by double clicking on the line in the list box. Restrictions allow you to tailor AR83 to your specific needs. The '>' before a Restriction indicates the Restriction is selected. Once a Restriction is selected, it can be de-selected but the '>' remains. An '*' before a Restriction means the Restriction is mandatory. AR83 includes the following Restrictions:

      • Aging Date - enter the Aging Date to use for the Overdue Calculation. This is a mandatory Restriction. The date entered dictates the aging of the Invoices. The Invoice date is compared to this date, and Invoices are aged into the appropriate 30-day aging group.

        • The Invoice Terms are taken into account in this program, for example if an Invoice has 60-day terms, then it is not moved out of the 'current' column until it is 61 days old, or 1 day overdue.

        • You must enter a date within 90 days of the current date. If you enter a date that is more than 90 days prior to the current date, you will receive an out of range error.

      • Record of Collection - by selecting the check box, collection details for Customers print on the Report.

      • 0 (Zero) Balance Customers - by selecting the check box, Customers with a zero balance are not included on the Report. The Report cannot be back-dated when this option is selected because Customers that have paid their Account in full since the back-date will not be included.

      • 0 (Zero) Balance Invoices - by selecting the check box, Invoices that are in the Open Receivables file, but are fully paid, are not included on the Report.

      • A/R Bank Code - this Report can be printed for a specific Bank Code or for all Bank Codes. Use this Restriction to enter the Bank Code to include on the Report or click ALL to include all Bank Codes.

      • Qualify Dollars - enter a dollar value to restrict the Report to display Customers with AR balances equal to or greater than the valued entered.

      • Qualify Aging - this Report can be restricted to display Customers that are in a specific Delinquency category. You can select from the following options:

        • 1 day +
        • 31 days +
        • 61 days +
        • 91 days +
        • 121 days +

        Note: This restriction categorizes the customers based on their delinquency (which means terms are taken into account) to decide which accounts to print. It prints accounts from the category selected and up, i.e. if you select 61 days, customers in categories 61, 91 and 121 days are reported.

      • Post Dated Cheques - by selecting this check box, any Post Dated Cheques on file for Customers (from AR32) are reported.

      • Invoice Sequence - select the Invoice 'Print Sequence'. Valid options are 'Invoice Date' or 'Invoice Number'. This is a mandatory field.

      • Messages - enter the number of Customer messages from AR Messaging (AR46) that are to print on the Report. The option to print ALL messages is also available. The most recent messages print first. This is a mandatory field.

      • Archive Report - select this restriction if you want the data digitized from Enterprise 6.0 (or higher) to PointForce iTopia. Note: this option is not available in Enterprise 5.0.

      Note: To modify a Restriction once it is set up, reselect the Restriction and make the necessary changes.

    • Select the Range From and To for the report. The Range must match the Sequence selected; if, for example, the Sequence is Customer, you must enter Customer codes in the To and From fields. Multiple Ranges may be entered.

      • In the From field, enter the starting 'code' for the report.

      • In the To field, enter the ending 'code' for the report.

      • The information displays in the list box below.

      • To add additional Ranges, repeat these steps.

        Note: To print the entire file for the selected sequence, simply tab through the From and To fields. The list box displays *Start and *End in the From and To fields.

      • To delete a Range from the list box, double click on the line. The following message displays, "Do you wish to delete this range? Yes/No". Click Yes to delete the range.

    • When all of the information on the Report Parameters screen is complete, click OK to run the report.

  3. The Report Complete screen opens when the report is generated. Click OK to accept the report, click Restart to restart the printing of the report, or Abort to cancel the report. Note: This report does not require you to enter the Acceptance Codes.

AR83 Overdue Analysis
Print Overdue Analysis Report (AR83)