Creating Currency Revaluation Templates

When you create a Currency Revaluation (CRV) template, you create the template details first and then assign companies and general ledger accounts separately.

Note:

This functionality is only available in Lightning and must be enabled using Feature Console.

Warning:

If you have upgraded from a previous version of Accounting and have existing currency revaluation templates, you must update the new fields that have been added.

Tip:

If you work in multi-company mode with local companies, we recommend that you create a different template for each local company.

Creating CRV Template Details

For more information, see Currency Revaluation Template Fields.

Note:
The processes that run when you generate revaluation documents are determined by the template type. 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.

To create a currency revaluation template.

  1. On the Currency Revaluation Templates tab, click New.
  2. Enter the Currency Revaluation Template Name. This must be unique.
  3. Select the Revaluation Type. You can select Income Statement, Balance Sheet or Both.
  4. [Optional] Select how you want the process to handle transaction lines that have already been revalued.
  5. [Optional] If you want to view unused currency information, clear the Ignore Unused Currencies checkbox.
  6. Select the Template Type. The template type determines the processes that you can run when creating currency revaluation criteria from the template. You can select:
    • Currency Revaluation. Enables you to run revaluation only.
    • Currency Translation. Enables you to run translation only.
    • Currency Revaluation and Translation to Dual. Enables you to run revaluation and translation using the Dual currency.
    • Currency Translation to Reporting. Enables you to run translation using the reporting currency.
  7. [Optional] Select Exclude CRV Transactions.
  8. Select the Revaluation Exchange Rate Type. Defaults to Average. This is optional for Translation.
  9. Select the Translation Exchange Rate Type. Defaults to Translation. This is optional for Revaluation.
  10. Select Unrealized Gains/Losses GLA. This is only required if you selected Currency Revaluation or Currency Revaluation and Translation to Dual as the Template Type. If for the accounting company you select the Use Unrealized Losses GLA checkbox, only use this field for the unrealized gains. Use the Revaluation Unrealized Gains GLA field for the unrealized gains, and the Revaluation Unrealized Losses GLA field for the unrealized losses.
  11. Select Unrealized Losses GLA. This is only required if you selected Currency Revaluation or Currency Revaluation and Translation to Dual as the Template Type.
  12. Select Translation Adjustment GLA. This is only required if you have selected Currency Translation or Currency Revaluation and Translation to Dual as the Template Type.
  13. Select the Summary/Detail analysis type. You can select Summarize lines with the same analysis or List all revaluation detail lines individually
  14. [Optional] Select the Analysis Breakdown. This is required if you have selected List all revaluation detail lines individually.
  15. [Optional] Select the Dimensions 1-4 that you want to use. You must enter at least one dimension if you have selected Analysis Breakdown - Specify Dimensions.
  16. Click Save. The Currency Revaluation Template page displays, so that you can assign companies and general ledger accounts to your template.
Note:

When you create currency revaluation criteria, the GLAs and the companies associated with the selected template must be either corporate or local.

Assigning Companies and General Ledger Accounts to a CRV Template

You must meet all three criteria below to assign companies and general ledger accounts to a currency revaluation template:

  • The selected companies must either be all corporate or local.
  • The selected GLAs must either be all corporate or local.
  • Companies and GLAs must be of the same type, either corporate or local.

Assigning Companies to a CRV Template

It is recommended that you assign a maximum of 30 companies to a template.

To assign companies to a currency revaluation template.

  1. [Optional] On the Currency Revaluation Templates tab, click the name of the template that you want to assign companies to. The Currency Revaluation Template page displays.
  2. On the Select Companies pane, click Manage.
  3. Select the companies that you want to assign.
  4. Click Save.

Assigning General Ledgers Accounts to a CRV Template

If you select a revaluation type of either Income Statement or Balance Sheet, you can select the general ledger accounts used by the revaluation.

If you select a revaluation type of both Income Statement and Balance Sheet, all eligible general ledger accounts are automatically selected.

To assign general ledger accounts to a currency revaluation template.

  1. [Optional] On the Currency Revaluation Templates tab, click the name of the template that you want to assign general ledger accounts to. The Currency Revaluation Template page displays.
  2. On the Select General Ledger Accounts pane click Manage.
  3. Select the general ledger accounts that you want to assign.
  4. Click Save.