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
Currency Revaluation Template Name	*	The name of the template.
Exclude Revalued Lines		Indicates how lines that have already been revalued are processed. The options are: "Exclude from selection". "Fail with an error".
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.
Ignore Unused Currencies		Indicates that any unused currencies are excluded from the revaluation process.
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".

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: "Standard Breakdown". Transaction line items for the gains and losses GLA are broken down by standard analysis fields (Account, Product, Bank Account, Tax Code). "Sub-Analysis Breakdown". The CRV summaries and transaction line items for the gains and losses GLA are broken down by custom fields that have been set up for sub-analysis mapping Mapping of custom fields at header and line level for the purpose of profitability reporting..
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.
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 elements 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.
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.

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.

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.

Concepts

About Currency Revaluation and Translation

How CRVs are Calculated

About CRV Groups

Scheduling a CRV

Currency Revaluation and Translation Example

Tasks