The consolidation is carried out in the following steps:
Data imports: Data is imported from the pre systems. Various interfaces are available for import (e.g., Business Central, SQL, Excel, text, XML, web services).
Data plausibility check: Depending on the data from the source systems, different plausibility checks can be performed (e.g., comparing individual postings with the balance sheet).
Import accounting: As a prerequisite for the later consolidation steps, all imported data is saved in a separate table for the imported data.
Reconciliation of IC postings: In the next step, a data reconciliation can be performed between all IC postings from the different clients. If discrepancies are discovered during this phase, measures can either be taken within the system or the data in the original clients can be corrected and imported again. (For details, see Reconciliation of IC postings .)
First-level consolidation: Based on the consolidation settings, the data is transferred to the respective consolidation groups of the first consolidation level. The respective consolidation methods and shares are calculated, and the eliminations are posted. (For details, see "Elimination and Share Calculation ")
Consolidated postings: The consolidation postings table contains the postings for each consolidation group along with their detailed information. This table collects the data and also performs all transfers and subsequent postings.
Calculating multi-level consolidation: When calculating multi-level consolidation, the results of the affected consolidation groups (= source clients) from the previous consolidation levels are transferred to the consolidation of the subsequent levels. In addition, the data from the original source clients is transferred from the imported postings. (For details, see Elimination and Share Calculation .)
Currency translation: Originally, the data was converted according to the transaction or import rate. This step was important for intercompany reconciliation. During this phase of currency translation, the conversion is based on the consolidation rules. (For details, see Currency Translation .)
Manual and automatic postings: According to consolidation regulations, additional postings can be entered into the system. These postings can either be entered and posted manually or calculated automatically (e.g., deferred taxes, elimination of intercompany profits caused by inventory values).
Console analyses: As a result of the consolidation, the data can be displayed and exported in a variety of evaluations.