BeyondERP.Newsletter
Menu

Setup page · Cost accounting

Currencies

The list of currencies, each with its own name, symbol, and currency code.

Used by
Budget clerk, Budget manager, Chief financial officer and 12 more roles
Business process
Develop currency policies
Menu item
Currency
Main table
Currency
Data entity
CurrencyEntity
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 list of currencies, each with its own name, symbol, and currency code.
What you do hereUse this page to maintain currency attributes, such as which currency is the reference currency for triangulation and the currency gender printed on checks and reports.
ExampleFor example, the cost accounting ledger records amounts in USD, so USD must exist here with its rounding rule before the ledger's accounting currency can be chosen.
Currencies 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 Currencies1 screen

Use this page to maintain currency attributes, such as which currency is the reference currency for triangulation and the currency gender printed on checks and reports.

  1. Screen 1

    Set up the currency

    Go to General ledger > Currencies > Currencies

    1. Select New and enter the currency code and name
    2. On the Rounding rules FastTab, enter the general rounding rule
    1Currency codeEUR
    2NameEuro
    3General rounding rule0.01
    Set up the currency (zoomed on the outlined fields)
    Show the full screenSet up the currency
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Cost accounting > Ledger setup > Currencies > Currencies.
  2. Select the currency the cost accounting ledger will use, or select New to add it.
  3. Enter the Currency code, Name and Symbol.
  4. Set the General rounding rule.
  5. Set Reference currency for triangulation only on the one currency used for triangulation.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Currency genderFor Spanish-speaking countries, the gender of the currency name printed on checks and reports; Masculine means no gender.Microsoft Learn
Reference currency for triangulationMarks the one currency, EUR by default, used as the go-between when converting other currencies.Microsoft Learn IsEuro
Currency codeThe ISO code of the currency, used on ledgers, exchange rates and transactions.Microsoft Learn USDCurrencyCodeISO
NameThe name shown for the currency.Microsoft Learn US DollarTxt
General rounding ruleThe smallest unit amounts in this currency are rounded to.Microsoft Learn 0.01RoundingPrecision

Common errors and fixes

MessageWhat to do
The triangulation option can't be set on a second currencyOnly one currency can be the reference currency for triangulation. Clear it on the current one first. Microsoft Learn

Test checklist

  1. Check the currency to be used as the cost accounting ledger's accounting currency exists, with its name and symbol.
  2. Create a cost accounting ledger and select that currency in Accounting currency with an exchange rate type.
  3. Check only one currency has Reference currency for triangulation selected.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up CurrenciesExactly one currency marked Reference currency for triangulation (EUR by default)Only one currency can be the triangulation currency; EUR is selected by default.Which currency should the cost accounting ledger record amounts in?Trying to mark a second triangulation currency without first clearing the flag on EUR.Test: Ledger currency rounds as set up

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 currency 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: Currency settings can be changed. Only one currency can be the reference currency for triangulation; to move it, first clear Reference currency for triangulation on the current currency (EUR by default) and then select it on the new one. Microsoft Learn
If you change it laterCurrencies are shared by every legal entity. A cost accounting ledger converts each legal entity's amounts into its own accounting currency, so the ledger currency applies to every converted entry. Microsoft Learn
Technical architect

6Technical

Menu itemCurrency Checked in Dynamics 365
FormCurrency Checked in Dynamics 365
TableCurrencyShown as “CURRENCY TABLE” in Record infoKey field: CurrencyCodeChecked in Dynamics 365
Data entitiesCurrencyEntityCurrencies Microsoft data model
Who can open it

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

  • RoleBudget clerkBudgetBudgetClerk
    • DutyMaintain budget register entriesBudgetBudgetTransactionsMaintain
      • PrivilegeView currenciesCurrencyView
  • RoleBudget managerBudgetBudgetManager
    • DutyMaintain budget register entriesBudgetBudgetTransactionsMaintain
      • PrivilegeView currenciesCurrencyView
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currenciesCurrencyView
  • RoleChief financial officerCompanyChiefFinancialOfficer
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currenciesCurrencyView
  • RoleMaintenance clerkEntAssetMaintenanceClerk
    • PrivilegeEntAssetMobileSetupView held by the role directly, not through a duty
  • RoleMaintenance managerEntAssetMaintenanceManager
    • PrivilegeEntAssetMobileSetupView held by the role directly, not through a duty
  • RoleMaintenance requesterEntAssetMaintenanceRequester
    • PrivilegeEntAssetMobileSetupView held by the role directly, not through a duty
  • RoleMaintenance workerEntAssetMaintenanceWorker
    • PrivilegeEntAssetMobileSetupView held by the role directly, not through a duty
  • RoleInvoice capture operatorInvoiceCaptureOperator
    • DutyInvoiceCaptureMaintain
      • PrivilegeView currenciesCurrencyView
  • RoleAccountantLedgerAccountant
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currenciesCurrencyView
  • RoleAccounting managerLedgerAccountingManager
    • DutyEnable general ledger processLedgerGeneralLedgerProcessEnable
      • PrivilegeMaintain currenciesCurrencyMaintain
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currenciesCurrencyView
  • RoleAccounting supervisorLedgerAccountingSupervisor
    • DutyEnable general ledger processLedgerGeneralLedgerProcessEnable
      • PrivilegeMaintain currenciesCurrencyMaintain
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currenciesCurrencyView
  • RoleFinancial controllerLedgerFinancialController
    • DutyInquire into general ledger reference dataLedgerGeneralLedgerReferenceDataInquire
      • PrivilegeView currenciesCurrencyView
  • RoleRental managerRentalManager
    • DutyEnable general ledger processRentalLedgerGeneralLedgerProcessEnable
      • PrivilegeMaintain currenciesCurrencyMaintain
  • RoleRental purchasing managerRentalPurchasingManager
    • DutyEnable general ledger processRentalLedgerGeneralLedgerProcessEnable
      • PrivilegeMaintain currenciesCurrencyMaintain
  • RoleRental sales managerRentalSalesManager
    • DutyEnable general ledger processRentalLedgerGeneralLedgerProcessEnable
      • PrivilegeMaintain currenciesCurrencyMaintain
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itMaintain budget register entries BudgetBudgetTransactionsMaintainTo use itInquire into general ledger reference data LedgerGeneralLedgerReferenceDataInquireGive people a role that holds these duties. On this system, 15 roles give access to this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=Currency
Integrate withCurrencyEntity data entity Microsoft data model
Data migrationCurrencyEntity (Currencies): shared by all companies, in Microsoft's default template 010 - System Setup.Load order: Microsoft's default template 010 - System Setup loads Currencies at execution unit 1, level 10, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Microsoft Learn
Table definitionCurrency columns and relations Microsoft data model
Everyone

8Sources