Use Reconciliation Dashboard and Reports

This topic outlines the process of using the reconciliation dashboard and accessing the reconciliation reports within the SourceConnect Management Console. The dashboard and reports analyze data fetched from the staging area.

Reconciliation Dashboard

1. To access the reconciliation dashboard, select the third icon in the navigation pane and then select Dashboards. If there are multiple staging areas, select the appropriate one from the drop-down menu. If there is only one staging area, the application will use it by default.

   

   

   The dashboard includes five types of charts:

   • Processing Status - Transaction count categorized by each processing status level.
   • Source System Transaction Replication Status - AIF status of all transactions sent to CFIN, organized by source system.
   • Document Count Variance - Source System - Document count differences between the ISW Staging database (StageONE) and CFIN, organized by source system.
   • Replication Aging - Duration (in days) a transaction remains stuck in the replication process to CFIN.
   • Exception Summary - Overview of documents that cannot be posted into SAP S/4HANA due to exceptions.
2. To apply filters:
   • Individual charts - Select the filter icon directly in the individual cards.

     

   • Global filters - Select the gear icon > Filters to apply filters across all charts.

     

   Available filters include:

   • Source System
   • Company Code
   • Source Doc. Posted Date - Start
   • Source Doc. Posted Date - End
   • Source Fiscal Year
   • Source Fiscal Period
   • Age Range (applicable only for the Replication Aging chart)
3. Click Apply or save filters for later use in the Global Filters panel.

   

4. To view the list of jobs in the data source associated with the reconciliation, select the gear icon > Recon Job Summary.

   

5. To view a detailed version of any chart, click the expand icon on that card. Filters can also be applied from the expanded view.

   

6. To customize the pivot table display that provides data based on the chart, click the Field Chooser icon. Select the necessary fields, drag and drop columns into the Row Fields and Columns Fields sections to create your preferred view, and click OK.

   

Reconciliation Reports

1. To access the reconciliation reports, select the icon in the navigation pane and then select Reports. This section displays ten transaction reconciliation reports.

   Note: If you have an existing master data source in the application, the Master Data tab shows master data reconciliation reports. For more information, see SAP Central Finance Master Data Replication by insightsoftware Installer and Management Console Guide.

   

2. Select the report you want to view.
3. If there are multiple staging areas, select the appropriate one from the drop-down menu. If there is only one staging area, the application will use it by default.

   

4. Use the filter icon on the top-right corner of the screen to apply desired filters and click Apply. Available filters include:
   • Source System
   • Company Code
   • Source Doc. Posted Date - Start
   • Source Doc. Posted Date - End
   • Source Fiscal Year
   • Source Fiscal Period
   • Age Range

   

5. To customize the display, click the Field Chooser icon. Select the required fields, then drag and drop columns into the Row Fields and Columns Fields sections to create your desired view.

   

6. Click OK to review the updated report.
7. Click Save to save the report.

   

8. To copy an existing report, select the ellipses on the report card and select Copy. Enter a name and description for the new report and select Create.

   

   

9. To delete a copied report, select the ellipses on the report card and select Delete. Select Delete in the subsequent confirmation prompt.