Revalue customer accounts (CM505000)
You use this window to revalue Customer ledger accounts maintained in a foreign currency. Select a foreign currency to display all customer accounts maintained in this currency, and then select the accounts and provide a description for the Customer ledger revaluation.
You can revalue the Customer ledger accounts at the end of each period as often as needed to accurately reflect your cash position.
The accounts used for the gain/loss and Customer ledger accounts are set for each currency in the Currencies (CM202000) window.
The window toolbar
| Button | Description |
|---|---|
| Revalue | Initiates the revaluation of customers’ selected accounts. As a result, the batch is released and posted. |
The top part
By using the elements in this area, which the following table describes, you can specify a revaluation.
| Element | Description |
|---|---|
| Period | The period for which the revaluation is performed.
|
| Currency effective date | The effective date for the currency exchange rate to be used for the revaluation. By default, it is the last date of the current period. If you enter a date outside the selected period, you will get an error message and cannot process the transactions. |
| Currency | The foreign currency used by the customers. |
| Description | A detailed description of the revaluation. You can use up to 30 characters, both numbers and letters. The system uses this description as the description of the batch (and each journal entry of this batch) generated by the revaluation process. For example: It is added to the Transaction description column in the Journal transactions (GL301000) window for each journal entry of the Currency management batch, and to the Description column in the Account details (GL404000) window for each Currency management batch. |
| Revaluation total | The total amount of the revaluation. The value is calculated in the base currency. |
The table
This table contains the list of accounts with the balances in the original currency and in the base currency before and after revaluation.
| Column | Description |
|---|---|
| Branch | The branch that uses this account. |
| Account | An account that has records in the selected currency. |
| Description | The description of the account. |
| Subaccount | The subaccount used with the account. This column is available only if the Subaccounts functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Customer | A customer whose balance is maintained in the selected currency on the account shown in the Account column. |
| Customer name | The customer name as it appears in the system. |
| Currency rate type | The rate type to be used for the revaluation. It is specified in the Revaluation rate type customers field in the Currency management preferences (CM101000) window. The rate type can also be specified for a supplier individually in the Currency rate type field in the Suppliers (AP303000) window. |
| Currency rate | The currency rate effective on the date of revaluation. |
| Foreign currency balance | The balance in the selected foreign currency. |
| Original balance | The account balance in the base currency as it is maintained historically. |
| Gain or loss PTD | The period-to-date (PTD) gains or losses accrued on the Customer ledger provisioning account if such an account was specified for the selected foreign currency. |
| Revalued balance | The balance of the account recalculated by using the efficient currency rate. |
| Difference | The difference (in the base currency) between the original (historical) and the revalued balances. |
| Last revaluation period | The period when revaluation was last performed. |