Simulating account balance revaluation

This page allows you to simulate the account balance revaluation. You can provide a unique number identifying the simulation run or allows the system to generate a unique number based on the numbering type. You can retrieve the accounting information by carrying out the search using the code identifying the account, the account group and the account currency of the accounts. The system computes the balances in both base currency and the parallel base currency of the company.

Select the “Simulate Account Balance Revaluation” link under the “Currency Revaluation” business component.

The “Simulate Account Balance Revaluation” page appears.

Enter the following field:

Simulation Run #

A unique number identifying the simulation run (Alphanumeric, 20). This number will be automatically generated if the “Numbering Type” in the “Document Numbering Class” business component for Journal Voucher type is not set to “Manual”. The number is displayed with the corresponding prefix and suffix of the numbering type selected in the “Numbering Type” field. The number is incremented from the last number available in the “Document Numbering Class” business component. This number is generated on simulating the account balance revaluation.

Note: The simulation number is mandatory, if the numbering type is set to manual.

Remarks	Any comments regarding the simulation of the account balance revaluation (Alphanumeric, 256).
Date	The date on which you want to simulate the account balance revaluation (Date Format). The date must be less than or equal to the system date.
Finance Book	Use the drop-down list box to select the code identifying the finance book in which the voucher entries are to be posted. All the finance books mapped to the login organization unit will be available for selection in the ascending order. The system displays the first finance book in the list by default on launch of the page.
Numbering Type	Use the drop-down list box to select the numbering type for the login organization unit and the “Simulation run for Revaluation” transaction voucher type. The numbering types must have already been defined in the “Create Numbering Class” activity of the “Document Numbering Class” business component and must be in “Active” status as on the Transaction date. The system displays the numbering type set as default for the transaction in the “Document Numbering Class” business component.
	You can also select “Manual” if you want to enter a unique voucher number of your own.
Revaluation Period	Use the drop-down list box to select the open financial period in which the account balances are to be revalued. The system displays the earliest open revaluation period by default on launch of the page.

Enter the following fields in the group box:

Account # From	The starting number in the range of account number from which the details are to be retrieved (Alphanumeric, 18). The system retrieves the account codes that are greater than the number specified here.
	If this field is left blank and the “To” field is entered, then the system retrieves from the first account code till the code specified in the “To” field.
	Help facility available.
To	The ending number in the range of account code till which the details are to be retrieved (Alphanumeric, 18). The system retrieves the account codes that are less than or equal to the code specified here. The code entered in this field must be greater than the code specified in the “Account # From” field.
	If this field is left blank and the “Account # From” field is entered, then the system retrieves the account code from the code specified in the “Account # From” field till the last account code.
	Help facility available.

Note: You can enter the account code in full or specify it partially using the ‘*’ character. The system retrieves the account codes that are similar to the value specified.

Account Group	Use the drop-down list box to select the code identifying the group to which the account belongs. The accounts must have been associated to the account group in the “Create Operative Chart of Accounts” activity of the “Accounting Setup” business component. The system lists “Asset”, “Liability” and “All” for selection.
Currency	Use the drop-down list box to select the code identifying the currency. The system lists all the currencies defined in the “Create Currency and Country” activity of the “Organization Setup” business component, except the base currency. The system lists the account currencies of the company. The system lists the first currency in the list by default on launch of the page.

Click the “Get” pushbutton to retrieve the account details in the multiline.

The system displays the following fields in the “Revaluation Information” multiline:

Account #	The code identifying the account.
Currency	The account currency of the account code.

Modify the following field if required:

Note: The exchange rate type must be set for the Asset Account and the Liability account in the “Set Function Defaults” activity of this business component

Exchange Rate

The code identifying the exchange rate of the currency (Alphanumeric, 5). Mandatory. The “Exchange Rate” must have been defined in the “Create Exchange Rate” activity of the “Exchange Rate” business component. The exchange rate specified must be within the tolerance limit.

The system displays the following fields:

Balance In Account Currency	The account balance in the account currency.
Balance In Base Currency	The account balance in the base currency.

Note: The following three fields are displayed on computing the balances.

Revalued Balance In Base Currency	The account balance in the base currency after revaluation. The system calculates the revalued balance in base currency as Balance in Account Currency * Exchange Rate.
Exchange Gain/Loss In Base Currency	The gain or loss in base currency after translation. The system displays the balance in base currency after revaluation due to exchange rate variance. The system displays the difference between the revalued balance in base currency and the balance in base currency.
Exchange Gain/Loss In %	The exchange gain or loss in percentage after computation. The system calculates the exchange gain or loss as follows:
	Exchange gain/loss in % = (exchange gain/loss in base currency / balance in base currency) * 100.
Balance In Parallel Base Currency	The account balance in the parallel base currency.
Revalued Balance In Parallel Base Currency	The account balance in the parallel base currency after revaluation. The system calculates the revalued balance in parallel base currency as Balance in Account Currency * Exchange Rate.
Exchange Gain/Loss In Parallel Base Currency	The gain or loss in parallel base currency after translation. The system displays the balance in parallel base currency after revaluation due to exchange rate variance. The system displays the difference between the revalued balance in base currency and the balance in base currency.
Exchange Gain/Loss In %	The exchange gain or loss in percentage after computation. The system calculates the exchange gain or loss as follows:
	Exchange gain/loss in % = (exchange gain/loss in parallel base currency / balance in parallel base currency) * 100.
Account Description	The textual description pertaining to the account code.

Check the box in the “Select” column of the multiline to mark the account code.

The system calculates the following fields and displays in the multiline:

Balance in Base Currency	The total of the balance in base currency for all the selected accounts in the multiline.
Revalued Balance in Base Currency	The total of the revalued balance in base currency for all the selected accounts in the multiline.
Exchange Gain/Loss In Base Currency	The total of the exchange gain/loss in base currency for all the selected accounts in the multiline.
Balance in Parallel Base Currency	The total of the balance in parallel base currency for all the selected accounts in the multiline.
Revalued Balance in Parallel Base Currency	The total of the revalued balance in parallel base currency for all the selected accounts in the multiline.
Exchange Gain/Loss In Parallel Base Currency	The total of the exchange gain/loss in parallel base currency for all the selected accounts in the multiline.

Click the “Simulate Revaluation” pushbutton to simulate the revaluation entry.

The system saves the simulation run number and its corresponding details.

To proceed, carry out the following

Select the “Attach Notes” link at the bottom of the page to add comment regarding the simulation.