Drilldown Analyzes

The drilldown analysis means that you use the list box to drill down into the structure by the following choices:
  • Account
  • Company
  • Journal Type
  • Automatic Journal Type
  • Journal Number
  • Counter Company
  • Original Company.
  • Counter Dimension
  • Extended Dimension 1-4

Original Company is useful to drill on if there are intercompany transactions or shares in subsidiaries.

Note: You must select contribution version ALL to display all information for a group. Also, note that acquisition eliminations and elimination of intercompany balances and internal profit are usually displayed by individual companies, not in separate columns. However, there is an option to display these eliminations in separate columns. The contribution version determines which eliminations are displayed.

Column Contents

You can choose to present the trial balance in two ways: with companies in the columns or with combinations of closing version/contribution version in the columns. The second alternative gives you the opportunity to define a maximum of five combinations. It is intended primarily for use in a drilldown analysis.

Two Types of Reports

If you have chosen to view companies in the columns, you can choose to generate two different reports:

  • Companies across - shows each of the companies in the group in its own column, group journals in a column and a total column.
  • Totals across - shows the parent company in a column, the total of all subsidiaries in a column, the total of the parent company and all subsidiaries in a column, a column with group journals and finally a column with total values.

Group and Company

Consolidation type and group are always selected initially. If you have selected closing version/contribution version in the columns, you may analyze a single company by ticking the Company check box and selecting a company code.

Form or Account

You can choose to have the trial balance show either a form or an account. If you choose several forms, these will be shown one after the other. If you choose to show an account, another layout appears that requires that you have selected a group and columns with combinations of closing versions/contribution versions. The report will then show amounts in the account with companies on the rows and combinations of closing versions/contribution versions in the columns.

Report Options

By selecting the Details button, you get access to further report options. You may select specific codes for extended dimensions and select to display rows and/or companies without values.

  • Show Consolidated Group displays an extra column with the consolidated group figures.
  • Show Eliminations Separately means that there will be three more columns displayed, with acquisition eliminations and elimination of intercompany balances and internal profit.
  • Alternative Layout of Reported Values gives you the possibility to see journal types on groups below as reported values. The journal types must be included in the closing version for reported values and REPO selected as the common closing version.

It is not possible to drill on contribution calculations. This is because contribution calculations are performed on the lowest level only. For more information, see Contribution calculations.