BeyondERP.Subscribe

Job page · General ledger

Import currency exchange rates

A page that imports exchange rates from an exchange rate provider and adds them to the Currency exchange rates page.

Used by
—
Business process
—
Menu item
Action:ExchangeRateImportController
Main table
—
Data entity
—
Setup steps
—
Show what matters for

Everyone

1What it is and why

What it isA page that imports exchange rates from an exchange rate provider and adds them to the Currency exchange rates page.
What you do hereUsed to select the exchange rate type, provider, and date or date range, with options to create missing currency pairs or override existing rates.
ExampleWith the European Central Bank as provider, skip importing rates on a public holiday of the current legal entity.
Import currency exchange rates page in Dynamics 365
The page in a working Dynamics 365 system. page title tab to open what to set or check

Functional consultant · Solution architect

2Where it fits

Business process—
Menu pathGeneral ledger › Currencies › Import currency exchange rates
Set up firstConfigure exchange rate providers Microsoft Learn ↗Exchange rate types Microsoft Learn ↗
Used next byCurrency exchange rates Microsoft Learn ↗
Related pages—

End user · Functional consultant

3How to do it

Microsoft's steps

  1. Go to General ledger > Currencies > Import currency exchange rates.
  2. In the Exchange rate type field, select the type to add the rates to.
  3. In the Exchange rate provider field, select the provider.
  4. In Import as of, choose the current date or a date range.
  5. Select Create necessary currency pairs or Override existing exchange rates if you need them.
  6. Select OK.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
Import as ofImports rates for the current date or for a date range.Microsoft Learn ↗——
Create necessary currency pairsCreates any imported currency pair that doesn't exist yet.Microsoft Learn ↗——
Override existing exchange ratesReplaces a rate already entered for the same pair and date; otherwise that date is skipped.Microsoft Learn ↗——
Prevent import on national holidaySkips rates for public holidays of the current legal entity.Microsoft Learn ↗——
Rate from the previous dayFor Central Bank of Europe only: imports the rate published on the previous working day.Microsoft Learn ↗——

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision · common mistake · test
— No setup is made on this page.

Solution architect

5Design impact

Shared or per company—
Can it be undone—
Feature or country—
If you change it laterRates already entered for a date are kept unless Override existing exchange rates is selected. Microsoft Learn ↗

Technical architect

6Technical

Menu itemAction:ExchangeRateImportController Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Table—
Data entities—
Who can open it—
Actions on the page—

Developer

7Developer

Open it directlyhttps://<your-environment>/?mi=Action:ExchangeRateImportController
Integrate with—
Table definition—

Everyone

8Sources and checks