2.1.1.2 FX Rate revaluation

This topic describes about the Procedure to fix FX rate between transaction currency and facility currency.

The system allows to fix a rate between a Transaction Currency and a Facility Currency in addition to maintaining the rates for utilization transaction at Parameter level in the Config service. User can provide a fixed rate or maintain a set of parameters like rate type and rate indicators to derive the rate pick up based on these parameters.

  1. Click Next in previous data segment to proceed with the next data segment, after successfully capturing the data.
    The FX Rate revaluation screen is displayed.
  2. Click Add, the FX Rate revaluation screen displays.

    Table 2-3 Rate Code Parameters For FX Rate revaluation - Field Description

    Field Description
    Module Click the Search icon and select the associated module from the adjoining option list. This is based on Product Maintenance setup.
    Product Code Displays the product code based on the module selected.

    This can be modified during facility maintenance using this line code template. This again is based on Product Maintenance setup.

    Currency Code Click the Search icon and select the valid currency code. The Currency Code cannot be same as Line Currency.
    Rate Input Method Select the rate input method from the drop down list. The following options are:
    • Fixed - The system will pick the fixed rate provided at the FX level at facility.
    • Derived - Based on Exchange Rate Code, FX Rate Type, and Rate Fixing Days provided, the system will derive the rate

    The system evaluates only those contracts for which Rate Agreement Required and revaluationuation Required are selected.

    The Next revaluation Date is updated as today's date for each contract. After one EOD process, Next revaluation Date is updated based on the revaluation Frequency, revaluation Effective Date and Holiday Treatment selected at the facility level.

    After the End Of Day process, the system evaluates the facility with the modified values for fixed and derived rate input method type.

    Revaluation Frequency Select the revaluation Frequency type from the drop down list. The available options are:
    • Adhoc
    • None
    Fixed Rate Specify the fixed rate.

    Fixed Rate field entry is required, if the Rate Input Method is Fixed.

    The system throws an error, if Fixed Ratehas a value and Rate Input Method is Derived.

    Exchange Rate Code Click the Search icon and select the exchange rate code. These rate codes are picked from the Currency Rate Type Definition maintenance screen.

    The Exchange Rate Code field entry is mandatory, if the Rate Input Method is Derived. The rate defined in Currency Exchange Rate maintenance for specified rate code and rate type will be considered during revaluation.

    The system throws error, if the Exchange Rate Code has a value and Rate Input Method is Fixed

    Foreign Exchange Rate Type Select the type from the drop down list. The available options are:
    • Mid
    • Sell
    • Buy

    The rate defined in Currency Exchange Rate maintenance for specified rate code and rate type will be considered during revaluationuation.

    Revaluation Effective Date Select the revaluation effective date from the drop-down list. The available options are:
    • Calendar Date
    • Value Date
    In case of Calendar Date, next revaluation date will be set as the date in which first utilization transaction is made. After one EOD, next revaluation date will be set as 1st of next month irrespective of the revaluation frequency provided. After one more EOD, the system will update the next revaluation date based on 1st of the month + frequency.

    For example: If utilization transaction is made on 31st July, next revaluation date is set as 31st July. After one EOD, next revaluation date will be 1st August. If the Frequency is Weekly, post another EOD, next revaluation date will be updated as 8th Aug. If Frequency is Monthly, post another EOD, next revaluation date will be updated as 1st September and so on.

    In case of Value Date, next revaluation date will be set as the date in which first utilization transaction is made. After one EOD, the system updates the next revaluation date based on frequency provided.

    For example: If utilization transaction is made on 31st July, next revaluation date is set as 31st July. If Frequency is Weekly, post one EOD, next revaluation date will be updated as 7th August. If Frequency is Monthly, post one EOD, next revaluation date will be updated as 31st August and so on.

    Rate Fixing Days Specify the rate fixing days. The allowed values are 0-5. The system will pick up the rate from exact / nearest available date from the Currency Exchange Rates maintenance or History of Currency Exchange Rates Input screen.

    For example: The system date is 22th November 2024, T-2 is provided at the facility level, Currency Exchange Rates Input is available for 20th November and History rates are available for 19th November. In this case, the system will pick up the rate from Current Exchange Rates Input as 20th November.

    Revaluation Frequency Select the frequency from the drop-down list. The available options are:
    • Daily
    • Weekly
    • Monthly
    • Quarterly
    • Half Yearly
    • Yearly
    • Ad Hoc
    • None

    Ensure to select revaluation Frequency, if user have selected revaluation Required and Rate Agreement Required check boxes in the Line Code Maintenancescreen or directly at the Facility level.

    Adhoc - Fixed rates are evaluated only on modification of rate at facility level. So, the frequency for fixed rates are maintained as Ad Hoc

    None - If user need to suppress currency revaluation for a certain combination of Module, Product Code and Currency Code, then None can be selected as the Frequency.

    For Daily, Weekly, Monthly, Quarterly, Half Yearly, and Yearly, next revaluation date is computed based on the Frequency selected.

    Note: revaluation frequency supported for Fixed rate input method are ADHOC and NONE. For Derived revaluation frequency except ADHOC rate input method all other are supported.

    Ignore Holidays

    Switch to On, where the holiday treatment is not applied to calculate the next revaluation date.

    Switch to Off, where the holiday preferences settings are validated.

    Holiday Check Select the holiday check from the drop-down list. The available options are:
    • Currency
    • Local
    • Both
    If holiday treatment is applicable, then you can select Local, Currency, or Both based on your holiday maintenance.

    If Both is selected and Branch or Currency is holiday, then holiday processing setting is considered.

    Holiday Currency Click the Search icon and select the holiday currency from the list, if holiday check is maintained as Currency or Both.
    Schedule Movement Select the movement from the drop-down list. The available options are:
    • Move Forward - In case calculated next revaluation date is holiday, then date must be moved forward. In this scenario, next revaluation date moves to 1st September which is next working date.
    • Move Backward - In case calculated next revaluation date is holiday, then date must be moved backward. In this scenario, next revaluation date moves to 30th August which is previous working date.
    Move Across Month

    Switch to On to move the date to next month.

    Switch to Off to avoid moving the date to next month.

    For more information, refer Example.

    In the above mentioned example, if Move Across Month is selected, then the system moves next revaluation date to 1-September. If Move Across Month is not selected, then the system changes next revaluation date to 30-August.

    Cascade Schedules

    Switch to On to calculate the next date based on the previous schedule date(as part of schedule movement) instead of the start date.

    Switch to Off to avoid calculate the next date.

    Table 2-4 Working Days - Holiday Treatment

    Working Day 30-August
    Holiday 31-August
    Schedule Movement Move Forward
    Calculated next revaluation date 31-August
  3. Click Save and Close to save the record.