Creating CRV Documents

To create CRV documents follow these steps:

  1. Select
  2. Revalue and Translate
  3. Review (optional)

The next step is to post the CRV documents to create the CRV transactions. For more details see Posting CRV Groups and Documents.

Select

To select the transactions to revalue:

  1. Log in to your organizationClosedA deployment of the Salesforce/FinancialForce applications with a defined set of licensed users. Your organization (org) includes all of your data and applications, and is separate from all other orgs. with accountant-level user permissions.
  2. Make sure that you are in single-company mode and that the current companyClosedThe company in which you are working. This is represented by the company queue to which you, and new instances of objects you create, are assigned. is the one you want to revalue.
  3. Click the Currency Revaluation tab.
  4. Click New.
  5. [Optional] If you have an existing CRV template, click Load Template. Select a suitable template and click Load. This retrieves a saved set of selection criteria.
  6. Select the source of the revaluation data. Are they related to Balance Sheet general ledger accounts (GLAs), Income Statement ones, or both?
  7. Specify the range of periods to retrieve data from. The start of the balance sheet selection range can be either the opening balance at the start of trading or a specific trading period.
  8. Specify the period to post CRV transactions to. This must be equal to, or later than, the end period of the selection period range.
  9. Specify the period to post reversal transactions to. This must be equal to, or later than, the posting period.
  10. [Optional] For balance sheets select Exclude CRV Transactions to ignore CRV lines. This ensures that CRVs are not included. CRV transactions that are included in income statements are already ignored.
  11. Choose how you want to select GLAs. The options are: automatically select all eligible general ledger accounts or choose your own. You only get the second option when you have chosen a single revaluation source.
  12. [Optional] If you chose the option to pick the GLAs to use, select them now.
  13. [Optional] If a second revaluation type is selected, repeat the previous steps.
  14. Tell the application what you want to happen when it finds lines that have already been revalued. You can choose to exclude them from the selection or fail with an error.
  15. If you want the process to include all currencies in your org, irrespective of whether they are used or not, clear the Ignore Unused Currencies checkbox.
  16. Click Retrieve Data. The selected transaction line items are retrieved and the Revalue and Translate page is displayed.

Revalue and Translate

To review the transaction line items retrieved:

  1. In the Document Currencies column, click the currency pair that you want to review, such as USD to GBP. This opens a list of retrieved transaction line items for the selected currency pair and the period and GLA criteria entered on the previous page.
  2. Review the retrieved transactions.
  3. [Optional] Click Export As to export the retrieved transactions in the selected output format (XLS, CSV or PDF). The Microsoft Excel and CSV files are downloaded to your Downloads folder. The PDF is automatically displayed. Use the Save As feature to download the PDF to your local machine.
  4. When you have finished, click Close.
  5. [Optional] Repeat the process for other currency pairs.

You can now choose to Revalue, Translate or both, using the Revalue checkboxes. The Currency Translation feature must be enabled in order to use it. For more information about currency translation, see About Currency Revaluation and Translation.

To revalue Document to Home and translate Home to Dual currency pairs:

  1. [Optional] If the Foundations Exchange Rates Integration is enabled on your org, you can select the Exchange Rate Type that you want to use for revaluation and translation.
  2. Select the Revalue checkboxes for any Document to Home currency pairs that you want to revalue. You can see the Latest Entered Rate and a Conversion illustration for each currency pair.
  3. Enter the new CRV rates (up to nine decimal places). The rates you enter are applied to all appropriate records, regardless of any exchange rate overrides that might have been specified when the documents were entered.
  4. To translate the Home to Dual currency pair enter the currency translation rate.If you do not want to carry out translation, clear the Translation checkbox.
  5. Enter the revaluation unrealized gains or losses GLA that you want to use.
  6. Enter the currency translation adjustment GLA that you want to use.
  7. Choose whether you want to analyze by dimensions and whether you want to copy them from the source transactions or specify them here.
  8. [Optional] If you chose to specify dimensions here, enter them now.
  9. Choose whether you want the application to summarize the lines with the same analysis, or list all revaluation detail lines individually.
  10. [Optional] If you chose to list all detail lines individually, choose between a standard or a subanalysis breakdown. For a description of these analysis breakdown types see Currency Revaluation Fields.
  11. [Optional] If you want to schedule the revaluation process, enter a date and time for the job to run.
  12. [Optional] If you want to use these selection criteria again, click Save Template. A summary dialog is displayed. Enter a descriptive name for this new template and click Save.
  13. Click Generate to generate the CRV group but not post them yet.

What happens next depends on whether you have scheduled the process:

See Scheduling a CRV for more information.

To monitor the batch jobs, from Setup, click Monitoring | Apex Jobs.

Review

You can review CRV Documents individually or in a group.

Notes:
The name of every document generated by the currency Revaluation & Translation process is prefixed with CRV. You can use the Document Ordering field to help you to order and categorize Currency Revaluation & Translation documents. In the Document Ordering field, Currency Revaluation documents are prefixed by CRV and Currency Translation documents are prefixed by CRT.
Notes: If the Accounting multi-book feature is active on your org, then each CRV document will be linked to the appropriate Accounting Book.

To view CRV Documents individually:

  1. Click the Currency Revaluation tab.
  2. From the Currency Revaluations list view, click the CRV Document you wish to review.

To view a summary of the CRV documents in a group:

  1. Click the Currency Revaluation Group tab.
  2. Click the name of the CRV group to display its detail page.
  3. Copy the group name. This step is not required when using the standard inquiry template supplied by FinancialForce.
  4. Click Revaluation Summary. If you don't see this button, contact your administrator.
  5. Select an inquiry templateClosedSpecifies the dataview that you are inquiring on in FinancialForce Reporting., or accept the default one displayed.
  6. Click Next.
  7. Paste the group name into the input field, if it is blank.
  8. Click Select to run the action view.