Salesforce Multi-currency: Automated Conversion Rate Update
In our previous blog, we talked about Advance Currency Management. If you think it is troublesome to update this daily/weekly/monthly, you can automate it by using the following approach:
1) Select a web service that can offer you a daily conversion rate. For example: https://rate-exchange.appspot.com/currency?from=AUD&to=MYR
This web service will return you the current conversion rate in JSON format. For example:
{"to": "MYR", "rate": 3.0456099999999999, "from": "AUD"}
2) Create an automated job that query the rate daily/weekly/monthly and update it into the DatedConversionRate object. The automated job can be done using Apex Scheduler or Integration frameworks such as Talend or Boomi.