Exchange rate service is getting yesterday date

marcuscmarcusc Member Posts: 17
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

Answers

  • marylee868marylee868 Member Posts: 4
    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?
Sign In or Register to comment.