Generate a Drilldown Report

You can also generate a trial balance with drilldown report.

Procedure

  1. On the Group menu, click Reports/Trial Balance with Drilldown. The Reports - Trial Balance with Drilldown window opens.
  2. Select Drilldown. This report type cannot be combined with the option Show Eliminations Separately or the option Alternative Layout for Reported Values.
  3. Select the relevant column contents option:
    • Companies. If you select this option, also select Companies Across if you want to display all companies included in the group as separate columns as well as a total column or Totals Across to display the parent in one column, the total of all subsidiaries in one column, the total of the parent company and all subsidiaries in one column, the group journals in one column and finally a grand total column.
    • Closing Version/Contribution Version. If you select this option you should enter the details of which closing versions and contribution versions to display in each column. You can define five columns.
  4. In the Forms list box, select the form for which you want to generate the report or select Account to generate a report with a layout with companies in rows and closing versions/contribution versions in columns.

    If you select several forms, all pages will be printed by group and form before the next form is printed. Only select one form when you run drilldown reports.

    If you select account, you must enter a group and combinations of closing versions and contribution versions.

  5. Enter the actuality, period, consolidation type, group/company, closing version, contribution version and currency type for which you want to generate the report.
  6. Click the Details button to display more report options.
  7. Enter information on the dimensions to generate the report for. Blank code gives the total.
  8. Select the relevant report options:
    • Show Rows Without Values
    • Show Companies Without Values
    • Show Consolidated Group
  9. Select Show Eliminations Separately to add three extra columns to show the eliminations of acquisitions and the eliminations of intercompany balances and intercompany profits, instead of distributing them on each company. This option is only enabled if you selected Companies for column contents.
  10. Click the Preview button to generate the report.
  11. At the bottom of the report, select the drill identity.
    • Account
    • Company
    • Journal Type
    • Automatic Journal Type
    • Journal Number
    • Counter Company
    • Counter Dimension
    • Extended Dimensions 1-4
  12. When you have selected a drill identity, click the Drilldown arrow at the right side of the screen. The report window is now replaced by the drill window. Use the Previous arrow to go back one level and the Home arrow to return to the report.

Results

  • You must have consolidated the groups up to the level below the group you have selected, in order to see amounts on subgroups and to see eliminations.
  • When you drill, a new window opens above the drill window. Here you can see what you drill on - how you go between different drill identities. When the window is full, a scroll list is displayed.
  • To view data on a company, you must select the group that the company belongs to, so that the company is displayed in a column. Then you can drill on any identity.
  • The option Alternative Layout for Reported Values cannot be combined with a drill-down report.
  • You can only drill by Automatic Journal Type on the selected group, as Automatic Journal Types are removed on consolidated values.
  • In order to get coherent values when drilling, you must select contribution version ALL. The reason for this is that consolidated values do not have automatic journal types. All values from levels below are considered base values.
  • When you want to make a new selection of the report, click the Shows or Hides the Header button.