Overview of Internal Data Transfer

<< Click to display table of contents >>

Overview of Internal Data Transfer

You can use the Internal Data Transfer (IDT) function for transferring data within the system, for example, to transfer the balance of the previous year to the active year, or for copying data from actual data type to estimate.

Manually entered unit amounts (input type 0) are transferred. You can transfer data from years, periods, accounts, data types, or dimension units to other years, periods, accounts, data types, and units for a selected document series. You can transfer data to several periods at the same time, but not from one period to multiple periods (data must be transferred separately for each target period). If several different source accounts/document series/periods/units have the same target account/document series or the source is a consolidation unit or sum account, the amounts from all the sources are summed to one target.

Note! If you transfer data from a document series of type 4 or 6 to a target document series of type 7, automatic entries (input type 1) are transferred and converted to manual input before entering to the target document series. The same also applies if you transfer data from a document series of type 6 to another document series of type 6.

After the transfer, group amounts are calculated and input data calculations are run for the target data automatically.

Note! Customer-specific extra field data, TR data, and year-specific comments are not transferred.

Note! DIM00 must be connected to the source and target data types.

The internal data transfer settings can be defined in the user interface task XML. For more information, refer to Clausion Financial Performance Management User Interface Task Parameters.

Click to open/close expanding sectionTransferring internal inventory data

When you transfer data from a document series of type 4 to the same or another document series of type 4, internal inventory data is also transferred (copied from source to target).

•Amounts: Cumulative values are always used for the source and target data regardless of the Type of data option (periodical or cumulative) you select. The Factor value and conversion tables you select for the target data are used when coping data.

•Tax percent: The values are copied from the source to the target regardless of the source and target periods. Tax percent for period 0 is copied if period 0 is not locked. Otherwise, the original value remains. In case when period conversion is used, where source period is not 0 and target period is 0, the tax percent is copied to period 0. This serves especially transfer of closing balance to next year opening balance (source period = 12, target period = 0). If there is more than one value (for example, consolidation unit as the source), the average is calculated. Factor and type of data options are ignored.

•Margin percent: If there is more than one value, the average is calculated. Factor and type of data options are ignored.
Click to open/close expanding sectionUser rights

You must have at least 'read' rights to the source data (units, accounts, periods, data types) and 'write' rights to the target data. If you want to delete the source data after the transfer, you need 'write' rights also to the source data. The hierarchy of the source data is used also for the target data.
Click to open/close expanding sectionUnit and counter unit validity checks

All target units and counter units must be valid input units in the selected hierarchy for the target year/data type after the unit conversion, and the transfer fails if this is not the case.

Note! This check is only performed for units for which there is data to be transferred and so invalid combinations for which there is no data do not make the transfer fail.