Managing Account Translation

The Solutions Framework provides initial account translation settings during installation. Account translation is used to modify the account translation settings. An account translation setting defines the foreign exchange rate to use for a specific combination of account and translation method.

Accessing account translation settings

To access Account Translation settings in Close or Plan:

1. Select the Consolidate module.
2. Select the Administration category.
3. Expand Foreign Exchange.
4. Click Account Translation. The account translation table appears.

Modifying account translation settings

Account translation allows you to update the account translation settings for the system. In general account translation settings are applied at a parent level, which applies the setting to all its descendent accounts. For example, the default setting for balance sheet is to use the period end rate, which is applied to all balance sheet accounts. This can be overridden at a lower level by adding a setting to the table, selecting a descendent account, and choosing a different exchange rate.

Adding an account translation

1. Click Add to add a new account translation setting.

   Note: You can add a new account translation that has similar settings by selecting an existing row and clicking duplicate.

2. For each translation setting, fill in the following fields:

   1. Account: Select the account to set.

   2. Foreign Exchange Method: Select the foreign exchange method to apply.

   3. Foreign Exchange Rate: Select the foreign exchange rate to use for translating the selected account and its descendants.

Translation settings are not added to the database until you click Submit.

Deleting an account translation

Delete an account translation by selecting the row and clicking delete. The account translation is not deleted from the database until you click Apply.

Modifying an account translation

You can change the properties of an existing account translation:

• Change the Account by selecting a different value.

  Note: This effectively deletes the translation setting for the previously selected account and method combination.

• Change the Foreign Exchange Method by selecting a different value.

  Note: This effectively deletes the translation setting for the previously selected method.

• Change the Foreign Exchange Rate by selecting a different value.

  Note: You can use the FXRate_None rate to specifically exclude an account from being translated. Doing this can have an impact on the translation adjustment calculations, so it should be only used under advisement of your Longview consultant.

No changes are applied until you click Submit.

Refreshing the account translations

Click Refresh to refresh the list of accounts.

If there are any unapplied changes, you will be prompted to apply or discard any changes that have not yet been applied.

• Choose Apply Changes to apply any changes made, then refresh the list of account translations. If there are any errors the refresh will not be performed.
• Choose Discard Changes to discard any changes made, then refresh the list of account translations.
• Click Cancel to return to the table without refreshing the list of account translations.

Submitting changes

To submit changes to the account translation settings, click Submit. The settings in the table will replace the settings currently stored in the database.

Importing into the account translations table

1. Click Import to import from a .csv file into the account translations table.
2. Select the file to import. See .csv file example for import file format.
3. Select one of the following options to replace existing rows:

   1. Replace Existing Rows: If this option is checked, all rows in the table view will be cleared and replaced with the account translations in the import file.

   2. Do Not Replace Existing Rows: If this option is unchecked, all entries in the import file will be appended to the table view.

      Note: Any account translations that exist multiple times in the same import file will be initially duplicated in the table view. Any account translations that exist in the import file AND already exist in the table prior to import will be initially duplicated in the table view. Once you click Apply, the settings for the last instance of the duplicate account translation will be used.

4. Click OK. The file will be imported into the table.
5. Click Submit to save the changes.

.csv file example

Where:

• Account is the name of the account to set.
• Foreign Exchange Method is the name of the method.
• Foreign Exchange Rate is the name of the foreign exchange rate to use for the combination of Account and Foreign Exchange Method.

Exporting from the accounts table

1. Click Export to export from the account translation table to a .csv file.
2. Select the .csv file to export to.

   Note: If the file selected does not currently exist, it will be created during the export process.

3. Click OK. A confirmation dialog will appear.
4. Click View File to view the exported file.