Conversion Tables

<< Click to display table of contents >>

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 add-row 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.

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