Documents

You can filter the data by documents, either by defining the maximum and minimum document number limits or selecting document series. Only the data that has been entered to the selected documents/document series is then shown on the template. By default, all document series are included in the template.

•Document range: If you select this option, select the lower and upper limits of the range from the drop-down lists.

•Document series: If you select this option, select the document series from the list. You can use Ctrl+a to select all available series, or Ctrl+u to unselect all the series.

The document and document series options apply when the template definition file does not contain document series definitions for the data columns. Document series selection applies also, when data column definitions contain the %DOCUMENT ADVANCED CODES% parameter.

Type of Data

•Periodical: If you select this option, the data in the template is change during the period.

•Cumulative: If you select this option, the data is shown in the template as cumulative figures.

Other Options

All entries allocated to unit

This check box is available if defined in the task settings. Depending on the settings, you may be able to change the default selection.

•If the option is selected, all entries allocated to the selected organization unit are displayed regardless of the counter unit of the entry. You must have at least 'read' rights to the unit.

•If the option is not selected and the selected unit is a consolidation unit, only entries such as internal transactions and other eliminations between sub-units of the selected consolidation unit are displayed (that is, the entries with units from other consolidation levels are not displayed).

•If the option is not selected and the selected unit is an input unit, the entries are not displayed.

Note that when the template includes counter unit as a definition column, this option must be selected to see entries where the counter unit is different than the unit. In these cases, the template settings define which counter units are shown.

See below for examples on using the All entries allocated to unit option.

All internal transactions for unit

This check box is available if defined in the task settings. Depending on the settings, you may be able to change the default selection.

If the option is selected, all internal transactions in which the selected unit or any of its sub-units is used as the unit or the counter unit are displayed. You must have at least 'read' rights to either the unit or the counter unit.

If the option is not selected, internal transactions of type 2 document series are displayed according to the selection of the All entries allocated to unit option (see above).

This option has effect only on type 2 document series entries, DIM00 and report data columns. If data is retrieved from other document series, the All internal transactions for unit option is ignored. In other words, for these series the data is displayed the same way as if the option was not selected.

When All internal transactions for unit is selected, the All entries allocated to unit option is irrelevant for type 2 document series.

See below for examples on using the All internal transactions for unit option.

Scaling factor

If you want to use scaling, select the check box and type a scaling factor in the Scaling factor field. For example, a scaling factor of 1000 will display the figures as thousands.

This option applies when the template contains the %USERSCALINGFACTOR% parameter as the value of the <scaling> element in the data column settings.

Currency

Select the currency in which you want the data to be shown in the template. The available options are:

•Group currency

•Unit currency (currency of the unit selected in Basic Options)

•All currencies available in the system

This option applies when the template contains the %USERCURRENCY% parameter as the value of the <currency> element in the basic area or data column settings.

Input and reporting is possible in a third currency (some other currency than group currency or the currency of the unit(s) defined for the template) when the <currency> element is defined in the basic area or data column settings of the template. If the definition is missing, no conversion is done even if you select a third currency from the list.

The data is converted into the selected currency using the currency rates defined for the currency table of the data type used for the data. If a currency rate is missing from one or more periods, a warning message is shown. To view the message, click the Warnings link under the ribbon.

Currency conversion is made when data is saved to or retrieved from the database to a report or input template. The entered data is saved into the database both in the unit and group currency.

Show all drill-down input rows

If enabled in the task settings, this option is available for input templates that include the account drill-down input function.

Select the Show all drill-down input rows option if you want all input-level drill-down rows to be shown by default when opening the template. If this option is not selected, you need to click drill-down rows open one by one.

Note that sum account levels are not opened automatically, and this option does not have an effect on other drill-down functions (viewing sub-account data and drilling down to figures on reports).