1. Accounting Foundation Cloud Service Core Functions
  2. Dashboards and Reports
  3. Overview of Balance Reconciliation Reports and Dashboards
  4. Accessing the Standard Reports and Dashboards

18.1.1 Accessing the Standard Reports and Dashboards

The Reconciliation Framework Analytics Dashboard page contain the following tabs:

  • Home
  • Threshold Breach
  • 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 dashboard 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.
  • Legal Entity: Select the Legal Entity.

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

The 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.

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.