For Dynamics customers and Salesforce customers that use just the basic (non-advanced) currency management, touchpoint revenue amounts should be correctly converted, so CRM reports should work as expected.
There is unfortunately some nuance to how this works for users of Salesforce Advanced Currency Management, due to a longstanding limitation of Salesforce. The short answer to “what do we do in this case” is that we convert revenue amounts using the flat rates that are defined in the basic (i.e. non-advanced) “Manage Currencies” tab. In other words, we ignore the dated exchange rates altogether despite the fact that there are defined dated exchange rates.
For the interested reader, here’s why it works this way. Our touchpoints use formula fields to calculate revenue (derived from the associated opportunity amount). Salesforce natively supports currency conversion for these formula calculations, but only for their basic flavor of currency support. It’s impossible for us to define a formula field that references the dated exchange rates. Salesforce simply does not support that capability, so we have no way to reference the dated rates in our revenue calculations despite the fact that those dated rates exist in Salesforce.
Keep in mind that there are two different feature bits for this feature. Both are located on the CRM.General tab: Multiple Currencies and Advanced Currencies. Multiple Currencies should be enabled if utilizing more than a single currency, whereas the additional feature bit Advanced Currencies can be enabled if your org uses Salesforce’s “Advanced Currency Management” feature where the user can set a time-based range for conversion rates.
Unfortunately, we do not know when a user switches between Simple or Advanced if Advanced had already been turned on. Because of that, the user needs to keep the Advanced Currencies setting aligned with their CRM setting manually. This should be apparent to the user if the conversions are incorrect, which means we didn’t know which level of conversion to apply.
We will display a warning message next to your ads account that may have currencies coming in from an unsupported currency. If this happens, your dashboards will contain tiles with a “Mixed Currencies” message. We advise that you work with your CRM Admin to make sure this unknown currency contains a conversion in your CRM.
If you have a tile that has a “Mixed Currencies” message at the bottom, that means we have imported some costs that are mapped to a currency that we do not recognize. Because all of our conversions must come from the CRM with an actual conversion rate, it means that your CRM is missing this currency. We advise that you work with your CRM Admin to make sure this unknown currency contains a conversion in your CRM.
Declaring a new currency or conversion rate can only be done in Salesforce or Dynamics so that there is only a single source of truth for these values. Once a new currency or conversion rate is detected, Bizible will download that and make it available to you. We do not offer an area to enter these rates.
We understand that some countries have a different way of formatting amounts, such as 1,234.00 or 1.234 or 1 234 but we introduce another level of complexity if we have to not only determine a user’s currency, but their country of origin, since different countries and currencies can be handled differently. The consistent format that we have stuck with is 1,234.00. This cannot be changed.
Salesforce and Dynamics display their amounts with the 3-letter Conversion Code, so for consistency, our converted amounts also display with the 3-letter Conversion Code and not the symbol.
If the user doesn't have the multi-currency feature, we will default to their Currency Locale from the CRM and change all ISO codes that show their spend and revenue in the corporate currency. If this is incorrect and the customer has a mixed use of currency, the solution would be to upgrade to get the multi-currency feature.
Since our offering will now handle the conversions for the customer, we recommend that they remove the workflows and custom field and allow us to import their raw Amount value.