Run supplier balance revaluation

This page allows you to reinstate the supplier balances. Tell me more.

Select the “Run Supplier Balance Revaluation” link under the “Currency Revaluation” business component.

The “Run Supplier Balance Revaluation” page appears.

Enter the following field:

Voucher #

A unique number identifying the journal voucher, raised after revaluation (Alphanumeric, 18). 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 running the Supplier balance revaluation. The numbering type must be in “Active” status as on voucher date.

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

The system displays the following:

Status	The status of the voucher. You can select from
	Authorized – The status of the voucher on running the Supplier balance revaluation. The system updates the status to “Authorized” on clicking the “Run Revaluation” pushbutton.
	Reversed – Indicates that the voucher entries are reversed. The vouchers can be reversed in the “Reverse Supplier Balance Revaluation” activity of this business component.
Voucher Date	The revaluation date which refers to the selected revaluation period end date. The system defaults the last date of the selected open revaluation period.

Enter the following fields:

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 “Currency revaluation Journal Voucher” transaction voucher type, which is of reversal 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 voucher 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.
Remarks	Any remarks pertaining to the Supplier balance revaluation (Alphanumeric, 255).

Enter the following fields in the “Reversal Voucher Details” group box:

Reversal Voucher #	A unique number identifying the reversal voucher (Alphanumeric, 18). This number will be automatically generated if the “Numbering Type” in the “Document Numbering Class” business component 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.
	The reversal voucher number is generated on creating the voucher.
Reversal Numbering Type	Use the drop-down list box to select the numbering type for the login organization unit and the “Currency revaluation voucher” 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 Reversal 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 reversal voucher number of your own.

The system displays the following:

Reversal Date

The date on which the voucher is reversed. The system displays the first date of the subsequent revaluation period.

Note: The voucher date and the reversal voucher date must fall within the effective period of the account code.

Enter the following fields in the “Search Criteria” group box to search for the account code details.

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.

Note: If the process parameter “Currency Revaluation Completeness Check before Closure” has been set to “Yes”, then it is mandatory to run revaluation for every financial period. Revaluation will need to be done for all the financial periods in a financial year.

If the process parameter is set to “No”, then revaluation can be done for any of the open financial periods. For example, if there are three periods in the financial year and the revaluation entries can be passed in the period two, without revaluation run for Period one. However, period one will be locked and the revaluation entries cannot be passed in it unless revaluation of period two is reversed.

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 first currency in the list by default on launch of the page.
	All account currencies of the company, other than Base currency of the company is listed for selection.
Control Account Type	Use the drop-down list box to select the control account type to which the account you want to retrieve belongs. The system lists the options “All”, "Supplier Deposit A/C", "Supplier Prepayment A/C" and "Supplier Payable A/C". If “All” is selected, the system retrieves and displays all the Account Codes of "Supplier Deposit A/C", "Supplier Prepayment A/C" and "Supplier Payable A/C". The system displays “All” by default on launch of the page.
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.

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

The system displays the following 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 Supplier control account, the Supplier prepayment account and the supplier deposit account in the “Set Function Defaults” activity of this business component.

Exchange Rate	The code identifying the exchange rate of the currency (Alphanumeric, 8). 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.
	This is the exchange rate to be used for revaluation.

The system displays the following:

Balance In Account Currency	The balance amount in the account currency of the account, which is being revalued.
Balance In Base Currency	The balance amount in the base currency of the account code.

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

Revalued Balance In Base Currency	The balance in the base currency after revaluation of the currency. The system calculates the revalued balance in base currency as Balance in Account Currency * Exchange Rate.
Exchange Gain/Loss In Base Currency	The exchange gain or loss in base currency balance 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.
	The exchange gain or loss is determined on the following basis, if due to exchange rate variance, value of liability of the company increases or assets of the company decreases, then it is treated as “Exchange loss” and if it reduces the liability or increases the assets of the company, then it is treated as “Exchange gain”.
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.

Enter the following fields:

Cost Center	The cost center to which the entries must be posted (Alphanumeric, 10). Data-entry in this field is mandatory if the account code has been mapped to a cost center in the “Cost Setup” business component.
	Help facility available.
Analysis #	The analysis code to which the selected account is mapped in the "Assign Analysis Code" activity of the "Account Based Budgeting" business component (Alphanumeric, 5).
	Help facility available.
Sub Analysis #	The sub-analysis code, which is mapped to the analysis code in the "Assign Sub Analysis Code" activity of the "Account Based Budgeting" business component (Alphanumeric, 5).

The system displays the following:

