Currency Revaluation Template Fields

Here is a description of the fields that make up a multi-company currency revaluation template.

Information

The following fields are available in the Information section.

Key: * – Mandatory field

CRV Template Information Fields

Field

 

Description

Bank Account Balance Revaluation   If selected, indicates that the revaluation applies to bank account balances. If you select this you must select a GLA Balances revaluation method and a Currency Revaluation or Currency Revaluation and Translation template type.
Currency Revaluation Method  

The currency revaluation method used to create the template. The options are:

  • Transaction Lines
  • GLA Balances
  • GLA Balances and Dimensions 1-4
Currency Revaluation Template Name * The name of the template.
Exclude CRV Transactions  

Indicates that the Exclude Revalued Lines option was set to "Exclude from selection" when the CRV was created. The checkbox is deselected if the Exclude Revalued Lines option was set to "Fail with an error".

Note:

This field must be deselected when the GLA Balances currency revaluation method is selected.

Exclude Revalued Lines  

Indicates how lines that have already been revalued are processed. The options are:

  • "Exclude from selection".
  • "Fail with an error".
Note:

This field must be blank when the GLA Balances currency revaluation method is selected.

Ignore Unused Currencies  

Indicates that any unused currencies are excluded from the revaluation process.

Revaluation Type *

Indicates the revaluation type:

  • "Income Statement"
  • "Balance Sheet"
  • "Both"
Template Type *

Indicates the template type. Template types are:

  • "Currency Revaluation"
  • "Currency Translation to Dual"
  • "Currency Revaluation and Translation to Dual"
  • "Currency Translation to Reporting"

The template type determines the processes that are run and the tabs that are available on the Currency Revaluation Criteria page when you click Retrieve.

Note: The Currency Translation to Reporting type only appears if the Reporting Currencies feature is enabled.

Analysis

The following fields are available in the Analysis section.

Key: * – Mandatory field

CRV Template Analysis Fields

Field

 

Description

Analysis Breakdown  

If you selected "List all revaluation detail lines individually" in the Summary/Detail field you must select an analysis breakdown type to apply to the revaluation. The options are:

Note:

This field must be blank when the GLA Balances currency revaluation method is selected.

Dimension 1-4   Analysis dimensions to use when posting to the Unrealized Gains/Losses GLA.
Dimension Analysis  

Indicates whether you want to copy the analysis dimensions from the source transactions, or enter them during the configuration. The default (None) indicates no dimension analysis.

Note:

This field must be blank when the GLA Balances currency revaluation method is selected.

Dual Currency Translation Adjustment GLA   The GLA to which the total dual currency translation amount is posted. This field supports corporate and local GLAs.
Dual Translation Exchange Rate Type   The dual currency translation exchange rate type used to report to the parent company. The available options are listed in the Translation Exchange Rate Type field.
Revaluation Exchange Rate Type *

Indicates the revaluation exchange rate types. Defaults to Average, the available types are:

  • None
  • Average
  • Budget
  • Closing
  • Spot
  • Commercial
  • Translation
  • Historical
Summary/Detail *

All transaction lines that share the same analysis elementsClosed The elements of a full accounting code consist of a general ledger account, an entity, and up to four analysis dimensions. are grouped into a CRV summary. The options are:

  • "Summarize lines with the same analysis". All lines that share the same analysis elements are summarized into a single entry.
  • "List all revaluation detail lines individually". You can drill down from summary level to the individual CRV detail lines.

For both options, the total is posted as a single summarized line to the Unrealized Gains/Losses GLA.

Note:

This field must be blank when the GLA Balances currency revaluation method is selected.

Translation Exchange Rate Type  

Indicates the translation exchange rate types. Defaults to Translation, the available types are:

  • None
  • Average
  • Budget
  • Closing
  • Spot
  • Commercial
  • Translation
  • Historical
Unrealized Gains/Losses GLA  

The GLA that the unrealized gains and losses are posted to. However, if for the accounting company you select the Use Unrealized Losses GLA checkbox, only use this field for the unrealized gains. This field supports corporate and local GLAs.

Unrealized Losses GLA   The GLA that the unrealized losses are posted to. This field supports corporate and local GLAs.

Reporting Fields

If the Reporting Currencies feature is enabled in the org and the template type selected is "Currency Translation to Reporting", the following fields are added to supplement the currency revaluation template fields.

Field

Description

Reporting Currency Translation Adj GLA

The GLA to which the total translation amount is posted for reporting. This field supports corporate and local GLAs.

Reporting Translation Exchange Rate Type The translation exchange rate type used to report to the parent company. The available options are listed in the Translation Exchange Rate Type field.

Companies

The following fields and buttons are available on the Companies panel on the Currency Revaluation Template page.

Note:
Certinia recommends that if the template type is "Currency Translation Only", you only include companies where the Document and Home currency values are the same. If a company has documents that are not in the Home currency, we recommend that you select a template that has "Currency Revaluation and Translation" as the template type to run Revaluation and Translation together.

Fields

The following fields are available.

Field

Description

Companies

Displays the number of companies associated with the template. The selected companies must be either corporate or local and must match the type of GLAs selected on the General Ledger Accounts panel. All companies and GLAs must be either corporate or local.

Buttons

The following button is displayed.

Button

Description

Manage Enables you to add or remove companies associated with the currency revaluation template.

General Ledger Accounts

The following fields and buttons are available on the General Ledger Accounts panel on the Currency Revaluation Template page.

Fields

The following fields are available.

Field

Description

General Ledger Accounts

Displays the number of the general ledger accounts associated with the template, and lists those general ledger accounts.
If all eligible general ledger accounts are selected, a message informing you of this displays.

This field supports corporate and local GLAs. The selected GLAs must be either corporate or local and must match the type of companies selected on the Companies panel. All companies and GLAs must be either corporate or local.

Buttons

The following button is displayed.

Button

Description

Manage

Enables you to add or remove general ledger accounts associated with the currency revaluation template.

If all eligible general ledger accounts have been selected automatically, this button is not available.