Copying historical rates

You can copy historical rates from one period to another period. When copying, the closing balance from the previous period is not automatically transferred as the opening balance for the current period. To transfer the closing balance, use the Mass Adopt function. Alternatively, you can manually edit or copy the rate for the opening balance detail.

Note: You cannot manually specify or copy rates for closing and opening balances for accounts that are configured as retained earnings in Business Modeling. This is because calculations are automatically applied by cube rules in the TDETAIC cube. According to the logic of the Detail Entity Rollover Retained Earnings Group Currency rule, the DACOUNT account matches the carry forward system account that is defined in Business Modeling. These calculations are automatically applied:

Rollover of the closing balance of the previous year for retained earnings accounts.
The previous year's profit and loss is included as the opening balance for the current year.

The calculations are performed only in the group currency. No currency conversion is involved because the rules operate within the group currency context and do not depend on exchange rates.

To configure a retained earnings account in Business Modeling, select Modules > Consolidation > Core and click Configure. On the Default Settings tab in the Configure Consolidation dialog box, specify a retained earnings account in the System Account field in the Carry Forward section.

To copy historical rates in Financial Consolidation, perform these steps:

Select Rates and Reconciliation > Historical Exchange Rates > Historical Rates.
Specify the historical rates and click Copy Rates.
In the Source section, specify this information:

Configuration Set

Specify the configuration set from which to copy the rates.

Version

Specify the version from which to copy the rates.

Entity

Specify the entity or multiple entities from which to copy the rates.
If you select multiple entities, then the rates are copied only to the same range of entities in the Target section.

Period From

Specify the period from which to copy the rates.
If you specify only Period From without Period To, then only Period From is copied. You can copy this period to one or multiple periods in the Target section.

Period To

Specify the end period of the period range from which to copy the rates.
If you specify information in both the Period From and Period To fields, then this period range is copied to the target, starting from the period that you specify in the Target section, into consecutive periods.
In the Target section, specify this information:

Configuration Set

Specify the configuration set to which to copy the rates.

Version

Specify the version to which to copy the rates.

Entity

If you selected one source entity, then select one or multiple entities to which to copy the rates. Only entities that have open periods are available for the selection.
If you selected multiple source entities, then this field is disabled and is populated with the same entities as the selected source entities.

Period From

Specify the period to which to copy the rates.
If you specified only Period From in the Source section, then you can specify one or multiple target periods. The rates from the source period are copied to all selected target periods.

If you specified a period range in the Source section, then you can specify only one target period. The rates are copied starting from the specified target period, into consecutive periods.
Click Apply.