Collapse AllExpand All

13.2.5.  Exchange Rates

Exchange Rates are used to determine the value of foreign Currency—in relation to the base Currency—on a given date. They are also used to convert the value of transactions involving foreign Currencies to the base Currency when the transactions are posted. This conversion to base Currency is required because all transactions posted to the General Ledger (G/L) are posted in base Currency.

Note

You also have the option to import exchange rates from external sources using the API.

To access the master list of Exchange Rates, select the "Exchange Rates" option. The following screen will appear:

Exchange Rates Master List

The Exchange Rates master list displays information on all Exchange Rates. The following options are available:

All Foreign Currencies

Select to display Exchange Rates for all foreign Currencies.

Note

The system will post Exchange Rate variances whenever fluctuating Exchange Rates result in Currency gains or losses. The Currency gain/loss Account is defined on the Configure G/L screen.

Selected

Specify the foreign Currency whose Exchange Rates you want to display.

Pattern

Enter a foreign Currency pattern to select a range of foreign Currencies. Refine your search using Regular Expressions.

Base Currency

Displays the base Currency defined for the database you are connected to.

Start Date

Exchange Rates effective on and after this date will be displayed. This is a required field.

End Date

Exchange Rates effective on and before this date will be displayed. This is a required field.

Foreign Currencies

Display lists valid Exchange Rates for the specified foreign Currencies, using the specified parameters. You can configure the meaning of your Exchange Rate values using the Configure G/L screen in the System module. Exchange Rates may be configured in either of two ways: 1) Base x Exchange Rate = Foreign or 2) Foreign x Exchange Rate = Base.

13.2.5.1. Exchange Rate

To add a new Exchange Rate to the master list of Exchange Rates, select the NEW button. The following screen will appear:

Create New Exchange Rate

When adding a new Exchange Rate to the master list of Exchange Rates, you are presented with the following options:

Currency

Specify the Currency you want to apply the Exchange Rate to. You may enter multiple Exchange Rates for an individual Currency—as long as the effective dates do not overlap.

Exchange Rate

Enter the Exchange Rate to be used for the specified Currency during specified date range. The meaning of the Exchange Rate value is configured on the Configure G/L screen in the System module. The value of Exchange Rates may be configured in either of two ways: 1) Base x Exchange Rate = Foreign or 2) Foreign x Exchange Rate = Base.

Start Date

Enter the date on which the Exchange Rate becomes effective.

End Date

Enter the date after which the Exchange Rate is no longer valid.

Note

You also have the option to import exchange rates from external sources using the API.