Location: Internal Data Transfer (IDT) (task ID: InternalTransfers)

1.On the Source Options 1 tab, select the following options. Mandatory options are marked with an asterisk.

o*Data type: The data type from which data is transferred. The data types to which you have at least 'read' rights are available in the list.

o*Year: The year from which data is transferred. The list contains all financial years included in the system.

oDimensions/Units: The dimension(s) from which data is transferred. For the selected dimensions, select the units from which data is transferred. If you select a consolidation unit, the data is transferred from all input units under it. If you do not select any units, data is transferred from all units (to which you have sufficient rights). The dimension unit tree contains all units of the selected dimension for which you have at least 'read' rights in the selected year. You can select several units by holding down the CTRL key if the 'multiselect' function is in use (refer to Clausion Financial Performance Management User Interface Task Parameters). This setting is dimension-specific. To search for units, type a search term in the text field above the unit tree and click . To move to the next match, click again.

Note! It is not possible to select a unit for codim00. All codim00 units are always transferred.

oHierarchy: The hierarchy from which data is transferred. The list contains all hierarchies defined for the selected dimension. If you do not select a hierarchy and a hierarchy is not defined in the task settings, structure 1 is used by default for the source unit list.

o*Periods: The periods from which data is transferred. At least one period must be selected. The available periods depend on the task settings. If the content of the period list has not been defined in the task settings, all periods are included in the list. If the 'multiselect' function is in use (refer to Clausion Financial Performance Management User Interface Task Parameters), you can select several periods by holding down the CTRL key. To select all periods, select the uppermost item in the period tree. To select, for example, all normal periods, select the second-level (folder) item Normal periods. If the 'multiselect' function is not in use, period selection is available as a drop-down list and you can select only one period.

Note! You must select all periods if you select Delete source data on the Target Options tab.

o*Accounts: The accounts from which data is transferred. You can select several accounts by holding down the CTRL key if the 'multiselect' function is in use (refer to Clausion Financial Performance Management User Interface Task Parameters). At least one account must be selected. If you select a sum account or a summary account, the data is transferred from all input accounts under them.

2.On the Source Options 2 tab, select the following options.

oDocument series: The document series from which data is transferred. Select the document series from the list. You must select at least one document series.

oPeriodical: Source data is retrieved as periodic values.

oCumulative: Source data is retrieved as cumulative values for each period.

Note! The cumulative setting of the target account also has an effect on the transfer (see Modifying Account Properties).

3.On the Target Options tab, select the following target options. Mandatory options are marked with an asterisk.

o*Target data type: The data type to which data is transferred. The data types to which you have user rights are available in the list.

o*Target year: The year to which data is transferred. The list contains all financial years included in the system.

o*Type of target data:

▪Periodical: The transferred data is converted to periodical values.

▪Cumulative: The transferred data is converted to cumulative values.

Note! The cumulative setting of the target account also has an effect on the transfer (see Modifying Account Properties).

oConversion tables: You can select a conversion table for each dimension, period, document series, and account. If you do not select a conversion table (option Not defined) or a selected unit/period/document series/account is not included as a source in the selected conversion table, the source unit/period/document series/account is used as the target. For codim00, the conversion table defined for dim00 is used.

To view the conversion table settings (source-target rows), click next to the conversion table drop-down list.

Replace target data: This option is available for units and accounts. When you transfer data to another data type/year combination, select this check box if you want to replace existing data for the selected consolidated units or sum accounts in the target. If you do not select this check box, existing data remains in the target after the transfer for those units and accounts that are not connected to the source data type.

The conversion tables are created in Conversion Tables (see Conversion Table Management).

oFactor: The transferred data is multiplied by the value entered in this field. The value can be any numeric value. The default value is 1. Note that value 0 is used in calculations. In other words, if the factor value is 0, target values will be 0. This can be used, for example, to clear selected periods.

oDelete source data: Select this option if you want to delete the source data after it has been transferred to the target. If you do not select the check box, the source data is copied to the target, but also remains in the source.

Note! If you select Delete source data, you must also select all periods on the Source Options 1 tab.

Note! You need 'write' rights to the source data for deleting it.

oDo not create automatic counter entries: Select this option if do not want automatic counter entries to be created when transferring data to another data type (even if automatic counter entries are defined for the target data type). Existing automatic counter entries will also be deleted.

Tip! If you want to save your options to your favourites, click Save to Favourites after making your selections. You can then open the task with the same options from your Favourites view. If you edit saved favourite options, click Save to update the favourite settings.

4.Click Start Transfer.

You can monitor the status of internal data transfer runs using the Internal Data Transfer (IDT) Status custom template.