Balance In parallel Base Currency	The balance amount in the parallel base currency of the account code.
Revalued Balance In Parallel Base Currency	The balance in the parallel base currency after revaluation of the currency. 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 exchange gains or loss in parallel base currency balance after translation. The system displays the balance in parallel base currency after revaluation. The system also displays the difference between the revalued balance in base currency and the balance in base currency, which is due to exchange rate variance.
	The exchange gain or loss is determined on the following basis, if due to exchange rate variance, value of liability of the company increases or assets of the company decreases, then it is treated as “Exchange loss” and if it reduces the liability or increases the assets of the company, then it is treated as “Exchange gain”
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.

Note: Atleast one row in the multiline must be marked for computing the balance.

The system revalues the balance in account currency to base currency at the exchange rate specified.

The system computes the exchange gain or loss in base currency on amount basis and on percentage basis.

The system also computes the revalued balance in Parallel base currency, the exchange gain/loss on amount basis and exchange gain/loss in percentage.

The system calculates the following 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 “Run Revaluation” pushbutton to run the Supplier balance revaluation.

The system generates a unique voucher number, if the numbering type is not set to “Manual” and posts an entry in the finance book.

The system updates the status of the voucher to “Authorized”.

The system updates the status of the account code to “Revalued” for the revaluation period for which the revaluation entry has been passed.

The system automatically passes a reversal entry for the voucher generated, on the first day of the succeeding financial period and generates a unique reversal voucher number.

The system updates the login ID of the user to the created by and the system date to the created date.

The system computes and displays the value in base currency.

The system computes and displays the value in parallel base currency.

The system computes the total and displays in the multiline.

The system retrieves the account code and its identifier from the “Account Rule Definition” business component based on the event and the usage for accounting the “Revaluation Gain” or “Revaluation Loss” in the finance books.

The system displays the following:

Created By	The login ID of the user who revalued the Supplier balance adjustment.
Created Date	The date on which the Supplier balance adjustment was revalued.

To proceed, carry out the following

Select the “Accounting Information” link at the bottom of the page to view the accounting information details.
Select the “Attach Notes” link at the bottom of the page to attach notes.

Run Supplier balance revaluation – An overview

The Supplier revaluation is done for a specific finance book, currency, and financial period. The financial period is always the earliest open financial period. Once a revaluation has been run in an open financial period, revaluation cannot be run for any prior open financial periods in the financial year. This revaluation voucher automatically reverses the entry passed during revaluation period in the next open financial period. Refer Example.

This page allows you to enter a unique voucher number or allow the system to generate a unique number by specifying the numbering type. You can specify the code identifying the finance book in which the accounting entries are to be posted and a comment pertaining to generating the voucher. You can specify the number for the reversal voucher or the system will automatically generates a number based on the numbering type specified. You can retrieve the account information by carrying out the search using the code identifying the account, the account currency of the account code and the control account type. The system retrieves the account code along with their currency. You can also modify the exchange rate within the tolerance limit before revaluation. The system computes the revalued balances both in base currency and the parallel base currency. This page also allows you to capture the analysis and the sub-analysis code for the account. This page also allows you to capture cost center code for the account code, if mapping exists with ‘Cost Center Setup” business component.

The system updates the status of the voucher to “Authorized” on running revaluation. The system automatically reverses the entries passed during the revaluation period, in the next open financial period. The system generates the number identifying the voucher and the reversal voucher. The system updates the login ID of the user to the created by and the system date to the created date.

Example

Period	Transaction	Amount	Exchange Rate	In Base Currency
I	Invoice	$1000	45	45,000
I	Reinstatement		50	5,000
	Balance end of period I			50,000
II	Reversal			45,000 (50,000 – 5,000)
II	Payment	$1000	46	46,000

There is an exchange loss of 1,000, which is booked.

Prerequisites

“Finance Book” must have been defined in the “Create Finance Book” of the “Organization Setup” business component.
“Numbering Type” must have been defined in the “Create Numbering Class” of the “Document Numbering Class” business component.
“Currency” must have been defined in the “Create Currency and Country” of the “Organization Setup” business component.
“Exchange Rate” must have been defined in the “Create Exchange Rate” of the “Exchange Rate” business component.
“Account #” must have been defined in the “Create Operative Chart of Account” of “Accounting Setup” business component.
“Account #” must have been mapped to the Finance book in the “Attach/Detach Operative Chart of Accounts – Finance Book” in “Accounting Setup” business component.
“Financial Year” and “Financial Period” must be defined in the “Create Calendar” activity of the “Accounting Setup” business component.