Columns
|
-
From Currency — This displays all the currencies that you selected on the Currency tab in
for all companies in your enterprise.
-
Date — This displays the exchange rate date from Vision Daily Exchange Rates Configuration in
for the exchange rate.
-
Exchange Rate — This column displays the exchange rate from the currency in the
From Currency field to the currency in the
Pivot Currency field. The exchange rate is retrieved from Daily Exchange Rates Configuration for the two currencies.
Because there can be multiple exchange rates with different effective dates for currencies, the rates that are retrieved and displayed in the
Exchange Rates grid are based on the date that you entered in the
Rate Download Exchange Date section on this tab.
Exchange rates are retrieved for the exact date that you specified. If there are no rates for the specific date, an exchange rate with the most recent date that is earlier than the date you entered is used. For example, if the exchange rate dates entered in Daily Exchange Rate Configuration for two currencies are 9/1/2011, 10/1/2011, and 11/1/2011, and you enter 12/1/2011 in the
Rate Download Exchange Date field on this tab, the exchange rate in Daily Exchange Rates Configuration that is dated 11/1/2011 is retrieved for the
Exchange Rates grid. The date of the exchange rate that is retrieved displays in the
Date column of the
Exchange Rates grid.
If no exchange rate is entered in Daily Exchange Rates Configuration between the currencies in the
From Currency and
Pivot Currency fields, Vision looks through the following list and uses the first item it finds to determine an exchange rate:
-
Inverse rates are used if they are available.
Example: Your pivot currency is JPN (Japanese Yen), and you have USD (US dollars) listed in the
From Currency column in the grid. No exchange rate is entered for USD to JPN currency in Vision Daily Exchange Rates Configuration. However, an exchange rate from JPN to USD is entered in Vision Daily Exchange Rates Configuration. The JPN to USD exchange rate will be used to determine the JPN to USD exchange rate that displays in the
Exchange Rate grid. The
Date field in this grid displays the date of the JPN to USD exchange rate from Daily Exchange Rates Configuration.
Example: Your pivot currency is JPN (Japanese Yen), and you have USD (US dollars) listed in the
From Currency column in the grid. No exchange rate is entered for USD to JPN currency in Vision Daily Exchange Rates Configuration. However, an exchange rate from JPN to USD is entered in Vision Daily Exchange Rates Configuration. The JPN to USD exchange rate will be used to determine the JPN to USD exchange rate that displays in the
Exchange Rate grid. The
Date field in this grid displays the date of the JPN to USD exchange rate from Daily Exchange Rates Configuration.
-
The triangulation currency entered on the Currency tab of General Company Settings Configuration is used if one is entered. The most current date between the triangulation currencies that is on or before the date that you specified as the
Rate Download Exchange Date is used.
If you use the Multicompany feature, the triangulation currency is retrieved from the company that you are currently logged on to in Vision.
Example: The pivot currency is JPN, the
From Currency is Bermudian dollar (BMD), and the triangulation currency is the Canadian dollar (CAD). No exchange rates were found for BMD to JPN and vice versa. Both a BMD to CAD and a CAD to JPN exchange rate are entered in Vision Daily Exchange Rate Configuration. These exchange rates are used to determine the exchange rate from BMD to JPN. The
Date field in the
Exchange Rates grid displays the date of the BMD to CAD exchange rate from Daily Exchange Rates Configuration.
If you use the Multicompany feature, the triangulation currency is retrieved from the company that you are currently logged on to in Vision.
Example: The pivot currency is JPN, the
From Currency is Bermudian dollar (BMD), and the triangulation currency is the Canadian dollar (CAD). No exchange rates were found for BMD to JPN and vice versa. Both a BMD to CAD and a CAD to JPN exchange rate are entered in Vision Daily Exchange Rate Configuration. These exchange rates are used to determine the exchange rate from BMD to JPN. The
Date field in the
Exchange Rates grid displays the date of the BMD to CAD exchange rate from Daily Exchange Rates Configuration.
-
If no inverse rates or triangulation currency is found, then an exchange rate cannot be determined; the
Exchange Rate column is blank. In this scenario, you can enter an exchange rate in Daily Exchange Rates Configuration, then return to the Currency Exchange tab, and then click the
Update Rates button.
|