Skip to content
XtensionIT Docs

Multi Entity Management

Consolidation with reporting company

Version: April 2025 / 7.3.0

1. Overview

Working with multiple companies a natural requirement arises to get reporting on a consolidated level. Multi Entity Management enables you to build a structure within your group of companies and consolidate all the relevant ledgers in a reporting company. The consolidation are real-time, when a ledger entry is posted in a company connected to the Reporting Company, the ledger entry is replicated to the Reporting Company with Business Unit Code information from the connected company.

Based on data in the Reporting Company it is possible to use the Business Central filter funktionality in reports and pages to filter on the Business Unit Code. The reporting can be extended with Microsoft PowerBI and you will be able to created all the figures you could wish for in a modern and flexible way.

Below we have created a visualization to give you an idea of, how the setup could be like.

MEM overview

In the visualization the three light-blue companies A, B and … are being consolidated into the yellow Reporting Company R.

2 Reporting Company

2.1 General setup

A Reporting Company can be identified, when the field Reporting Company in the Replication List is marked.

Replication List- Reporting Company

A company can be set up as a reporting company in the General section at the Replication Card for the Reporting company.

Reporting Company - Replication Card

Activating the option Reporting Company will enable the Reporting Company functionality. When a ledger entry is posted in a Consolidating Company connected to the Reporting Company, the ledger entry is consolidated into the Reporting Company with the Business Unit Code from the connected company attached.

2.2 Parent tables

The different Consolidating Companies will continuous post the Ledger Enties to the Reporting Company. To work with the Ledger Enties in the Reporting Company, the Reporting Company need the Parent tables for the consolidated Ledger Entries.

The Reporting Company must subscribe on the Parents tables from one of the Publishing Companies, just like the Consolidating Companies do. Then the Parents tables will be aligned and you will be able to use List, Pages and Report in the Reporting Company with option in filtering on values like Business Unit Code etc.

[PICTURE]

The following settings must be taken into account:

Table ID: Specifies the Table-ID of the subscribing table to receive data from the data publisher.

Table Name: The field is opdatated automatically and contains the name of the table.

Data Publisher: Specify the Data Publisher to subscribe data from. When the data publisher has been assigned, the application checks whether data records already exist in the Subsctribing company for the selected table. If this is the case, some confirmation messages will appear with the following options:

Transfer records of table “ID” “Name” to company: “Company Name”

  • Answer “No” - No records are transferred, but new records will created in the reporting company.

  • Answer “Yes” - A new Confrimation Box will appear

    • There are records for table “ID” “Name” in company Reporting Company already. You can overwrite the existing data. If not, data will be added.

      Do you want to overwrite existing data?

      • Answer “Yes” - All existing data in the subscriber tabel will be deleted and all records from the Dats publisher will be transferred.

      • Answer “No” - Only records that donot exist in the subcribing tabel will be transferred from the Data Publisher..

Auto Insert: If you check this box, the data from the Publisher or Distributor will be permanently sourced, i.e. new data records of this table are automatically written to the Subscriber Company. By subsequently removing and re-setting the check mark, the transmission can be forced repeatedly.

1.2 Define

In the Subscribe section at the Replication Card for a Consolidating Company, the same tables are assigned as in the dependent or operative companies whose transaction data is to be merged into this reporting company.

1.2 Setup a Consolidating Company

A Consolidating Company can be identified when a Business Unit Code is present in the Repliacation List is marked.

Replication List - Consolidate

8.2 Consolidate Data

To merge transaction data into reporting companies, the relevant dependent or operative companies must be marked accordingly. You set up the dependent or operative companies using the navigation area Departments, ocn5Template, Template Management, Template Setup Overview:

The operative company whose transaction data is to be consolidated into a reporting company must be clicked. Then click on the Edit Template Setup icon, in the Task group of the menu bar.

The window Template Setup willl open:

When setting up the dependent or operative company, the following setting must be taken into account:

Field - Description

Consolidate: Check this box if you want to merge the transaction data of this company into a reporting company.

Choose the tables whose transaction data should be transferred, i.e. merged, and the reporting company that should receive this data from the Info register Consolidate in.

The following settings must be taken into account:

Field - Description

Table ID: This is the object number of the table. The selection of the ta- bles is available via the lookup button [F4].

Table Name: The field is filled automatically and contains the name of the table.

Template Company Name: At this point, the reporting company is selected to receive the data. The Lookup button displays all possible reporting companies.

8.3 Evaluate Data

Merged entries, such as G/L, customer, vendor or item entries can be evaluated using the filter Business Unit Filter:

The field Business Unit Code is available in the G/L, customer, vendor and item entries in order to be able to differentiate the respective entries according to their company origin:

8.3.1 Evaluate in Account Scheme

For cross-company analyzes in the chart of accounts, the items can be viewed individually in the column layout using the Add up Business Unit field:

Hereby, the G/L entries pooled in the reporting company can be evaluated per company in the chart of ac- counts matrix:

8.3.2 Evaluations in Reports

9.0 Data to consolidate

The following ledger entries can be transferred to a reporting company

  • Ledger

    • G/L Entry

    • Cust. Ledger Entry

      • Detailed Cust. Ledg. Entry

    • Value Entry

      • Detailed Vendor Ledg. Entry

    • FA Ledger Entry

    • Item Ledger Entry

      • Value Entry

  • Purchase documents

    • Purchase Header

      • Purchase Line

    • Purch. Rcpt. Header

      • Purch. Rcpt. Line

    • Purch. Inv. Header

      • Purch. Inv. Line

    • Purch. Cr. Memo Hdr.

      • Purch. Cr. Memo Line

    • Purchase Header Archive

      • Purchase Line Archive

  • Sales documents

    • Sales Header

      • Sales Line

    • Sales Shipment Header

      • Sales Shipment Line

    • Sales Invoice Header

      • Sales Invoice Line

    • Sales Cr.Memo Header

      • Sales Cr.Memo Line

    • Sales Header Archive

      • Sales Line Archive

  • Return documents

    • Return Receipt Header

      • Return Receipt Line

    • Return Shipment Header

      • Return Shipment Line

  • Service documents

    • Service Header
      • Service Line