BeyondERP.Newsletter
Menu

Setup page · Human resources

Currency exchange rates

The page that holds exchange rates for currency pairs under each exchange rate type.

Used by
Budget manager, Chief financial officer, Compensation and benefits manager and 7 more roles
Business process
Develop currency policies
Menu item
ExchangeRate
Main table
ExchangeRateCurrencyPair
Data entity
ExchangeRateCurrencyPairEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isThe page that holds exchange rates for currency pairs under each exchange rate type.
What you do hereUse this page to select an exchange rate type, add currency pairs, and enter the rates that apply for each period.
ExampleFor example, BEAT pays its UK staff from a GBP grade grid and values stock units in USD; the compensation and benefits manager adds the pair USD to GBP under the Default rate type with 0.7900 from 1 January 2026 and a new line with 0.7700 from 1 July 2026 instead of overwriting, so a conversion dated 15 March 2026 still uses 0.7900.
Currency exchange rates page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Currency exchange rates1 screen

Use this page to select an exchange rate type, add currency pairs, and enter the rates that apply for each period.

  1. Screen 1

    Enter the exchange rate

    Go to General ledger > Currencies > Currency exchange rates

    1. Select the Default exchange rate type
    2. Select New and enter the from and to currencies
    3. Under Add or remove exchange rates, select Add and enter the rate for 10/14/2026
    1From currencyEUR
    2To currencyUSD
    Exchange rate typeDefault
    Exchange rate1.0850
    Enter the exchange rate (zoomed on the outlined fields)
    Show the full screenEnter the exchange rate
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Human resources > Compensation > Currency exchange rates.
  2. Select the Exchange rate type.
  3. Enter a new currency pair, or select the pair to change.
  4. Add a new line with a Start date and the rate, instead of changing an existing rate.
  5. In the Conversion factor field, enter how many units of the From currency the rate converts, usually 1 or 100.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Exchange rate typeThe group of rates being maintained, such as buy, sell, spot or budget.Microsoft Learn Default
Start dateThe date a rate starts to apply; each transaction uses the latest rate dated on or before it.Microsoft Learn ValidFrom
Conversion factorHow many units of the From currency the rate converts to the To currency.Microsoft Learn ExchangeRateDisplayFactor
From currencyThe currency converted from.Microsoft Learn USDFromCurrencyCode
To currencyThe currency converted to.Microsoft Learn GBPToCurrencyCode
Exchange rateThe rate for the pair from the start date, for the number of From currency units in the conversion factor.Microsoft Learn 0.7900ExchangeRate

Common errors and fixes

MessageWhat to do
Saving GBP to USD is refused because exchange rates are already defined between the two currencies for the rate typeA pair can exist only once per rate type and reciprocal rates can't be entered; the reverse rate is calculated automatically. Keep the existing pair and add a dated line to it. Microsoft Learn
An old rate is used for a recent dateThe rate with the latest start date before the date is used. Add a new line with the new start date. Microsoft Learn

Test checklist

  1. Add USD to GBP with 0.7900 from 1/1/2026 and 0.7700 from 7/1/2026.
  2. Try to add GBP to USD for the same rate type and check it is refused.
  3. Check the pair shows two lines and the line used for 3/15/2026 is 0.7900.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Currency exchange ratesAdd a new dated rate for each change rather than overwriting the old one; Conversion factor 1 or 100The system uses the latest start date before each transaction date, so keeping dated history keeps past rates traceable. Most organizations use a conversion factor of 1 or 100.How should exchange rates be kept up to date?Entering both directions of a pair (USD to EUR and EUR to USD) for one rate type. It is refused; the system calculates the reciprocal rate itself.Test: Rate converts legal entity costs

Feature management and licence

Licence or add-inCompensation and benefits managers keep the rates their plans and grids need; the page is the same shared list that General ledger users maintain. No Feature management feature is needed for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
If you change it laterA saved rate is used at once for transactions in its date range, in every legal entity. A reverse pair, such as EUR to USD when USD to EUR exists, can't be entered for the same rate type. Microsoft Learn
Technical architect

6Technical

Menu itemExchangeRate Checked in Dynamics 365
FormExchangeRate Checked in Dynamics 365
TableExchangeRateCurrencyPairShown as “EXCHANGE RATE CURRENCY PAIR” in Record infoKey field: FromCurrencyCode, ToCurrencyCode, ExchangeRateType_NameChecked in Dynamics 365
Data entitiesExchangeRateCurrencyPairEntityExchange rate currency pair Microsoft data model ExchangeRateEntityExchange rates (The dated rates of each currency pair.) Microsoft data model
Who can open itPrivilegesMaintain currency exchange rates CurrencyExchangeRatesMaintainexchange rate report -ViewCurrencyCurrentExchangeRates: CurrencyExchangeRatesViewDutiesEnable budget process BudgetBudgetProcessEnableEnable compensation process HcmCompensationProcessEnableEnable general ledger process LedgerGeneralLedgerProcessEnableInquire into general ledger reference data LedgerGeneralLedgerReferenceDataInquireEnable general ledger process RentalLedgerGeneralLedgerProcessEnable
10 security rolesBudget manager BudgetBudgetManagerChief financial officer CompanyChiefFinancialOfficerCompensation and benefits manager HcmCompensationAndBenefitsManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental sales manager RentalSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itCompensation and benefits manager HcmCompensationAndBenefitsManagerBudget manager BudgetBudgetManagerAccounting manager LedgerAccountingManagerRental sales manager RentalSalesManagerRental purchasing manager RentalPurchasingManagerTo use itChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive people one of these roles. On this system, 10 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ExchangeRate
Integrate withExchangeRateCurrencyPairEntity data entity Microsoft data model
Data migrationExchangeRateCurrencyPairEntity Exchange rate currency pair: the pair and rate type. Shared by all companies.ExchangeRateEntity Exchange rates: the dated rates of each pair. Shared by all companies.Load order: Load after the currencies and exchange rate types the pairs name; then the dated rates. Rates can also be brought in with Import currency exchange rates from a provider.Load first: CurrencyEntity, ExchangeRateTypeEntityMicrosoft Learn
Table definitionExchangeRateCurrencyPair columns and relations Microsoft data model
Everyone

8Sources