Multi Entity Management

Reporting company

How to consolidate entries from companies into a reporting company.

Version: 2025.12 / 7.12.8

---

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 ledger entries in a Reporting Company. The consolidation are real-time, when a ledger entry is posted in a company consolidating to the Reporting Company, the ledger entry is replicated to the Reporting Company with Business Unit Code information identifying the Consolidating Company.

Based on data in the Reporting Company it is possible to work with the Business Central filter functionality in reports and pages aand filtering 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 an idea of, how the setup could be like.

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

2 Reporting Company

2.1 General setup

In the Replication List a Reporting Company can be identified, by a TRUE value in the field Reporting Company.

To setup a company as a reporting company, find the General section at the 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 identifying the Consolidating Company added to the ledger entry.

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 must subscribe to the Parent tables for the consolidated Ledger Entries.

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

The following settings must be taken into account:

Table ID and Name Choose the table that the Subscriber (Reporting Company) will retrieve data from, with selecting the Table-ID.

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

• Answer No - No records are transferred, but new records in the Publisher Company will also be created in the Reporting Company.

• Answer Yes - A new Confrimation Box will appear

Do you want to overwrite existing data?

• Answer “Yes” - All existing data in the Subscriber tabel will be deleted and all records from the Data Publisher will be transferred.

• Answer “No” - Only records that do not 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.

3 Consolidating Company

3.1 General setup

A Consolidating Company can be identified when a Business Unit Code is present in the Replication List. The consolidation is active when the field Consolidate is marked.

To consolidate ledger entries to a Reporting Company, the Consolidating Companies must be marked accordingly. To identify the ledger entries origin each entry is added a Business Unit Code related to the original company.

The Business Unit Code is defined at the Replication Card for the consolidation company.

The next step is to define which field in the ledger entry tables, the Business Unit Code is stored. Use the function Business Unit Code fields.

Use + New to add a table for consolidation and define the field holding the Business Unit Code.

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:

9.0 Data to consolidate

The following ledger entries can be transferred to a reporting company

• Ledger

  • 17 : G/L Entry (Business Unit Code field: 45)

  • 21 : Cust. Ledger Entry (Business Unit Code field: 5397812)

    • 379 : Detailed Cust. Ledg. Entry (Business Unit Code field: 5397812)

  • 25 : Value Entry (Business Unit Code field: 5397812)

    • 380 : Detailed Vendor Ledg. Entry (Business Unit Code field: 5397812)

  • 5601 : FA Ledger Entry (Business Unit Code field: 5397812)

  • 32 : Item Ledger Entry (Business Unit Code field: 5397812)

    • 5802 : Value Entry (Business Unit Code field: 5397812)

The following documents can be transferred to a reporting company

• 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