Best Practices for Using Reconciliation Reports

This chapter contains the best practices that should be followed while using the Reconciliation reports.

Access the Reconciliation reports by using one of the following two methods:

• Using Query Browser.
• Using individual Fiori tiles under insightsoftware Transaction Reconciliation Reports section as shown in the following image.
  

You can optimize the usage of the Reconciliation reports by accessing them in the following order:

1. Access the Level-1 Reconciliation report to: 
   • Compare document counts.
   • Identify if a document was left out while loading to the staging database.
   • Compare the data between the Source_Doc_Info and Magnitude_Stg_One data sets. Perform the following steps and refer to the screenshot that follows the steps:
     1. Check the count at the source system by dragging an attribute from the left pane.
     2. Add other attributes such as Source: Company and Source: Document Batch to compare the count variance.
     3. If required, add Source: Document Number to check whether the document has moved to the next stage. The Document Count, Amount in Local currency, and Units (Material Quantity) are displayed.
     
     Output:
     
2. Access the Level-5 Summary Reconciliation report to:
   • Identify the number of documents that are successfully posted to SAP S/4HANA.
   • Find the currency value of the documents that are reconciled.
   • Identify the document count level variance between the source and target.
   • Identify that any variance in the document count between the source and staging table indicates that either the document failed in AIF or faced an exception error while loading into the staging tables.

   Use the Level-5 Detail Reconciliation report in the following ways:

   • With key attributes, such as GL Account, and Profit Center to reconcile the amounts of these attributes.
   • Enter additional attributes, such as Company Code, to identify the company which has the documents having discrepancies. Refer to the following images.

   

   Output - Summary

   

   Output - Detail

   

   Access the GL Balance Report for comparing GL Account balances in Group, Company, and Transaction Currency Amounts by Fiscal Year, Fiscal Period, Company Code, GL Account, and Currencies between the insightsoftware Stage 1 and insightsoftware Stage 5 tables.

3. Access the Exception report to:
• Identify any error during data replication that is causing data variances in the Level-1 and Level-5 reports explained in the Steps 1 and 2.
• Identify the documents that failed during insightsoftware validation between Stage-1 and SLT due to validations such as missinh mandatory fields, document imbalance, and so on.
4. Access the Level-4 Reconciliation reports to:
   • Identify the documents that failed in the AIF layer for certain source systems and companies.
   • View measures such as the document count in SLT, document count for the documents posted successfully in SAP S/4HANA, and variance between SLT and SAP S/4HANA.
     1. Enter the attributes such as Logical System, Company Code, and Posting Date.
     2. To go to a missing document, enter “SLT: Unique ID” and “SLT: Reference Document Number”.
        

        Output:

        
5. Access the Level-3 Summary Reconciliation report to:
   • Identify the number of documents that are successfully posted to SLT.
   • Find the currency value of the documents that are reconciled.

   Note: For the Level-3 Reconciliation reports, any variance in document count between the source and staging tables is available as a part of the Exceptions Report.

   Use the Level-3 Detail Reconciliation report in the following ways:

   • With key attributes such as the GL Account, and Profit Center to reconcile amounts of these attributes.
   • Enter additional attributes such as the Company Code to identify the company that has documents having discrepancies. Refer to the following images.
   

   Output:

   

   Summary Level-3

   

   Output:

   
6. Access the Level-2 Summary Reconciliation report to:
   • Identify the number of documents that are successfully posted to the SLT tables in the staging database.
   • Find the currency value of the documents that are reconciled.
   • Identify the document count level variance between the source and target.

   Use the Level-2 Detail reconciliation report in the following ways:

   • With key attributes such as GL Account, and Profit Center to reconcile amounts of these attributes.
   • Enter the additional attributes such as the Company Code to identify the company that has documents having discrepancies. Refer to the following images.
     

     Output:

     
   Summary level:
   

   Output:

   
7. Access the Reconciliation Dashboard for a summary view of unreconciled documents by Processing Status, Source System, Company Code, Fiscal Year, and Fiscal Period attributes.