Loading daily currency rate conversions from a 3rd party service can be expensive, especially as you start to expand into global markets. By the time you realize, you might be buying 600 currency conversion rates daily. On top of that, add monthly and quarterly average rates for financial reporting. This is a solution to cut down on that expense, by generating your own monthly and quarterly average conversion rates inside of Workday.
This solution will use two custom reports, one for monthly and one for quarterly rates. To keep things simple there will also be two separate Studio Integrations. Each Studio will pull the corresponding report data source and update the Monthly or Quarterly average rate in Workday. The trick is to set the schedule properly.