Internal Data Transfer (IDT)

Running Internal Data Transfer

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.

   • *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.

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

   • Dimensions/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 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.

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

   • Hierarchy: 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.

   • *Periods: The periods from which data is transferred. At least one period must be selected if you transfer period data. If you transfer data from extra fields, period selection is optional. 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 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.

     You cannot select quarter periods as the source or target for the transfer.

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

   • *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 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.

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

   • Periodical: Source data is retrieved as periodic values.

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

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

   • IDT-source: group currency: When you select this option, the transfer is done using group currency as the source instead of the currency of the unit(s).

     If you do not see the IDT-source: group currency selection, please enable it by adding sourceusegroupcurrency component in UI task.

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

   • *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.

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

   • *Type of target data:

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

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

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

   • Conversion 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).

   • Factor: 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.

   • Delete 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.

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

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

   • Do 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.

   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.

Conversion Tables

Location: Conversion Tables (task ID: ConversionTableMnt)

Conversion tables are used in internal data transfer when data is transferred from source units, accounts, periods, or document series to different target units, accounts, periods, or document series. Conversion tables may also be used in the integration of data from other source applications.

Note that when a source unit or account is not a valid input unit or account in the target structure, its parent level unit or account is automatically used as the target. A conversion table is not needed for the transfer in this case.

To create a new conversion table

1. Click New.

2. Add an ID for the conversion table and select the conversion table type.

   The type of the conversion table determines to which conversions for internal transfer / integration each table may be selected. Possible table types are dimensions (as many as exist in the environment), accounts, periods, document series and custom conversion. Note that there is no separate type for codim00, but dim00 conversion table is also used for codim00.

3. Click Save.

4. Under Conversion Table Details, add a name for conversion table in the languages used in the system and a description.

5. Under Conversion Table, add the source and target units/accounts/document series. To open a selection list, double-click in the Source ID or Target ID fields.

Note:

• All existing units of the dimension can be added to a conversion table. However, no automatic currency conversions are performed. Therefore, the source and target units should use the same currency.

• All accounts except calculated accounts can be added.

• All existing periods and document series can be added, but note that the source and target document series types must be the same (the only exception is document series types 4 and 6).

• Contrary to other types, the Custom conversion tables are year-specific (year must be selected when opening table) and no checks of entered values are performed to them.

  You can use a default year if you do not want the year rolling forward.

If there is an error on a row, the error icon is displayed in the first column of the row. To view the error, move the mouse cursor over the icon.