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.
|
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.