Exchange rate service is getting yesterday date

marcusc

Hi.
I setting ups the exchange rate service using the default yahoo.

When I click update, it return starting date as yesterday date. Is this correct?

<query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng&quot; yahoo:count="1" yahoo:created="2017-05-16T09:04:40Z" yahoo:lang="en-US">
<results>
<rate id="SGDMYR">
<Name>SGD/MYR</Name>
<Rate>3.0933</Rate>
<Date>5/15/2017</Date>
<Time>4:20pm</Time>
<Ask>3.0943</Ask>
<Bid>3.0933</Bid>
</rate>
</results>
</query>
<!-- total: 6 -->
<!--
prod_sg3_1;paas.yql;queryyahooapiscomproductionsg3;d71ff55b-2f7e-11e7-b30d-9cb654822760
-->

Thanks

marylee868

We are trying to set up similar exchange rate service but using Google in NAV 2017. Do you know what is difference between Yahoo or Google exchange rate service?
Do you use mid market rate of previous day?
Since we consolidate into USD, we prefer to use the previous day rate of US Time Zone, instead of UK time zone. Is it possible?