Revalue AR Accounts

Form ID: (CM505000)

You use this form to revalue open customers' Accounts Receivable documents maintained in a foreign currency. First you select a foreign currency to display all customer accounts maintained in this currency, and then you select the accounts and provide a description for the Accounts Receivable revaluation. You can perform Accounts Receivable revaluation as often as is needed to estimate unrealized gains and losses.

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 balances of the selected Accounts Receivable 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 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

By using the elements 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 to be used for the revaluation. By default, it is the last day of the selected financial period.
Currency The foreign currency 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 Currency Management 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 Currency Management 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 form, the base currency symbol in parenthesis is displayed for this box.

Table

This table contains the list of AR accounts with the balances in the original currency and in the base currency before and after revaluation. You use this table to select 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.
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 that 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.

Customer The customer whose balance is maintained in the selected currency in the account shown in the Account column.
Customer Name The name of the customer.
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 AR Revaluation Rate Type box on the Currency Management Preferences (CM101000) form. If a currency rate type has been specified for the particular customer on the Customers (AR303000) 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 account balance in the selected foreign currency.
Original Balance The account balance in the base currency before the revaluation.
PTD Gain or Loss The period-to-date (PTD) gains or losses for previous translations performed for this customer and this account in this period for the specified foreign currency.
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.