Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Auto calculate base tr...
Microsoft Dynamics CRM (Archived)

Auto calculate base transaction rate

(0) ShareShare
ReportReport
Posted on by Yashaswini 170

It's CRM 2015 on premise. We have the base currency as USD and our business includes rate in multiple currencies.

On Account Form, There is only one custom currency field called 'Revenue Rate'. The user enters the rate in the currency based on their location and dynamics auto converts to base currency in "base_revenuerate" field. -- THIS IS THE EXPECTED BEHAVIOUR.

We update the exchange rate manually once a month. The revenue rate on Account will NOT auto calculate the base currency based the updated exchange rate. Due to some business need, I need all accounts 'base_revenuerate' be auto-calculated based whenever the exchange rate is updated. 

How to do that? Please help 

*This post is locked for comments

  • Suggested answer
    Sreevalli Profile Picture
    Sreevalli 3,256 on at
    RE: Auto calculate base transaction rate

    Hi,

    Base currency will be calculated upon record update(manual or serverside). so you have to trigger a plugin on exchange rate update on currency entity, in which you just need to retrieve all(may be active) the accounts with Revenue Rate not null and then call service.update foreach record (without any changes).

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: Auto calculate base transaction rate

    Hi,

    Just want to add new exchange rate will be used for calculation when any changes will be done in the currency field, so you need to set some automation to recalculate those fields or you can try this: community.dynamics.com/.../real-time-exchange-rates-using-a-calculated-field-in-dynamics-crm

  • Suggested answer
    Clem Profile Picture
    Clem 2,541 on at
    RE: Auto calculate base transaction rate

    Hello,

    The currency data will be updated once you open the record and perform a save action with a modification on the money fields.

    If you want to make sure that all accounts are recalculated once you updated the exchange rate, then you could perform this by a plugin or a workflow which is triggered once the exchange rate is changed and update the money fields of each accounts.

    Regards,

    Clément

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans