function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
QMEQME 

Multi-currency & Dated Exchange Rates

Background
We have activated the Multi-Currency feature in our Org.  

 

I read the on-line help and the document at this url and have not been able to find any pertinent information. https://na6.salesforce.com/help/doc/en/salesforce_using_multiple_currencies.pdf 

 

We are building a standalone solution on Force.com with no integration into SFDC CRM objects. 

 

 

Question:

How do we get the DATA for the conversion rates?  Does Salesforce store the daily conversion rates in a table somewhere from where we can retrieve the actual conversion rate on a particular date?  In other words, we call an SFDC API passing in the (date, from currency, to currency) and the SFDC system returns the conversion rate for that date? 

 

OR 

 

Do we have to load this data into our own org on a daily basis by calling a webservice such as the one provided by the NY Fed Reserve http://www.newyorkfed.org/markets/pilotfx.html  and write the conversion rates to the currency table provided by SFDC (manage currencies section). 

 

After all, SFDC document at the url above says the system admin maintains the currencies but it seems absurd that it would be a manual process to input each conversion rate...  what am I missing here?

 

 

 

Thanks!!

SidMSidM

Hi,

 

I know this is an old post, but in case you haven't already found it, there is a CurrencyType table which gives you programattic access to the rates for basic currency management:

 

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_currencytype.htm

 

If you have advanced currency manage turned on, you will have access to DatedConversionRate:

 

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_datedconversionrate.htm

 

Hope this helps.

 

Cheers