最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

在Dynamics 365 财务和运营中自动配置货币汇率提供商和导入汇率 / Configure Currency exchange rate providers and import exchange rates automatically in Dynamics 365 for Finance and operations

网络文摘 William 1918浏览 0评论
Microsoft Dynamics 365 For Finance and Operations provides integration with 3 exchange rate providers out of the box.
  1. Central Bank of Russian Federation
  2. Central Bank of Europe
  3. OANDA

Depending on the country of your operations or your preference, you can use any of these providers to import currency exchange rates directly into Dynamics 365. Usually, OANDA is the widely used and most trusted exchange rate provider.

The configuration of these is pretty simple and straightforward. The integration with Central bank of Russian Federation and Central bank of Europe does not require you to setup an API key within Dynamics 365, where as for OANDA, you will need to get the API key from OANDA and set it up in Dynamics 365. OANDA also lets you do more flexible setups, such as how many decimal places you want to use, what quote type you want to use.

Lets take a quick look at how the process for setting these up and importing the exchange rates looks like.

The first thing is to setup the Currency exchange rate providers within Dynamics 365. You can do this under General Ledger > Currencies > Configure exchange rate providers form. Exchange Rate Providers Exchange Rate Providers Config If you look at the default key configurations for the Central Bank of Russian Federation and Central Bank of Europe, there are pre-populated by Dynamics 365 with the Key values, which are basically the service endpoint (XML files). Screenshot below shows the configs. Central Bank of Russian Federation Central Bank of Europe To demonstrate the feature, i have created 3 separate Exchange rate types for the 3 different providers. Exchange Rate Types

Now that the exchange rate providers and exchange rate types are setup, lets ee how the import of the exchange rate works. I will first do it for the Central Bank of Russian Federation and Central Bank of Europe and then i will do the setup for OANDA feed, since that involves some additional steps.

There are 2 options of importing the exchange rates. You can trigger the import manually every time you require or you can set the process to run in batch at specified recurring intervals.

  • To initiate the import, navigate to General Ledger > Currencies > Import currency exchange rates.
  • On this screen, you can select the Exchange rate type into which you want to import the exchange rates.
  • Then select the Exchange rate provider (CBRF, CBE or OANDA)
  • You can import “As of today’s date” or you can specify a date range as well (From date and To date)
  • If you using the Central Bank of Russian Federation as the exchange rate provider, you can tell the system to automatically create the currency pairs. This is nice !
  • You can chose if you want to override existing rates also.
CBRF Import
  • Here you can setup the import process to run automatically in the background(batch) at specified recurring time intervals)
Batch Import
  • After you click OK, the import process will start and you will get a confirmation message telling what was imported.
Import Confirmation Message
  • If you are using the Central Bank of Europe as the exchange rate provider, you can additionally tell the system to prevent import on national holiday.
CBE Import
  • After the import process is complete, you will find your exchange rates in the Exchange table.
Exchange Rate Imported
  • For OANDA as your exchange rate provider, you will do some additional setup. First you will need to get a API key from OANDA. If you have a paid subscription with OANDA, you will already have a API key for exchange rates. But to test, you can just start a 30 days free trial by simply specifying your email ID. You will receive the API key in your email.
OANDA Signup1 OANDA Signup2 OANDA Signup3
  • One you have the API key from OANDA, you will need to set it up under the Exchange rate service provider configuration.
Setup API Key on Provider
  • With this setup, You are all set!!. Now the import process for OANDA is the same as we saw above for CBRF and CBE. Only thing you need to note is, with OANDA, you will need to create the currency pairs depending on how many currencies your organization operates in.
  • You can verify that the exchange rates are imported.
OANDA Import
  • You can see below that i had created 3 currency pairs (USD to INR, USD to EUR and USD to GBP) and the import process imported the corresponding exchange rates.
OANDA Imported OANDA ER That’s it for this post..  
发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址