PowerObjects Blog 

for Microsoft Business Applications

Multi-Currency Functionality for Goals in Dynamics CRM

Multi-Currency Functionality for Goals in Dynamics CRM

Goals in Microsoft Dynamics CRM are used to set revenue and count targets and to compare progress towards these targets. The multi-currency functionality for goals is Microsoft Dynamics CRM is an important feature that is used by many multinational companies to track currency values in multiple currencies. In today's blog, we'll focus on using multi-currency functionality to track and display revenue goals and the progress towards these goals.

All currency (money) fields in Dynamics CRM have two underlying fields. In the example below, the underlying currency fields for the "Estimated Value" field are "Est. Revenue" and "Est. Revenue (Base)". In case of multi-currency scenarios, the "Est. Revenue" field stores the value in the user's local currency and the "Est. Revenue (base)" field stores the value in the base / organization currency.

multi-currency functionality for goals in Dynamics CRM

For example, let's say the base currency of a company is UK Pounds and the local currency setting of a user is US Dollars (US $). All currency fields on the form, views, and roll-up charts will be displayed in local currency (US $ in this example), unless the base currency field is specifically added to the form, view, and chart.

In the case of the Opportunity entity, the transactional currency and the out-of-the-box roll up chart (in this case, the Sales Pipeline Chart) are displayed in local currency, which is US $ as illustrated below. If you want, you can build custom views and corresponding charts using the base currency fields to display values in the base currency.

multi-currency functionality for goals

However, in the case of the Goals entity, all of the currency fields, views, and out-of-the-box roll up charts display the currency values in the base currency. As you can see in the example below, it displays the currency values in UK Pounds which is the base currency for this organization. Both of the underlying (base and local) currency fields for the "Target", "In-Progress", and "Actual" fields display the currency values in the base currency.

This could be an issue for a global company that wants to use the multi-currency functionality and also wants their users to be able to track progress towards their goals in the desired local currency, rather than having to convert the base currency into the local currency manually or through heavy customization.

One way of resolving this issue is to build a custom chart. The built-in chart designer can be used for this purpose. As shown in the example below, the custom chart includes the out-of-the-box local currency fields for the "Target", "In-Progress", and "Actual" value fields. The custom chart will display the target and corresponding in-progress and actual revenue values in the user's local currency. This gives the users the ability to quickly review and track their progress towards their goals. The chart can replace the built-in Goal Progress chart on sales performance dashboards.

There you have it. Happy CRM'ing!

By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

3 comments on “Multi-Currency Functionality for Goals in Dynamics CRM”

  1. Hi JoeCRM,
    Thanks for this article. I hope you can help me with an issue. We sell across the globe and hence estimated values have different currencies. So when i go to the dashboard, the charts shown there continue showing the values in local currencies due to which the charts stop making sense. How to set the charts to display in base currency?

  2. What is the 'PlaceholderMoney' Series? I did just as you, only without 'PlaceholderMoney' Series and it show base currency only.

  3. Hi Joe, we are a global company and the sales targets are not set in the base currency (they would be set in AUD, USD rather than our base currency NZD). We could convert those USD/AUD targets into NZD, but when the exchange rate changes that means the USD/AUD calculated target on the chart would change. Is this a 'tough luck' one? Or are you aware of anything we can do address this? I guess we could do some cheeky workflow in the background..

PowerObjects Recommends