BFS_AR_AGING BI Report

Purpose: Use this document as a resource for running the BFS_AR_AGING BI Report.

Audience: Accounts Receivable staff.

You must have at least one of these local college managed security roles:

  • ZD_DS_QUERY_VIEWER

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

BFS_AR_AGING is a Business Intelligence (BI) report that presents PeopleSoft Receivables aging data in a user-friendly format, enabling users to effectively analyze accounts receivable balances, monitor outstanding receivables, and support informed decision-making. In addition to the standard AR Aging by Detail report, BFS_AR_AGING enhances reporting capabilities by incorporating chartstring information for each receivable item. This added level of detail allows users to reconcile aging balances by chartstring directly within the report, eliminating the need to run and consolidate multiple reports or queries, thereby improving efficiency and streamlining reconciliation activities.

Navigation: Menu > Reporting Tools > BI Publisher > BIP Query Report Scheduler

  1. The Query Report Scheduler run control ID search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value button to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value button to create a new Run Control ID and select the Add button. 
    • NOTE: Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA020_BFS_AR_AGING (College, Process).

It is recommended to use the report name as the Run Control.

  1. The Query Report Scheduler page displays.
  2. Within the Report Definition section:
    1. Select Connected Query from the Date Source Type drop-down field.
    2. Enter or search for BFS_AR_AGING in the Report Name field.
    3. Select the search icon in the Template ID field
      1. The CQFS_AR_ITEM_AGE_CHRTSTG_P prompt window displays.
        1. Enter or search for the Unit.
        2. Enter or search for the As of Date.
        3. Select the OK button.
Query Report Scheduler with the Date Source Type having Connected Query in the field. The Report Name field has the BFS_AR_AGING query populated. In the foreground, the CQDS_AR_ITEM_AGE_CHRTSTG_P prompt window.
  1. The Prompt for Query CQFS_AR_ITEM_AGE_CHRTSTG_1 window displays.
    1. Enter or search for the As Of Date.
    2. Select the OK button.
Query Report Scheduler page in the background with the CHRTSTG_1 prompt window in the foreground. The As Of Date field and OK button are highlighted.
  1. The Prompt for Query CQFS_AR_ITEM_AGE_CHRTSTG_2 window displays.
    1. Enter or search for the As Of Date.
    2. Select the OK button.
Query Report Scheduler page in the background with the CHRTSTG_2 prompt window in the foreground. The As Of Date field and OK button are highlighted.
  1. The Query Report Scheduler Template ID search results display. Select the BFS_AR_AGING_1 hyperlink and the Query Report Scheduler page displays.
  2. Leave the Template As of Date blank.
  3. Select the Run button. Please refer to the Process Schedule Request steps for further instructions.
Query Report Scheduler page will all appropriate fields populated and the Run button is highlighted.
  1. The Excel report is composed of four tabs:
    1. Introduction: Explains the source of the data on each of the tabs.
BFS_AR_AGING Excel report on the Introduction tab which is highlighted.
  1. Receivables Aging: The data shown on this tab should be the same as that included in the AR30003 Receivables Aging report when run for the same Business Unit and As of Date.
BFS_AR_AGING Excel report on the Receivables Aging tab which is highlighted.
  1. Aging Accts Chartstring: This account and chartstring detail for the transactions included in the “Receivables Aging” tab.
BFS_AR_AGING Excel report on the Aging Accts Chartstring tab which is highlighted.
  1. Account Summary: Summarized account and amount data from the “Aging Accts Chartstring” tab.
BFS_AR_AGING Excel report on the Account Summary tab which is highlighted.
  1. Process complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.