Enhancements
New FX Rate Integration script deployment parameters
Effective Date: This will detemine the effective date of the published exhchange rate when the FX rate script gets the exchange rates for the selected currency.
FX Rates Manual Update - Input a value if you want to get the exchange rates for a specific effective date.
FX Rates Scheduled Update - Leave the effective date blank for scheduled updates, the script will get the latest available exchange rates before today based on Central European Time (CET).
Get Exchange Rate: You can choose between two options on which date the FX rate will be based on.
Before Effective Date - exchange rates published a day before the effective date will be used. If the day before falls on a weekend, published rates from the previous Friday will be used.
On or Before Effective Date - exchange rates published on the day or a day before the effective date will be used. If the day before falls on a weekend, published rates from the previous Friday will be used.
Currency Checkboxes (NBP,MNB,ECB) - You can select the currencies that will use the parameters defined in the script deployment record.
The following paramters are not deprecated:
Date Updated
Month Updated
Update First Workday
Sample parameter settings and use cases.
Script parameter: Effective Date | Script parameter: Get Exchange Rate | Published exchange rate date |
|---|---|---|
Empty | Before Effective Date | Date Yesterday (CET) |
Empty | On or Before Effective Date | Date Today (CET) **If the rates are already published when the script runs. |
(Past Date) 28-April-2022 | Before Effective Date | April 27, 2022 |
(Past Date) 28-April-2022 | On or Before Effective Date | April 28, 2022 |
(Future Date) 28-May-2022 | Before Effective Date | Date Today (CET) **If the rates are already published when the script runs. |
(Future Date) 28-May-2022 | On or Before Effective Date | Date Today (CET) **If the rates are already published when the script runs. |