Period Exchange Rates Form

Use the Period Exchange Rates form of General System Setup to configure exchange rates from one currency to another currency for a specific period.

If your firm uses multiple companies, the available currencies are limited to those enabled for the active company.

Location

To display the form:

From the Vision Navigation menu, click Configuration > General > Period Exchange Rates.

Contents

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 File > Print 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 Configuration > General > Company Settings.
To Currency	Select the To currency. The drop-down list contains the list of currencies that you specified in Configuration > General > Company Settings.
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.