Use these fields and options to configure exchange rates from one currency to another currency for a specific period.
Currency Filtering Section
| Field | Description |
|---|
| From Currency and To Currency
|
Use these fields to filter the exchange rates that display in the
Exchange Rates grid on this form.
- To display the exchange rates from one currency to all the other currencies, select a currency only in the
From Currency field, and leave the
To Currency field blank.
- To display the exchange rates to one currency from all the other currencies, select a currency only in the
To Currency field, and leave the
From Currency field blank.
- To display all exchange rates, leave both fields blank.
Filter settings remain in place from one login session to the next. You can change these settings at any time.
|
Period Filtering Section
| Field | Description |
|---|
| Start Period and End Period
|
Use these fields to filter exchange rate records that display in the
Exchange Rates grid on this form by the period that is entered for them in the grid. For example, if you enter 3/2018 in this field and 8/2018 in the
End Period field, only the exchange rate records that fall within those periods display.
You can also filter exchange rate records by entering a period in the
Start Period field and leaving the
End Period field blank. All records from the
Start Period to the present period then display. Likewise, if you enter a period in the
End Period field and leave the
Start Period field blank, all exchange rate records from the earliest period entered in the
Exchange Rates grid up through the period that you entered in the
End Period display in the grid.
You can type the period directly in these period fields, or use the drop-down list to select a period.
|
Exchange Rates Grid Toolbar
| Field | Description |
|---|
| Exchange Rates Drop-down
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
 Insert
|
Click this icon to insert a row and then enter an exchange rate.
|
 Copy
|
Select a row to copy and click this icon to create a new exchange rate from the selected row, then modify the new row.
|
 Delete
|
Select a row and click this icon to delete it from the grid.
|
Exchange Rates Grid
| Field | Description |
|---|
| From Currency
|
Select the From currency. The drop-down list contains the list of currencies that you specified in
.
|
| To Currency
|
Select the To currency. The drop-down list contains the list of currencies that you specified in
.
|
| Period
|
Select the period for which you want to create an exchange rate. Periods are for months.
|
| Average Rate
|
Enter the average rate for that period (month) end, using up to 10 decimals.
|
| End Rate
|
Enter the exchange rate for the period (month) end, using up to 10 decimals.
|
