The CRM Analytics consultant at Universal Containers (UC) has set up data sync for the Salesforce Opportunity object with the Amount currency field added. This is being used in multiple datasets and dashboards, as UC is a multi-currency organization.
The currency used in Salesforce records is set up in GBP but the data on the dashboard is converting to USD. Conversion logic is not set up on any of the recipes.
Why is the currency converting?
In Salesforce CRM Analytics, when dealing with multi-currency environments, the system relies on the organization's corporate currency setting for reporting, unless explicitly overridden. In this case, even though the Opportunity data is stored in GBP in Salesforce, the dashboards are showing USD because the corporate currency for the org is set to USD. This behavior is expected unless currency conversion logic is implemented in the datasets or recipes.
The corporate currency serves as the default for currency fields in datasets and dashboards unless configured otherwise. This can be confirmed under the 'Manage Currencies' settings in Salesforce.
Currently there are no comments in this discussion, be the first to comment!