7.3 Revaluation Adjustments

In the Revaluation Adjustments stage, to arrive at the revalued amount (N_REVALUED_AMOUNT values in the FSI_MGMT_LGR_REVAL_BALANCES table) before initiating the Revaluation execution process, complete the following tasks:

1. Load the FSI_EXCG_RATES table using the insert scripts.

   Note:

   • Ensure that FSI_EXCG_RATES table does not contain duplicate records for the same currency combination for a given MISDATE-EFFECTIVE DATE. If exists, this will lead to runtime exceptions during execution of Revaluation Balances pipeline.
   • The FSI_EXCG_RATE (FIC_MIS_DATE,D_EFFECTIVE_DATE,V_FROM_CCY_CD,V_TO_CCY_CD) table must contain unique records combination to retrieve only one exchange rate.
2. For any balance you arrive at from the Period balance perspective, compare the current exchange rate (N_EXCHANGE_RATE) value in the FSI_EXCG_RATES table against the Period balance present corresponding to the exchange rate in the FSI_MGMT_LGR_REVAL_BALANCES table.
3. The application calculates the following:
   • For AST/LIAB (Assets or Liabilities) type, calculate the adjustment amount using the following formula:

     Current Period YTD Balance x Revaluation Rate – Currency Period YTD Balance LCY

   • For REV/EXP (Revenue or Expenses) type, calculate the adjustment amount using the following formula:

     (Current Period YTD Balance – Prior Period YTD Balance) x Revaluation Rate – (Currency Period YTD Balance LCY – Prior Period YTD Balance LCY)

   Note:

   Revaluation is processed only for the Open fiscal periods.

   In the Revaluation Adjustments stage, Offset GL Account is generated from the SETUP_MASTER table based on whether the entry corresponds to a Gain or Loss account. Then in the Revaluation process execution stage, for each account in the management ledger period balances, the offset balance is generated.