[Decision Micro Classroom] Group consolidated report solution super dry goods sharing!
Time: 2023-04-12 
Views: 947
On March 29th, the 40th issue of [Decision Micro-Classroom] was broadcasted by Decision and SAP experts to explain the SAP Group Reporting solution in depth. The popularity of the live broadcast was overwhelming, with 5500+ people watching, bringing together SAP professionals from all over the world. Everyone lamented that they had benefited a lot and gained a lot. They not only thanked the teachers for their wonderful sharing, but also thanked Decision for providing such a high-quality pure dry goods sharing platform, which won constant praise from the audience.
Friends who missed this live broadcast can review the key contents of this live broadcast with us.
01 | s/4 HANA all-round perspective intelligent management
02 | s/4 HANA Group Reporting Group Report
03 | Merging key business schemes
04 | SAP S/4 HANA Group Merger Benefit
The above picture is an overall framework of group report, which is a module of SAP S/4HANA, and actually has a seamless and real-time relationship with FICO. Group reports are mainly divided into four core processes:
In some Fiori interfaces of S/4HANA above, we can see that the group report supports specifying the configuration of each consolidated entity, and the configuration is associated with time and version related attributes. You can also define the single company, legal person structure, management structure, incorporation time, divestiture time node and merger method covered by the merger scope.
The above figure is an important functional interface in the group report. If the accounting entity company covered in S/4HANA wants to publish and approve unified vouchers, the accounting vouchers of this entity company will be published in the consolidation module before clicking the time node after completion. This function solves the problems of inconsistent consolidated data and inconsistent consolidated results.
In the process of data collection, there are four methods built into the group report:
In the group report, SAP issued several pre-made data verification rules, and enterprises can also define their own data verification after the pre-made data verification rules take precedence. It can provide the function of penetrating and tracing for the data before merger, offset data and the results after merger.
Associated reconciliation is a built-in function in the system. The consolidated enterprise can select a single company, which will list our details, and the opposite details can be automatically matched. The matching results can show which detailed records have been matched, and the matching rules can also be defined by itself.
07. Currency conversion
Group report has an advantage in currency conversion: it can make all processes transparent. For example, during currency conversion, the system will tell you how much the functional currency is, which conversion exchange rate is used, how much the converted amount is, and how much the variance is. All the details of the detailed conversion of the variance account can be viewed, which is convenient for enterprises to check.
In the group report, the corporate structure and management structure can be merged at the same time, that is, matrix consolidation. In addition, it can support multiple sets of management structures, not only profit center structure, Segment, etc., but also many auxiliary fields. Generally speaking, as long as it is in the consolidated record, it can be issued as the future report of the enterprise.
During the consolidation process, all offsets in the related transaction report are presented in the form of entries. For example, the report will tell you what the trigger conditions are, and the trigger conditions at this time match the conditions in the rules. All offsets of enterprises are based on offset entries formed by rules. When the offset data results are different, enterprises can trace back to each offset entry to check the problems, which is convenient for users to check the results.
Within the consolidation range of the chart shown above, the consolidation ratio can be automatically calculated, which is the same as BPC. The enterprise maintains the direct shareholding ratio, and the system will automatically calculate a consolidation ratio within this consolidation range.
The system will trace the whole investment process in the form of activity events according to the first merger, increase, decrease and divestiture, including all equity changes will be managed based on this activity, and through the offset of this activity, we can also see the detailed investment offset process, which is convenient for enterprises to check.
For the user's final operation, you can see the data reporting status of each single company within the consolidation scope through the consolidation monitor, and this status can also be defined flexibly by the enterprise. Supervising the consolidation execution task is a standard task prefabricated by the system, and it can also be extended and defined flexibly. After executing the consolidation task, a report will be issued, and the system will form detailed offset entries.
There are three forms of reports in Group Reporting:
The master analysis report can expand the consolidation process, and whether it is the original voucher or the consolidated result, a penetrating jump can be made to the detailed voucher in the system. Vouchers can be divided into the following categories:
-Original vouchers in -ERP system
-Adjusted entries
-Offset entries
To make the data completely transparent, Group Reporting automates the whole merger and offset process, and preset group data analysis for enterprises to view the data.
In addition, the system also provides prefabricated consolidated papers, including consolidated assets and liabilities, consolidated profits, consolidated cash flows, consolidated changes in equity, etc. Some configurations can also be made in the system, such as the comparison difference between the previous period, which can be flexibly configured. This is a report prefabricated in the system and ready to use.
Many corporate customers will have many requirements for fixed-format annotation reports, which can be carried out in the following two ways:
-To present through Excel, you need to do CDS view and do special processing.
-Use SAP BI tools (SAC), such as: tax payable, details of all taxes, balance due, increase and decrease in the current period, ending balance and other group report formats. Presented through SAC, it is relatively faster to make a fixed format sample.
The starting point of SAP S/4HANA Group's consolidated products is to improve the efficiency of enterprises from accounting to report issuance, improve the ability of data penetration and traceability, support real-time consolidation of enterprise reports, and realize multi-dimensional consolidation at the same time. The most important feature is that Group Reporting is in SAP S/4HANA system, so the user experience has not changed much, and users do not need to do much training in use.
Enterprises are experiencing a great change that has never happened in a hundred years. Facing the complex internal and external environment, Decision has been taking SAP as the cornerstone for 17 years and is committed to helping more and more enterprises to improve the implementation quality of SAP. Through strong global delivery capabilities, Decision has helped enterprises successfully realize digital intelligence transformation, cultivate elite teams and build a digital core.
In the future, Decision will also bring more course sharing to SAP professionals. Pay attention to Decision WeChat official account, and get the latest news of Decision Micro-Classroom as soon as possible, and get more activity information!
Friends who missed this live broadcast can review the key contents of this live broadcast with us.
Guest introduction
Lecture summary
01 | s/4 HANA all-round perspective intelligent management
02 | s/4 HANA Group Reporting Group Report
03 | Merging key business schemes
04 | SAP S/4 HANA Group Merger Benefit
Practical information
01.Group Reporting Group Reporting Process
The above picture is an overall framework of group report, which is a module of SAP S/4HANA, and actually has a seamless and real-time relationship with FICO. Group reports are mainly divided into four core processes:
- Data collection: Real-time access to SAP S/4HANA data can be synchronized to the consolidation module in real time through a publishing mechanism for consolidation, thus promoting the overall consolidation efficiency and data processing efficiency of enterprises.
- Consolidation preparation: data verification, currency conversion, manual voucher bookkeeping, etc. are available, and the voucher-level reconciliation function ICMR is embedded, from balance penetration and traceability to detail equality, and matching rules can be defined in the system.
- Consolidation processing: various types of consolidation offsets are supported, and consolidation offsets are developed based on rules. In addition, matrix consolidation is supported, and the corporate structure and management structure can perform consolidation together to produce results.
- Consolidated report: Fiori analysis is embedded, and CDS view of group report can be directly accessed through Excel plug-in (analysis office) of SAP, and SAC can also directly link with group report to show some consolidated results.
02. Group Consolidation: Basic Data
In some Fiori interfaces of S/4HANA above, we can see that the group report supports specifying the configuration of each consolidated entity, and the configuration is associated with time and version related attributes. You can also define the single company, legal person structure, management structure, incorporation time, divestiture time node and merger method covered by the merger scope.
03. Group consolidation function
The above figure is an important functional interface in the group report. If the accounting entity company covered in S/4HANA wants to publish and approve unified vouchers, the accounting vouchers of this entity company will be published in the consolidation module before clicking the time node after completion. This function solves the problems of inconsistent consolidated data and inconsistent consolidated results.
04. Four ways of data collection
In the process of data collection, there are four methods built into the group report:
- Integration mode: The accounting of a single company does real-time consolidation in S/4HANA through publishing mechanism.
- API: Accounting data is directly sent to group consolidation through API.
- File upload: accounting data is uploaded directly by importing files and Excel format, without system docking, only template import and export.
- Manual data collection GRDC: Data can be submitted through data input, but GRDC is independent of Group Reporting tools and collected through SAAS cloud deployment.
05. Data verification
In the group report, SAP issued several pre-made data verification rules, and enterprises can also define their own data verification after the pre-made data verification rules take precedence. It can provide the function of penetrating and tracing for the data before merger, offset data and the results after merger.06. Associated Reconciliation
Associated reconciliation is a built-in function in the system. The consolidated enterprise can select a single company, which will list our details, and the opposite details can be automatically matched. The matching results can show which detailed records have been matched, and the matching rules can also be defined by itself.
07. Currency conversion
Group report has an advantage in currency conversion: it can make all processes transparent. For example, during currency conversion, the system will tell you how much the functional currency is, which conversion exchange rate is used, how much the converted amount is, and how much the variance is. All the details of the detailed conversion of the variance account can be viewed, which is convenient for enterprises to check.08. Matrix merging
In the group report, the corporate structure and management structure can be merged at the same time, that is, matrix consolidation. In addition, it can support multiple sets of management structures, not only profit center structure, Segment, etc., but also many auxiliary fields. Generally speaking, as long as it is in the consolidated record, it can be issued as the future report of the enterprise.
09. Offset Entry of Related Party Transaction Report
During the consolidation process, all offsets in the related transaction report are presented in the form of entries. For example, the report will tell you what the trigger conditions are, and the trigger conditions at this time match the conditions in the rules. All offsets of enterprises are based on offset entries formed by rules. When the offset data results are different, enterprises can trace back to each offset entry to check the problems, which is convenient for users to check the results.
10. Automatically calculate group sharing%
Within the consolidation range of the chart shown above, the consolidation ratio can be automatically calculated, which is the same as BPC. The enterprise maintains the direct shareholding ratio, and the system will automatically calculate a consolidation ratio within this consolidation range.
11. Activity-based investment consolidation
The system will trace the whole investment process in the form of activity events according to the first merger, increase, decrease and divestiture, including all equity changes will be managed based on this activity, and through the offset of this activity, we can also see the detailed investment offset process, which is convenient for enterprises to check.
12. Merge processing
For the user's final operation, you can see the data reporting status of each single company within the consolidation scope through the consolidation monitor, and this status can also be defined flexibly by the enterprise. Supervising the consolidation execution task is a standard task prefabricated by the system, and it can also be extended and defined flexibly. After executing the consolidation task, a report will be issued, and the system will form detailed offset entries.
13. Comprehensive report based on a single source of truth
There are three forms of reports in Group Reporting:
- SAP BI platform: make some formatted reports through sap bi tools.
- SAP report analysis: Group reports, including master analysis reports, can be directly accessed through Excel(Analysis Office), and master analysis reports based on rules can be displayed.
- Fixed format disclosure: Fiori way, a master analysis report or a rule-based master analysis report is prefabricated, multi-dimensional and penetrable in the system.
14. Analysis of consolidated results
The master analysis report can expand the consolidation process, and whether it is the original voucher or the consolidated result, a penetrating jump can be made to the detailed voucher in the system. Vouchers can be divided into the following categories:
-Original vouchers in -ERP system
-Adjusted entries
-Offset entries
To make the data completely transparent, Group Reporting automates the whole merger and offset process, and preset group data analysis for enterprises to view the data.
15. Consolidated report
In addition, the system also provides prefabricated consolidated papers, including consolidated assets and liabilities, consolidated profits, consolidated cash flows, consolidated changes in equity, etc. Some configurations can also be made in the system, such as the comparison difference between the previous period, which can be flexibly configured. This is a report prefabricated in the system and ready to use.
16. Disclosure of consolidated notes
Many corporate customers will have many requirements for fixed-format annotation reports, which can be carried out in the following two ways:
-To present through Excel, you need to do CDS view and do special processing.
-Use SAP BI tools (SAC), such as: tax payable, details of all taxes, balance due, increase and decrease in the current period, ending balance and other group report formats. Presented through SAC, it is relatively faster to make a fixed format sample.
17. Group merger-benefits
The starting point of SAP S/4HANA Group's consolidated products is to improve the efficiency of enterprises from accounting to report issuance, improve the ability of data penetration and traceability, support real-time consolidation of enterprise reports, and realize multi-dimensional consolidation at the same time. The most important feature is that Group Reporting is in SAP S/4HANA system, so the user experience has not changed much, and users do not need to do much training in use.
Enterprises are experiencing a great change that has never happened in a hundred years. Facing the complex internal and external environment, Decision has been taking SAP as the cornerstone for 17 years and is committed to helping more and more enterprises to improve the implementation quality of SAP. Through strong global delivery capabilities, Decision has helped enterprises successfully realize digital intelligence transformation, cultivate elite teams and build a digital core.
In the future, Decision will also bring more course sharing to SAP professionals. Pay attention to Decision WeChat official account, and get the latest news of Decision Micro-Classroom as soon as possible, and get more activity information!
【Service Guide】
For more information on SAP courses, project consultation and operation and maintenance, please call Decision's official consultation hotline: 400-600-8756
【About Decision】
Global professional consulting, technology and training service provider, SAP gold partner, SAP software partner, SAP implementation partner, SAP official authorized training center. Seventeen years of quality, trustworthy!
Share to:
