How to use FXR
How to use
In order to use FXR you must enter a date/period or the word SPOT in the search field. Having done so and pressed the OK button, the search results will appear on the grid.
SPOT in the FXR process means most current.
FXR Rules
Spot rates: Spot rates can be defined and/or amended form in FXR. To operate on these rates the entry for the Period/Date field must be the word 'spot'. The rates listed for the currencies when pressing the OK button will be spot rates.
Historical and forward rates: Historical rates can be amended and forward rates can be entered in FXR. For both cases, the entry for the Period/Date field must be a date (e.g. 12 JUN 98). The rates listed for the currencies when pressing the OK button will be the stored historical rates, when a past date is entered, and stored forward rates, when a future date is entered. Entry of new rates is always possible by adding or inserting rows to the grid.
Freezing month end rates: The freezing of month end rates can be done in FXR(P). For this operation, the entry for the Period/Date field must be a period (e.g. JUN 98). The rates listed for the currencies when pressing the OK button will be either the spot rate, if the rates for the given period have not been frozen, or the frozen rates, if freezing has already been done for the given period.
Default values: Upon saving a new currency in the Currency Details Maintenance program (CDM), FXR will assign the default value of 1 for the new currency's exchange rate (the default Rate type is D, Divide).
Position in the grid: The order of currencies in the grid of FXR is alphabetical. When a new code is created in the Currency Details Maintenance program (CDM), it will automatically appear in FXR in its corresponding alphabetical position.
Reporting
From all the Currency programs you can produce currency rate reports. Within FXR you can only request a report before submitting a search by using mouse right click, Report FX Rates. Having selected to produce a report, you will reach a window where you more precisely define what type of report you want. In this reporting window you define: 1) The currencies you wish to include in the report, 2) The type of report you want and 3) Where the report is to be sent to (file, screen or printer). There are four types of reports:
Spot rates: The report lists the spot rates for the currencies defined in the Currencies to Report field. No dates or periods are to be entered in the From To fields for the listing of these rates.
Historical daily rates: The report lists all the currencies that have been amended on the dates entered in the To From date fields. The dates for the historical rates have to be entered in the From To fields in a valid date format.
Month end rates: The report lists all the month end rates (if rates have not been frozen for the entered period, the report lists the current spot rates. When rates have been frozen these will form the report). The period(s) for the month end rates have to be entered in the From To fields in a valid period format.
Tax authority rates: The report lists all the tax authority rates for the currencies defined in the Currencies to Report field. The period(s) for the month end rates have to be entered in the From To fields in a valid period format.
Multiple reporting: Reports that contain more than one type of information from the above-described options can be produced. This is done by ticking the desired combination of report types in the Report Type frame. The result will be a single report that will display per currency the types of rate selected (e.g. if month end and spot rates are requested, for each currency there will be two lines on the report, the first displaying the spot rate and the second displaying the month end rate).
All reports are displayed in the Report Form that has several features to ease the viewing of the report.