Currency Revaluation and Translation Reports

The following currency revaluation and translation reports are available:

  • CRV Balance Sheet Revalue TLIs report
  • Balance Sheet Revalue - Local
  • Balance Sheet Revalue - Local & Corp
  • CRV Income Statement Revalue TLIs report
  • Income Statement Revalue - Local
  • Income Statement Revalue - Local & Corp
  • Revaluation Reconciliation report
  • In Progress Currency Revaluation Journal
  • Currency Revaluation Journal Transaction
Note:
The Revaluation Reconciliation report is included in the Accounting Reporting Expansion Pack.

The Balance Sheet Revalue and Income Statement Revalue reports enable you to view the transaction line items that have been selected for inclusion in a currency revaluation or translation. The CRV Balance Sheet Revalue TLIs and CRV Income Statement Revalue TLIs reports are generated when you run currency revaluation for corporate companies. For local companies, the following scenarios apply:

  • If no GLAs are selected in the CRV Template, the Balance Sheet Revalue - Local & Corp and Income Statement Revalue - Local & Corp reports are generated.
  • If a GLA is selected in the CRV Template, the Balance Sheet Revalue - Local and Income Statement Revalue - Local reports are generated.

If you have enabled the currency translation feature, you can view these reports directly using the quick action button in the Details section of the Currency Revaluation Criteria page.

The Revaluation Reconciliation report enables you to view the transaction line items that have been included in a currency revaluation or translation.

The following information is available in the reports:

  • Period
  • Document Number
  • Line ID
  • Document Description
  • Document Currency ISO Code
  • Document Value
  • Home Value
  • Dual Value

The In Progress Currency Revaluation Journals enables you to view journal lines before you post them. The report contains the following information, grouped by Company, Reference, and Journal Number:

  • Period
  • Journal Date
  • Line Number
  • General Ledger Account
  • Line Description
  • Override Home Value
  • Override Dual Value
  • Override Reporting Value
  • Dimension 1- 4

The Currency Revaluation Journal Transactions enables you to The report contains the following information, grouped by Company, Reference and Journal Number:

  • Transaction Number
  • Line ID
  • Line Number
  • Period ID
  • Line Description
  • General Ledger Account
  • Home Value
  • Dual Value
  • Reporting Value
  • Dimension 1-4
Note:

The In Progress Currency Revaluation and Currency Revaluation Journal Transaction reports are limited to a maximum of 2000 lines for display, filter and export.

To view a report:

  1. Click the Reports tab.
  2. Select the Certinia Currency Revaluation Reports folder.
  3. Click the name of the report that you want to view.
  4. [Optional] You can change the filters applied to the report.
  5. Click Save.
Note:
For the Reconciliation Report, in order to retrieve transaction line information the currency revaluation must be run at detail level.

For more information, see, "Reports" in the Salesforce Help.