Revalue AP Accounts
Form ID: (CM504000)
You can use this form to revalue open vendors' Accounts Payable documents, including prepayments, that are maintained in a foreign currency. You select a foreign currency to display all accounts maintained in this currency, select the specific accounts to be revalued, and provide a description for the Accounts Payable revaluation. You can perform Accounts Payable 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 Payable 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
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 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 for 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 (CS100000) form, the base currency symbol in parenthesis is displayed for this box. |
Table
This table contains the list of AP accounts with balances in the original currency and 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. |
| Branch |
The branch whose account balance is being revalued. This column appears on the form only if the Multi-Branch 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. |
| Vendor | The vendor whose balance is maintained in the selected currency in the account shown in the Account column. |
| Vendor Name | The name of this vendor. |
| 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 AP Revaluation Rate Type box on the Currency Management Preferences (CM101000) form. If a currency rate type has been specified for the particular vendor on the Vendors (AP303000) 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 account for the vendor 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 vendor 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 is resulted in losses. If the difference is negative, the revaluation is resulted in gains. |
| Last Revaluation Period | The period when revaluation was last performed. |