Related topics
In this program you work with the Group reporting function. The Group reporting functionality allows you to transfer/receive balances across companies and merge them. You also have the possibility to drill across from the Report display panel for the Online report in the Corporate company (also sometimes referred to as Reporting company) to the Originating company, as well as drill down within the company you are in.
This panel is reached from the Originating company, and you define which company is to be the Corporate company for this specific Originating company. You can merge companies with different system currencies, different account file structures and different accounting periods.
- Corporate company
- Enter the code for the Corporate company in which the Originating company is to be merged.
Company hierarchy maintenance, Account/Summary ID part relationship (GDMD50002)
In this program you work with the Group reporting function. The Group reporting functionality allows you to transfer/receive balances across companies and merge them. You also have the possibility to drill across from Report display panel for the Online report in the Corporate company (also sometimes referred to as Reporting company) to the Originating company, as well as drill down within the company you are in.
On this panel you define the relationship between the account structure in the Corporate company, and the account or summary id structure in the Originating company.
For account conversion you can either enter a fixed account, an account part, or a summary id part.
- Corporate company
- Displays the code for the Corporate company in which the Originating company is to be merged.
- To account part
- Displays the account parts set up for the Corporate company.
- To fixed account no
- Enter a fixed account number. Fixed account numbers belong to the Corporate company. When a balance from the Originating company is entered on a main account in the Corporate company which requires that other account parts are filled in, and these account parts are not used in the Originating company, these fixed account numbers will be inserted. Note: If you do not enter a fixed account for the associating Corporate company’s account part, the system will automatically insert blanks.
- From account part
- Enter the Originating company’s account part connected to the Corporate account part to which the balances are to be transferred. For example, if the main account part is account part 4 in the Originating company but account part 1 in the Corporate company, you enter 4 here. Leave the fields blank for the Corporate account parts that are not used in the Originating company, or for those that are not to be transferred.
- From sum id part
- Enter the Originating company summary id part against the Corporate account part to which the balances are to be transferred. Leave the fields blank for the Corporate account parts that are not used in the Originating company, or for those that are not to be transferred.
Company hierarchy maintenance, Currency translation settings (GDMD50003)
On this panel in the Group reporting routine, you define the exchange rate values to use for system currency translation on consolidation type 1, consolidation type 2 and budget. Which Consolidation type that will be used is defined on Balance type level in the System, Custom, or Distributed balance type tables. You can override these balance type definitions and enter an exception, e.g., on one account on Main account level in the Chart of accounts.
- Corporate company
- Displays the code for the Corporate company in which the Originating company is to be merged.
Exchange rates
Under this section you can choose to define exchange rate values for system currency translation.
- Consolidation type 1
- Enter the exchange rate period, level and time for consolidation type 1. This is the normal exchange rate which is preloaded in the system.
- Consolidation type 2
- Enter exchange rate period, level and time for consolidation type 2. This is the exception exchange rate.
- Budget
- Enter the exchange rate period, level and time for budgets.
Company hierarchy maintenance, Accounting period relationship (GDMD50004)
On this panel in the Group reporting routine you convert the accounting periods of the Originating company to the accounting periods of the Corporate company.
- Corporate company
- Displays the code for the Corporate company in which the Originating company is to be merged.
Originating company => Corporate company
- Copy period X to
- For each existing accounting period in the Originating company, you enter the accounting period number in the Corporate company into which the balances are to be transferred. For example, if the Originating company uses months as periods, but the Corporate company uses quarters, you would connect periods 1, 2 and 3 in the Originating company with period 1 in the Corporate company.
Company hierarchy maintenance, Budget number selection and relationship (GDMD50005)
On this panel in the Group reporting routine you decide which budgets in DC1 Financials to copy from the Originating company to the Corporate company.
- Corporate company
- Displays the code for the Corporate company in which the Originating company is to be merged.
Originating budget => Corporate budget
- Selection 1-15
- Enter the Originating company’s budget numbers to copy to the Corporate company’s budget numbers. You can complete any or all fields, and in any order, but you must enter a number in both fields for every selection. For example, Originating company’s budget number 1 can be copied to Corporate company’s budget number 2.
Company hierarchy maintenance, Balance type selection (GDMD50006)
On this panel in the Group reporting routine you select/deselect the balance types that are going to be updated in the Group reporting (Corporate) company. Only active balance types in the Originating company are displayed.
Note: You can only deselect a balance type if there are no balances in the company.
Selection fields
- Corporate company
- Displays the code for the Corporate company in which the Originating company is to be merged.
- Balance type
- This column lists all active balance types. Select a balance type and click OK to confirm your selection.
- Description
- This column lists a description of the related balance type.
- Selected
- Indicates for each balance type if it is selected.