Generate Ad Hoc Reports

Ad hoc reports are used to generate reports that temporarily combine different identities like actuality, period, consolidation type, company, currency type and extended dimension. Only reports based on data entry forms can be used in ad hoc reports.

Ad hoc reports are based on input from accounts on data entry forms. You can easily combine different dimensions like actuality, period, consolidation type, group perspective, company, currency type and extended dimension to generate a report. The reports created in Ad Hoc Reports are only temporary and the report settings cannot be saved.

Also available is an editable grid, containing the following columns, Actuality, Period, Consolidation Type, Group Perspective, Company, Currency Type, Extended Dimension 1-4, Closing Version or Journal Type and Contribution Version or Automatic Journal Type.

In ad hoc reports, you can choose to view automatic journals types either summed into contribution version Base at subgroup level, or all automatic journal types specified separately at the subgroup levels.

Note: From the 10.1.0 release, the default setting is to present automatic journal types specified separately at the subgroup levels. Journal number 0 indicates that the amount originates from a subgroup level. To view automatic journal types summed into contribution version Base at subgroup level, select Consolidated Automatic Journal Types as Base.

For more information about automatic journals at the subgroup level in ad hoc reports, see View automatic journals at subgroup level.

Procedure

  1. On the Reports menu, click Ad Hoc. The Ad Hoc Reports window opens.
  2. In form list box to the left, select the form for which you want to run the report.
  3. Under Report Selections, enter the dimensions, if and when applicable, for which you want to run the report.
  4. Select the Fixed check box if you want to display several columns with the same period.
  5. In the Columns text box, specify the number of periods you want to display. You can select up to twelve columns. If the Fixed check box is not selected, the columns will display the periods following the specified period.

    Select Consolidated Automatic Journal Types as Base if you want to sum automatic journal types into contribution version Base. If you do not select this option, the automatic journal types coming from a lower level will be specified separately at the subgroup levels, with journal number 0.

  6. Click the Apply button to apply the selections before running the report. The selections are displayed in the matrix.
  7. Click the Preview button to generate the report.

Results

  • Group Perspective is used for presenting the eliminations belonging to a specific group.
  • Account code is displayed in the report.
  • Consolidation type can only be used with contribution version/automatic journal type other than blank.