1. Accounting Foundation Cloud Service Core Functions
  2. Dashboards and Reports
  3. Accessing the Standard Reports and Dashboards

18.2 Accessing the Standard Reports and Dashboards

To access standard dashboards and reports, from the Left Hand Side menu on the Home page of AFCS, click Dashboards. You will see basic summary reports. On the page header, click the Dashboards menu to view the list of all available seeded dashboards.

Dimension Instrument Contract has been added to the BCE Results subject area. In addition, the Dimension Account (String Custom Attribute) will be mapped to the Instrument Code in the Dimension Instrument Code entity, where the Instrument Code is the business key of the entity. For more details, reach out to support team. Click Reporting Metadata to download the 23D reporting metadata sheet.

Note:

  • Users with only AFCS-BI groups will be redirected automatically to the Analytics home page post-login.
  • Users mapped to both AFCS-BI and AFCS-DV groups will have the option to select between the Dashboard and Data Visualization pages.

Following are the seeded dashboards:

  • Balance Computation Engine
  • Balance Computation Results
  • Data Quality Results
  • Reconciliation Framework Analytics
  • Accounting Journals

The Reconciliation Framework Analytics Dashboard page contain the following tabs:

  • Home
  • Threshold Breach
  • Reconciliation Execution Audit Trail
  • Map Filter Report

Note:

Reconciliation difference drill down report is deprecated from 23.4.1 version onwards.

Each seeded dashboard has options at the top of the page, which you must select for the reports you wish to see. The Home, and Threshold Breach dashboards consist of the following options:

  • As of Date: Select the As of date and click the calendar icon.
  • Execution ID: All successful Run executions with status marked Complete in the Run Execution Summary window are populated here. Select the appropriate Run Execution ID from the drop-down menu.

Select the options and click Apply. To refresh the data, click Reset.

The Reconciliation Execution Audit Trail dashboard consists of the following options:

  • User ID: Data is displayed based on the User ID selected from the drop-down list.
  • Information Type: Available options are Null, Error, or Info.
  • Execution Date: Select the date on which the Run is executed.

The Map Filter Report Dashboard consists of the following options:

  • Execution ID: All successful Run executions with the status marked as Complete in the Run Execution Summary window are populated here. Select the appropriate Run Execution ID from the drop-down list.
  • GL Map ID: The General Ledger Map identification numbers are populated here. Select the appropriate GL Map ID from the drop-down list.
  • Map Version Number: The map version numbers are populated here. Select the appropriate Map Version Number from the drop-down list.

A few reports also have filters at each reporting level which are detailed in the section 'Report Descriptions'. Select the appropriate report filters so that data is displayed accordingly. For each report within a dashboard, you can also perform these tasks:

  • Refresh: Use this to update the values displayed in the report.
  • Print: Use this to print a particular report.
  • Export: Use this to export data into multiple formats such as PDF, Microsoft Excel, Microsoft PowerPoint, and so on.
  • Return: To navigate back to the previous window.
  • Create Bookmark Link: To share or save a browsed page. Sort icons also appear on each tabular report to sort the data in ascending or descending order. A few reports also consist of a drill-through capability wherein you can navigate to the most granular level of data.