Skip to main content
Business Central forum
Answered

Exchange Rate Update Field Mapping

editSubscribe (0) ShareShare
ReportReport
Posted on by 3,476

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

  • Verified answer
    MahGah Profile Picture
    MahGah 15,395 on at
    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

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans