Configure Transfer of Consolidation Transactions

This document explains how to determine how the subsidiary's consolidation transactions are to be processed in M3 Group Consolidation.

Two different programs are used for configuration, one for general ledger transactions and one for budget transactions. Since the setup is almost identical, they are both described in this instruction.

Outcome

The accounting dimensions to include in consolidation transactions are selected, as well as the accounting dimension in which the subsidiary ID is displayed.
Conversion of the subsidiary's chart of accounts is activated, if applicable.
Exchange rates and an account for exchange rate variances due to currency conversion are selected.

The configuration is applied when the subsidiary creates a consolidation proposal in 'Consolidation Proposal. Create/Transfer' (GMS200).

The settings are stored in the CSYTAB table.

Before you start

You must meet the starting conditions listed in Enabling M3 Group Consolidation.

Follow these steps

Start 'Settings – Transfer of General Ledger' (GMS015) or 'Settings – Transfer of Budget' (GMS020).
On the E panel, specify or select values based on the Parameters to Set table. Press Enter.

Parameters to set


Program ID/Panel	Field	Field description
(GMS015/E), (GMS020/E)	Transfer level	The field indicates whether the accounting dimensions displayed on the panel are to be included when creating a consolidation proposal.
(GMS015/E), (GMS020/E)	Subsidiary in accounting dimension	The field indicates the accounting dimension in the subsidiary's transactions that shows the subsidiary ID once they are transferred to the parent company. Accounting dimension 7 is often selected for this purpose.
(GMS015/E), (GMS020/E)	Conversion of chart of accounts	The field indicates whether the subsidiary's chart of accounts is to be converted to the parent company's chart of accounts. If you select this check box, you must map the subsidiary's chart of accounts to the parent company's in 'Account Conversion. Open Table' (GMS100).
(GMS015/E)	Exchange rate type – budget	The field indicates the exchange rate type to apply for budget transactions. This and the exchange rate type below are only needed if the subsidiary wants to convert its transactions to the parent company's currency.
(GMS020/E)	Rate type for statement of income, Rate type for balance sheet	The field indicates the exchange rate types to apply for income statement and balance sheet transactions. For example, the average rate is used for the income statement and the rate as of closing date for the balance accounts.
(GMS015/E), (GMS020/E)	Account for differences	The field indicates the account to which any exchange rate differences are posted due to having different rates for income statement and balance sheet. Differences can occur when converting foreign currencies to the consolidation currency, if the subsidiary is responsible for the conversion. If the consolidation currency is the local currency of the subsidiary, this account offsets the transactions that update the parent company's general ledger in 'Consolidation Proposal. Update' (GMS320).