Exact Date Match Processing Option

The Calculate Cross Currency Rates program (R11153) has a processing option that you can set to require the system to locate an exact date match before it calculates exchange rates based on the currency cross-rate relationships that you entered.

If you set the processing option to require an exact date match, the system calculates an exchange rate only if the effective date for the from and to currencies matches the date in the processing option. If you have from and to currencies for which you want to make an exception, you do not have to change the processing option and run the program separately. Instead, you can override the processing option by setting up codes in which an exact date is not required in UDC table 11/CS.

Assume that the company policy requires an exact date match to calculate all currency cross-rates except for the MXP to COP exchange rate. To manage this exception, you can set up two concatenated codes in the UDC table:

• MXPUSD: For the MXP to USD cross-rate relationship.

• USDCOP: For the USD to COP cross-rate relationship.

When you run the Calculate Currency Cross Rates program, you enter June 30 for the date to create rates and require an exact date match in the processing options. No exchange rates exist in the F0015 table for MXP to USD and USD to COP with an effective date of June 30. The most recent effective date is June 28. The system uses the rates associated with that date to calculate the MXP to COP exchange rate. The system overrides the exact date match processing option because the cross-rate relationships for MXP to COP are set up in UDC table 11/CS.