AR Aged Period-Sensitive by Project

Report ID: (AR630600)

You use this report to determine the state of the open documents at the end of a particular period. This report shows the documents that are outstanding at the end of the specified period, broken down by aging periods or financial periods, depending on the settings of the statement cycle specified for each customer. The documents are listed by project (that is, the project assigned to the AR documents), by statement cycle and by customer. The balances are arranged by days past due on the last day of the specified period or by document dates. All the amounts are shown in the base currency.

Calculation of Aging Periods

The system calculates aging periods for this report based on the period you select in the Financial Period box on the Report Parameters tab of this report form and on the statement cycle settings specified on the Statement Cycles (AR202800) form as follows:

  • If the Use Financial Periods for Aging check box is selected for the statement cycle, the system will use aging periods that correspond to the financial periods; the zero aging period (the leftmost column in the report) is the financial period you have selected on this report form.
  • If the Use Financial Periods for Aging check box is cleared for the statement cycle, the system will use the aging periods that are specified for this statement cycle.

On the generated report, the selected financial period is displayed in the Financial Period box and the last date of the period is displayed in the Aged On box.

Aging of Outstanding Documents

The system distributes the open invoices, debit memos, and overdue charges over the financial periods or aging periods, depending on the statement cycle settings on the Statement Cycles (AR202800) form:

  • If Due Date is selected in the Age Based On box for the statement cycle, the system will compare the due dates of outstanding documents with the last date of the financial period that you specify in the Financial Period box of this report form. The overdue balances are grouped by the aging periods or financial periods specified for the applicable statement cycle, while the balances that are not overdue are displayed in the Current column of the report.
  • If Document Date is selected in the Age Based On box for the statement cycle, the system will compare the document dates of outstanding documents with the last date of the Financial Period you specify on this report form. On the generated report, the selected financial period is displayed in the Financial Period box and the last date of the period is displayed in the Aged On box. The balances of the documents with dates the same as or later than the aging date are displayed in the Current column on this report; other outstanding balances are broken down by the number of days from the Aged On of the report through the document date.

For more information, see Preparation of Dunning Letters: Using the AR Aging Report.

Aging of Credit Amounts

Regardless of the state of the Age Credits check box on the Accounts Receivable Preferences (AR101000) form, the system shows the due date of the outstanding AR document in the Due Date column of the report. The system determines the aging bucket based on whether the Age Credits check box is selected:

  • If the Age Credits check box is selected, the date that the system will use to determine the aging bucket (the Current column or one of the Past Due columns) is determined based on the option in the Age Based On box of the customer's statement cycle on the Statement Cycles (AR202800) form. If the box contains Due Date, the system will use the due date; if it contains Document Date, the system will use the document date.
  • If the Age Credits check box is cleared, the system will use the end date of the Financial Period report parameter to determine the appropriate aging bucket.

See the following section for a description of each parameter on the Report Parameters tab of the report form. For more information about using other elements on the report form, see Reports.

Report-Specific Parameters

You use the following parameters to select the information to be displayed on the report:

  • Report Format: The format to be used for the report. Select one of the following options:
    • Detailed: To view outstanding documents for the selected period
    • Summary: To view outstanding balances for the selected period
  • Company/Branch: The company, branch, or company group for which you want to view information. By default, the current company or branch is selected. You can select another branch, company, or company group to which you have access or leave the box blank to view information about all companies in the tenant.

    This parameter is required if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form.

  • Financial Period: The financial period the system will use to calculate the aging categories for the documents.

    By default, the current financial period is used.

  • Project: The project whose documents will be included in the report. Either select a project from the list or leave the box blank to view information for all projects.
  • Project Manager: The employee who is responsible for the implementation of the project whose documents will be included in the report. Either select a project manager from the list or leave the box blank to view information for all project managers. You do not have to specify the parameter; if the box is left blank, the report shows the documents or balances associated with all the projects (including projects for which no project manager is specified).
  • Customer Class: The customer class for which you want to display data. Select a customer class from the list of customer classes, or leave the box blank to view information about all classes.
    The list of classes may be limited based on the roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. With the feature enabled, the Restrict Visibility To box appears on the General tab of the Customer Classes (AR201000) form. You can select a customer class if one of the following is true:
    • The Restrict Visibility To box is empty for the customer class—that is, the visibility of the customer class is not restricted.
    • A branch, company, or company group is specified in the Restrict Visibility To box for the customer class, and your user account is assigned to the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of Branches (CS102000) form for the branch, or the Company Details tab of the Companies (CS101500) form for the company or a company within the company group.
  • Customer: The customer whose data you want to display. Select a customer from the list of all but inactive customers, or leave the box blank to view information about all customers.
    The list of customers available for selection may be limited based on the role or roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. In this case, the Restrict Visibility To box appears on the Financial tab of the Customers (AR303000) form. With the feature enabled, a customer is available for selection if one of the following is true:
    • The Restrict Visibility To box is empty for the customer—that is, the customer’s visibility is not restricted.
    • A branch, company, or company group is specified in the Restrict Visibility To box for the customer, and your user account has the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the branch, or the Company Details tab of the Companies (CS101500) form for the company or a company within the company group.