Run Supplier Transaction Revaluation
This page allows you retrieve the account information for revaluation by carrying out the search using the code identifying the account, the account currency of the account code and the control account type and the party code. Tell me more.
Select the “Run Supplier Transaction Revaluation’ link under the “Run Supplier Balance Revaluation” Activity of “Currency Revaluation” business component.
The “Run Supplier Transaction Revaluation” page appears.
Enter the following fields in the “Transaction Details” group box:
Voucher No. |
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. The various statuses of the voucher are
|
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 OUs of the login organization unit’s Company 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). |
|
Zoom facility available. |
Enter the following fields in the “Reversal Voucher Details” group box:
Reversal Voucher No |
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 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 control account types available are "Supplier Control Account", "Supplier Prepayment Account" and "Supplier Deposit Account". The system displays the “Supplier Control Account” by default on launch of the page. |
Account Code 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 Code From” field. |
|
If this field is left blank and the “Account Code From” field is entered, then the system retrieves the account code from the code specified in the “Account Code 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.
Supplier Code From |
The starting code in the range of Supplier Code from which the details are to be retrieved (Alphanumeric, 18). The system retrieves the Supplier Codes that are greater than or equal to the code specified here. |
|
If this field is left blank and the “To” field is entered, then the system retrieves from the first Supplier code till the code specified in the “To” field. |
|
Help facility available. |
To |
The ending code in the range of Supplier code till which the details are to be retrieved (Alphanumeric, 18). The system retrieves the Supplier 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 “Supplier Code From” field. |
|
If this field is left blank and the “Supplier Code From” field is entered, then the system retrieves the Supplier code from the code specified in the “Supplier Code From” field till the last account code. |
|
Help facility available. |
Note: You can enter the Supplier code in full or specify it partially using the ‘*’ character. The system retrieves the Supplier 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:
Transaction OU |
The Organization Unit in which the Transaction has been created. |
Transaction Type |
The Type of Transaction. |
Transaction No. |
The Transaction Number. |
Transaction Date |
The date on which the transaction is created. |
Supplier code |
The Supplier code of the Transaction |
Supplier name |
Supplier to whom the transaction has been created. |
Account Code |
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, 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. |
|
This is the exchange rate to be used for revaluation. |
Modify the following field if required:
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 Code |
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 Code |
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. |
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 Desc. |
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. |
The system displays the following fields in the multiline:
Note No. |
The number identifying supplier account based debit/credit note. |
|
Data Hyperlink available. |
Note Type |
The type of note. It could be "Debit" or "Credit" |
Note No.(Reversal) |
The number identifying reversal supplier account based debit/credit note. |
Note Type (Reversal) |
The type of reversal note. It could be "Debit" or "Credit" |
Adjustment Voucher No. |
The number identifying the adjustment voucher. |
Supplier Code |
The code identifying supplier. |
Currency |
The code identifying currency in which debit/credit note has been created. |
Note: The note details section will be visible when parameter "Auto-generation of Debit/Credit Note during Currency Revaluation" is set as "Yes".
The system displays the following in Note details
Debit Note Numbering Type |
Use the drop down list box to select the numbering type for supplier account based debit note. All the numbering types excluding Manual for transaction type Supplier Account Based Debit Note will be available for selection |
Credit Note Numbering Type |
Use the drop down list box to select the numbering type for supplier account based credit note. All the numbering types excluding Manual for transaction type Supplier Account Based Crebit Note will be available for selection |
Pay Term |
The code identifying the pay term. This pay term must have been defined in the “Create Pay Term” activity of the “Pay Term” business component and must be in “Active” status. |
|
Help facility available |
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 and 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.
Select the “Reverse Supplier Transaction Revaluation” link at the bottom of the page to Reverse the revaluation run.
Select the “View Supplier Transaction Revaluation” link at the bottom of the page to View the revaluation run.
Run Supplier Transaction Revaluation – An overview
This page allows you retrieve the account information for revaluation by carrying out the search using the code identifying the account, the account currency of the account code and the control account type and the party code. The system retrieves the transaction details of the given 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.