BeyondERP.Newsletter
Menu

Setup page · Cost accounting

Exchange rate types

An exchange rate type defines the table of exchange rates and currencies to use.

Used by
Budget manager, Chief financial officer, Accountant and 6 more roles
Business process
Develop currency policies
Menu item
ExchangeRateType
Main table
ExchangeRateType
Data entity
ExchangeRateTypeEntity
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 isAn exchange rate type defines the table of exchange rates and currencies to use.
What you do hereUse this page to set up the sets of exchange rates that are selected on the ledger and on main accounts to convert and translate amounts.
ExampleFor example, the cost accounting ledger uses the Default exchange rate type to convert a UK company's GBP costs into the ledger's USD, while treasury keeps a separate Spot type.
Exchange rate types 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 Exchange rate types1 screen

Use this page to set up the sets of exchange rates that are selected on the ledger and on main accounts to convert and translate amounts.

  1. Screen 1

    Review the exchange rate types

    Go to General ledger > Currencies > Exchange rate types

    1. Find the Default exchange rate type
    2. Select New only if you need another rate type
    1Exchange rate typeDefault
    NameDefault global rate
    Review the exchange rate types (zoomed on the outlined fields)
    Show the full screenReview the exchange rate types
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Cost accounting > Ledger setup > Currencies > Exchange rate types.
  2. Select New.
  3. In the Exchange rate type field, enter an ID for the type.
  4. In the Name field, enter a name.
  5. Select Exchange rates to view or enter the rates for this type.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Exchange rate typeA named group of rates, such as Buy, Sell, Spot or Budget, so two currencies can have different rates for different uses.Microsoft Learn DefaultName
NameThe name shown for the exchange rate type when you choose it on a ledger.Microsoft Learn Default global rateDescription

Common errors and fixes

MessageWhat to do
Amounts from another legal entity aren't convertedCheck that the exchange rate type chosen on the cost accounting ledger has a rate for that currency pair on the accounting date. Microsoft Learn

Test checklist

  1. Open the exchange rate type chosen on the cost accounting ledger.
  2. Check that it has rates for every legal entity currency in the ledger.
  3. Process source data for one period and check that the converted amounts use those rates.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Exchange rate typesA small set of shared types by purpose, for example Buy, Sell, Spot and BudgetExchange rate types are shared across all legal entities and only need to be set up once; each type holds its own rates for the same currency pair.Which exchange rate type should the cost accounting ledger use?Creating company-specific types out of habit. Types are shared, so a change to a type's rates affects every legal entity that uses it.Test: Ledger converts with the chosen rate type

Feature management and licence

Licence or add-inCost accounting has four roles: Cost accounting manager (Activity licence), Cost accountant and Cost accountant clerk (Operations licence), and Cost object controller (Team members licence). In Cost accounting the exchange rate type is chosen on the cost accounting ledger by cost accountants. No Feature management feature needs to be turned on 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
Can it be undoneReversible: Types can be added at any time. The type chosen on a cost accounting ledger converts every legal entity's data in that ledger. Microsoft Learn
If you change it laterExchange rate types are shared across all legal entities, so a change to a type affects every company that uses it. Microsoft Learn
Technical architect

6Technical

Menu itemExchangeRateType Checked in Dynamics 365
FormExchangeRateType Checked in Dynamics 365
TableExchangeRateTypeShown as “EXCHANGE RATE TYPE” in Record infoKey field: NameChecked in Dynamics 365
Data entitiesExchangeRateTypeEntityExchange rate type Microsoft data model
Who can open it

9 security roles. Select a role to see its duties and privileges.

  • RoleBudget managerBudgetBudgetManager
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currency exchange rate typesCurrencyExchangeRateTypesView
  • RoleChief financial officerCompanyChiefFinancialOfficer
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currency exchange rate typesCurrencyExchangeRateTypesView
  • RoleAccountantLedgerAccountant
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currency exchange rate typesCurrencyExchangeRateTypesView
  • RoleAccounting managerLedgerAccountingManager
    • DutyEnable general ledger processLedgerGeneralLedgerProcessEnable
      • PrivilegeMaintain currency exchange rate typesCurrencyExchangeRateTypesMaintain
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currency exchange rate typesCurrencyExchangeRateTypesView
  • RoleAccounting supervisorLedgerAccountingSupervisor
    • DutyEnable general ledger processLedgerGeneralLedgerProcessEnable
      • PrivilegeMaintain currency exchange rate typesCurrencyExchangeRateTypesMaintain
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currency exchange rate typesCurrencyExchangeRateTypesView
  • RoleFinancial controllerLedgerFinancialController
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currency exchange rate typesCurrencyExchangeRateTypesView
  • RoleRental managerRentalManager
    • DutyEnable general ledger processRentalLedgerGeneralLedgerProcessEnable
      • PrivilegeMaintain currency exchange rate typesCurrencyExchangeRateTypesMaintain
  • RoleRental purchasing managerRentalPurchasingManager
    • DutyEnable general ledger processRentalLedgerGeneralLedgerProcessEnable
      • PrivilegeMaintain currency exchange rate typesCurrencyExchangeRateTypesMaintain
  • RoleRental sales managerRentalSalesManager
    • DutyEnable general ledger processRentalLedgerGeneralLedgerProcessEnable
      • PrivilegeMaintain currency exchange rate typesCurrencyExchangeRateTypesMaintain
Checked in Dynamics 365
Roles to set it up and use itTo use itInquire into general ledger reference data LedgerGeneralLedgerReferenceDataInquireGive people a role that holds these duties. On this system, 9 roles give access to this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Exchange ratesChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ExchangeRateType
Integrate withExchangeRateTypeEntity data entity Microsoft data model
Data migrationExchangeRateTypeEntity (Exchange rate type): shared by all companies.Load order: Not part of Microsoft's default configuration templates. Load the exchange rate types before the Exchange rates entity, which template 010 - System Setup loads at execution unit 1, level 10, sequence 20, because every rate belongs to a type.Microsoft Learn
Table definitionExchangeRateType columns and relations Microsoft data model
Everyone

8Sources