02 Summary AR Aging Report

This report can be run from within the chained report, 01 AR Aging Report - Chained Report, or independently to show AR Aging Information listed by AR Company and grouped by Branch. This topic assumes you are running the report independently. If you would rather run the chained report, please click on the link above.

Executable Formats

This report can be exported in the following formats:

  • Excel
  • PDF (Portable Document Format)
  • RTF (Rich Text Format)
  • CSV (Comma Separated Values)

Accessing the Report

To access the 02 Summary AR Aging Report:

  1. From the Navigator, select Reporting.
  2. From the fly-out menu, select Reporting & Analytics.
  3. From Reporting & Analytics page, select System Reports in the Folder/Report navigator.
  4. In the System Reports folder, select the Billing folder.
  5. In the Billing folder, select the AR Aging Report - Chained Report folder.
  6. In the AR Aging Report - Chained Report folder, single-click on 02 Summary AR Aging Report and click on the Export Report icon to select the format. Alternatively, you can right-click on 02 Summary AR Aging Report and select Export As > and then the format.

Filters

This report initially displays one filter. Once the one filter is selected, the next four filters display:

  • Aging As Of Date: This is the date from which the report will age outstanding invoices. You can use the date icon or the function icon to select the date.
  • Corporation: While the system allows you to change the Condition and select multiple Corporations, the report is designed to run with only one corporation selected. Therefore, you should leave the Condition as "Equal To" and set the Value to the desired Corporation.
  • AR Company Branch: AR Branch associated with the invoices you want to age.
  • AR Company: Allows you to select a specific company, if needed.
  • Invoice Number: Allows you to select a specific invoice, if needed.

The following conditions are available:

  • Equal To (Default for Corporation, AR Company and Invoice Number): Data must be equal to the Value. There is only 1 Value option.
  • Not Equal To: Data must not be equal to the Value. There is only 1 Value option.
  • Less Than: Data must be before the Value alphabetically or by date. There is only 1 Value option.
  • Less Than or Equal To: Data must be before or equal to the Value alphabetically or by date. There is only 1 Value option.
  • Greater Than: Data must be later than the Value alphabetically or by date. There is only 1 Value option.
  • Greater Than or Equal To: Data must be later or equal to the Value alphabetically or by date. There is only 1 Value option.
  • Starts With: Data must start with the Value. There is only 1 Value option.
  • Not Starts With: Data must not start with the Value. There is only 1 Value option.
  • Ends With: Data must end with the Value. There is only 1 Value option.
  • Does Not End With: Data must not end with the Value. There is only 1 Value option.
  • Contains: Data must contain the Value. There is only 1 Value option.
  • Does not Contain: Data must not contain the Value. There is only 1 Value option.
  • Is Between: Data/Date must be between the two selected Values alphabetically, numerically or date-wise (inclusive). There are two Value options.
  • Is Not Between: Data/Date must not be between the two selected Values alphabetically, numerically or date-wise (inclusive). There are two Value options.
  • Is One Of (Default for AR Company Branch): Data must match one of the selected Values. There are multiple Value options.
  • Is Not One of: Data must not match any of the selected Values. There are multiple Value options.

You have the following Value options:

IMPORTANT! For performance purposes the following two items should be noted when using the Values droplist. First, in order to enhance performance, once a value is selected, the droplist only displays those items alphabetically/numerically AFTER the selected item. To see all items again, delete the value (select it and press Delete on your keyboard) and then use the droplist. All items will display. Second, in order to enhance performance, the droplist only displays a set number of records. If the list of possible values is longer than the displayed list, select the name at the bottom of the list as the value. When you next click the droplist, the rest of the items display.

  • Single Value: To select a single value, you can use the drop-list.

  • Double Values: To select two values, click the drop-list on each value.

  • Multiple Values: To select multiple values, click the drop-list on the top field to select a Value to add to the list. To see the items on the list, click the lower drop-list. To remove an item from the list, click the red X to the right of the item.

Report Actions

The 02 Summary AR Aging Report displays AR Aging Information listed by AR Company and grouped by Branch. For each AR Company, the report lists Billing Profile, AP Contact, Outstanding Balance and Aging Days. Totals are given by AR Company Branch and then grand totals are given at the end of the report.