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.
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.
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!