Contents of the Print Exchange Rates Report Screen

Use the fields and options to configure the Print Exchange Rates Report screen.

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Select By

Field Description
Start

Select Date to base the report on exchange rate information entered on the Manage Daily Exchange Rates screen or Manage Exchange Rates by Date screen. You will find this version of the report useful if you keep daily track of currency rates.

Select Period to base the report on exchange rate information entered on the Manage Period Exchange Rates screen or Manage Exchange Rates by Period screen. You will find this version of the report useful if you keep periodic track of currency rates.

Dates

Field Description
Option

Select the range of dates to include from the drop-down list. The options are:

  • All: Select this option to include all dates. The Start and End fields are disabled for this option. This is the default.
  • One: Select this option to include only one date and enter that date in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of dates. Enter the beginning date for the range in the Start field and enter the ending date of the range in the End field.
  • From Beginning: Select this option to include a range of dates that begins with the first of all the available dates and ends with the date that you enter in the End field. The Start field is disabled for this option.
  • To End: Select this option to include a range of dates that begins with the date that you enter in the Start field and ends with the last of all the available dates. The End field is disabled for this option.
Start/End

Enter, or click to select, the starting date, ending date, or both for the range of dates to be included on the report. Depending on your selection in Option, one or both of these fields may be inactive.

Rate Group

Field Description
Option

Select the range of rate groups to include from the drop-down list. The options are:

  • All: Select this option to include all rate groups. The Start and End fields are disabled for this option. This is the default.
  • One: Select this option to include only one rate group and enter that rate group in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of rate groups. Enter the beginning rate group for the range in the Start field and enter the ending rate group of the range in the End field.
  • From Beginning: Select this option to include a range of rate groups that begins with the first of all the available rate groups and ends with the rate group that you enter in the End field. The Start field is disabled for this option.
  • To End: Select this option to include a range of rate groups that begins with the rate group that you enter in the Start field and ends with the last of all the available rate groups. The End field is disabled for this option.
Start/End

Enter, or click to select, the starting rate group, ending rate group, or both for the range of rate groups to be included on the report. Depending on your selection in Option, one or both of these fields may be inactive.

Fiscal Year

Field Description
Start

Enter, or click to select, the fiscal year for which the exchange rate information will be reported.

Period

Field Description
Option

Select the range of periods to include. The options are:

  • All: Select this option to include all periods for the fiscal year. The Start and End fields are disabled for this option. This is the default.
  • One: Select this option to include only one period and enter that period in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of periods. Enter the beginning period for the range in the Start field and enter the ending period of the range in the End field.
  • From Beginning: Select this option to include a range of periods that begins with the first of all the available periods for the fiscal year and ends with the period that you enter in the End field. The Start field is disabled for this option.
  • To End: Select this option to include a range of periods that begins with the period that you enter in the Start field and ends with the last of all the available periods for the fiscal year. The End field is disabled for this option.
Start/End

Enter, or click to select  the starting period, ending period, or both for the range of periods to be included on the report. Depending on your selection in Option, one or both of these fields may be inactive.

Currency From

Field Description
Option

Select the range of From currencies to include from the drop-down list. The options are:

  • All: Select this option to include all currencies. The Start and End fields are disabled for this option. This is the default.
  • One: Select this option to include only one currency and enter that currency code in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of currencies. Enter the beginning currency code for the range in the Start field and enter the ending currency code of the range in the End field.
  • From Beginning: Select this option to include a range of currencies that begins with the first of all the available currency codes and ends with the currency code that you enter in the End field. The Start field is disabled for this option.
  • To End: Select this option to include a range of currencies that begins with the currency code that you enter in the Start field and ends with the last of all the available currency codes. The End field is disabled for this option.
Start/End

Enter, or click to select, the starting currency code, ending currency code, or both for the range of From currencies to be included on the report. Depending on your selection in Option, one or both of these fields may be inactive.

Currency To

Field Description
Option

Select the range of To currencies to include. The options are:

  • All: Select this option to include all currencies. The Start and End fields are disabled for this option. This is the default.
  • One: Select this option to include only one currency and enter that currency code in the Start field. The End field is disabled for this option.
  • Range: Select this option to include a contiguous range of currencies. Enter the beginning currency code for the range in the Start field and enter the ending currency code of the range in the End field.
  • From Beginning: Select this option to include a range of currencies that begins with the first of all the available currency codes and ends with the currency code that you enter in the End field. The Start field is disabled for this option.
  • To End: Select this option to include a range of currencies that begins with the currency code that you enter in the Start field and ends with the last of all the available currency codes. The End field is disabled for this option.
Start/End

Enter, or click to select, the starting currency code, ending currency code, or both for the range of To currencies to be included on the report. Depending on your selection in Option, one or both of these fields may be inactive.

Sort By

Field Description
1st Sort

Select the primary method of sorting data on your report. The options are:

  • Period
  • Date
  • Rate Group
  • Currency From
  • Currency To
Page Break

Select this check box if you want a page break before each new primary sort item.

2nd Sort

Select the secondary method of sorting data on your report. The options are:

  • None
  • Period
  • Date
  • Rate Group
  • Currency From
  • Currency To

Options

Field Description
Print Notes

Select this check box to print notes entered on the Manage Exchange Rates by Date, Manage Exchange Rates by Period, Manage Daily Exchange Rates, and Manage Period Exchange Rates screens.

Generate the Exchange Rates Report

To generate the Exchange Rates report, enter the report options you want and then click on the Costpoint toolbar.