Financial data reconciliation of universal journal for S/4HANA migration






The IT industry keeps changing all the time and companies can't afford to fall behind. Searching and using state-of-the art solutions is one of the factors that help companies achieve their success. SAP S/4 HANA is one of theese solutions, definitely. There are many benefits of upgrading an old SAP system to the latest S/4 HANA environment. Just like in case of other upgrade projects, the process requires a lot of time and effort spent on the analysis as well as the actual realization. At the end, there is no place for errors, going back might be too expensive or simply impossible. Therefore, reconciliation tools have become essential and this is why Int4 provides a solution that can facilitate accounting data reconciliation process and may help eliminate the risk of the data inconsistency. The Universal Journal is in fact a single large table that consolidates all transactional information that was previously stored in several tables. It is called ACDOCA. The complex migration process that populates thisĀ  table, consists of numerous steps that must be performed in a particular sequence. SAP provides detailed instructions of the complete migration procedure. During the process, various steps produce reports that can be validated and can used as a basis for early error detection purposes. When the actual migration is complete, reconciliations can be started with few simple standard tools accessible from the IMG tree. Extended and customer-specific reconciliations however, require an extra tool that can be easily adjusted to the requirements of the company's accounting and auditing teams. Int4 designed a group of reports that perfectly fit into this scenario.

How does it work:

Our tools read ACDOCA and compare its content with the data stored in the pre-migration tables e.g. FAGLFLEXT_BCK or V_FAGLFLEXA_ORI. Selection, dimensions as well as the comparison levels can be dynamically adjusted to the particular client's requirements. This solution can be used until there is a memory footprint reduction step performed on the migrated system. In other words, until the old pre-migration data is being kept and available for consumption. Usually it happens once all the reconciliation tasks are signed off, all auditors are satisfied with the results and of course the system is considered to be fully upgraded. At that point, there is no need to keep the old data in the system. We understand that business has to reconcile the data on several different levels depending on the internal and external financial and statutory requirements. Various groups of accountants may be interested in different sets of data being compared and then displayed in the aggregated form and across all accounting dimensions or customized currencies. There are standard dimensions like G/L account, Counterparty or Profit Center as well as the ones customized as a coding block extension of the general ledger (COBL). Both the types are fully supported. The same applies to the authorization concept, different groups of users have different access levels, therefore reconciliation has to be always done within assigned authorization profiles.

Benefits of INT4 Universal Journal Migration Reconciliation Tools:

Simplification ? integration is no more a black hole
DYNAMIC DIMENTION COMPARISON - fulfills reporting requirements of different groups of accountants and auditors. Including, excluding dimensions like e.g. Counterparty, Profit Center etc. is easy and does not require any extra effort.
DRILL DOWN CAPABILITY WITH COMPARISON ON THE LINE ITEM LEVEL - allows deeper level of on-demand analysis. User can easily move from the highest aggregation level down to the line item view. Top level balance differences can be narrowed down to the particular splitting item that contains inconsistencies.
Automation ? execution of hundreds of test cases is a matter of minutes not days
INCLUDED IN DRY RUN AND DRESS REHEARSAL PHASES - Finding all the issues as early as possible saves time and allows companies to perform the data cleansing process and rectify potential more complex problems. Therefore, as a good practice, Int4 strongly recommends including reconciliation tasks in the list of "dry run" and "dress rehearsal" activities.
SAP testing - Minimal effort of creating test cases
MULTIPLE CURRENCIES SUPPORT - depends on the particular system customizing. All amounts and their corresponding currencies are recognized dynamically on the basis of the FINSC_LD_CMP customizing.


ul. Bednarska 1
60-571 Poznan, Poland



Write to us