News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Exchange Rate Update F...

Small and medium business | Business Central, N...

Answered

Exchange Rate Update Field Mapping

(0) Share

Report

Report

Posted on by john.ellis

3,482

Hi:

For automatic updating of Exchange Rates, are there simple "default" settings that can be put in place? An example is shown below.

John

Caption	Source	Default Value	Transformation Rule
Parent Node for Currency Code	/channel/item
Currency Code	/channel/item/targetCurrency
Starting Date	/channel/item/pubDate		US_DATE_FORMAT
Exchange Rate Amount		100
Relational Exch. Rate Amount	/channel/item/inverseRate		MULTIPLYBY100

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

MahGah 15,428 on at

Like (0)

Report

RE: Exchange Rate Update Field Mapping

Hi

The easiest method is to use free app such as below

appsource.microsoft.com/.../PUBID.hougaard-4699382|AID.openrates|PAPPID.362079c8-83e6-48cb-9099-7c19886bfcfa

Or do it as you showed or mentioned here then Enable and add to Job Queue

https://yzhums.com/7341/

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans