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 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

The starting conditions listed in Enabling M3 Group Consolidation must be met.

Follow These Steps

  1. Start 'Settings – Transfer of General Ledger' (GMS015) or 'Settings – Transfer of Budget' (GMS020).

  2. On the E panel, enter or select values based on the Parameters to Set table. Press Enter.

Parameters to Set

Program ID/Panel Field The field indicates …
(GMS015/E), (GMS020/E) Transfer level … 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 accounting dimension in the subsidiary's transactions that will show 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

... whether the subsidiary's chart of accounts is to be converted to the parent company's chart of accounts. (Mandatory)

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 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 exchange rate types to apply for income statement and balance sheet transactions.

For example, the average rate can be used for the income statement and the rate as of closing date for the balance accounts.

(GMS015/E), (GMS020/E) Account for differences

... 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).

Related topics