Exchange Rates List

Access this report using Reports>Exchange Rates.

Use this report to print a list of exchange rates which were set up using the Maintain>Multicurrency>Exchange Rates form.

 

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Use this tab to determine what data to include in the report and to define the report layout.

• By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
• By selecting Available Columns, the data that appears in the body of the report is determined.

Column	Description
Rate Type	The exchange rate type, such as DSR, MAR, or a custom rate type.
Currency ID	The currency code, such as USD, CAD, EUR, GBP, MXN, or any custom currency code created.
Rate Type Description	The description associated with the rate type, such as Daily Spot Rate, Monthly Average Rate, or Custom Rate.
Currency Description	The description associated with the currency code, such as US Dollar, Canadian Dollar, Euro, Pound Sterling, or Mexican Peso.
Active Date	The date the exchange rate value is active.
Current Exchange Rate	The exchange rate as of the date and time the report is run. If the Exchange Rate is inactive or discontinued, the value in this field is 0.00.
Exchange Rate	The exchange rate of the designated currency.
Exchange Rate Restated	The reciprocal of the exchange rate (1/exchange rate).
Expiration Date	The date on which the exchange rate value expires.
Source	The place where the exchange rate information was obtained.
Entered By	The user ID that modified the data last.
Entry Date	The date and time the data was last modified.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to change the font and page setup for a report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.