Looking to see how other admin's have solved currency conversion to USD within gainsight, or a load from SFDC.
Today: ARR is shown in it's native currency in SFDC & then has a converted USD option for visibility & reporting, however that is not an option to load to the company object in Gainsight. I can work on a solution with our SFDC admin team however I'd like to see if there's an in-house solution first.
How are other groups building their Gainsight operations to be able to show only USD? I cannot find any support articles so any help is appreciated!
Best answer by sidhuView original
So any aggregate query would have the currency values converted to the org's default currency. In Rules Engine, one trick would be to just add an aggregation like sum to make sure all the currency values are returned in the org's default currency. If you have included Account ID in the show field, then while the aggregation is happening, there would be only one record per account and the final result set should still be the same intended output.
1) The Current ARR in the summary page now shows the correct amount, but in its native currency instead of USD.
2) The mass edit scorecard report still shows the incorrect amount even though it says ARR is a lookup from the company object. I'm tempted to let this one run overnight and see if anything updates?
After map Customer Info : ARR to sync to GS Connect.
You will have to change the Currency ISO Code on all customer info records to USD. You could do this via the rules engine.
In a "Load to Customers" action, create a custom field mapping to the "Currency ISO code" field and set it to "USD".
If you are using Scorecard 2.0 (which is based on the Company Object in MDA), you will have to use GS Connect to push the data from SFDC (Account/Customer Info) to MDA (Company). So the step that Kevin suggested below is required.
If things are still not right, then an additional check would be to review the field on the Company object from Data Management screen and check its currency code.