Revalue GL Accounts

Form ID: (CM506000)

You use this form to revalue GL accounts denominated in foreign currencies. You select the currency of denomination to display all general ledger accounts maintained in this currency, and then you select accounts and provide a description for the revaluation. You can revalue the GL accounts denominated in foreign currencies as often as is needed to accurately reflect your cash position.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
Revalue Initiates the revaluation of the selected GL accounts (along with their subaccounts, if applicable)—that is, those for which you have selected the unlabeled check boxes in the table. As a result, a CM (Currency Management) batch is created and released; it is also posted if the Automatically Post to GL on Release check box is selected on the Currency Management Preferences (CM101000) form.

Selection Area

In this area, you can specify the revaluation settings to be used.

Element Description
Company/Branch

The company, branch, or company group for which you want to perform revaluation. If a company or a branch is selected, the Fin. Period box shows the periods from the company calendar; if the Company/Branch box is empty or contains a company group, the periods from the master calendar are shown.

This setting is required if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form.

Fin. Period The financial period for which the revaluation will be performed.
Currency Effective Date The effective date for the currency exchange rate. By default, the last day of the selected financial period is shown.
Currency The currency of denomination for which the revaluation will be performed.
Description

A detailed description of the revaluation. An alphanumeric string of up to 60 characters can be used.

The system uses this description as the description of the CM batch (and of each journal entry of this batch) generated by the revaluation process. For example, this description is inserted into the Transaction Description column on the Journal Transactions (GL301000) form for each journal entry of the CM batch.

Revaluation Total

A read-only box that contains the total amount of the revaluation, which is calculated as the sum of the values in the Difference column for all the rows you have selected in the table. The system calculates the value in the base currency.

If the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form, the base currency symbol in parenthesis is displayed for this box.

Table

This table contains the list of GL accounts with the balances in the original currency and in the base currency before and after revaluation. You use this table to select the accounts (along with subaccounts, if applicable) for which revaluation will be performed. The system loads the records related to the branches of the entity selected in the Company/Branch box. If this box is empty, the system displays all records related to the branches (or the company, for a company with no branches) to which the user has access.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Column Description
Selected

A check box that you select to include this account-subaccount pair in the revaluation when you click Revalue. To select all the pairs listed on the page, click the check box in the column header.

This check box is unavailable and read-only for inactive accounts—those that have the Active check box cleared on the Chart of Accounts (GL202500) form.

Branch

The branch whose account balance is being revalued.

This column appears on the form only if the Multibranch Support feature is enabled on the Enable/Disable Features (CS100000) form.

Account The account is denominated in the selected foreign currency.
Description The description of the account.
Subaccount

The subaccount used with the account.

This column is available only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form.

Currency Rate Type

The rate type to be used for the revaluation.

By default, this column contains the rate type that has been specified in the GL Revaluation Rate Type box on the Currency Management Preferences (CM101000) form. If a currency rate type has been specified for the particular account on the Chart of Accounts (GL202500) form, the system instead inserts this type into the column.

Currency Rate The currency rate effective on the date of revaluation.
Foreign Currency Balance The balance of the denominated account in the selected foreign currency.
Original Balance The account balance in the base currency before the revaluation.
Revalued Balance The balance of the account recalculated by using the currency rate effective on the date of revaluation.
Difference The difference (in the base currency) between the original and the revalued balances. If the difference is positive, the revaluation has resulted in gains. If the difference is negative, the revaluation has resulted in losses.
Last Revaluation Period The period when revaluation was last performed.