D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Oanda Imports Subset of Exchange rates

  • 1.  Oanda Imports Subset of Exchange rates

    SILVER CONTRIBUTOR
    Posted Apr 09, 2021 06:08 AM

    Hi, 

    I am having an issue where my Oanda batch job runs and imports some rates but not others. My batch log returns warnings such as 

    An exchange rate could not be found for ISO currency codes USD and GBP, on the following date: 4/7/2021. Verify the ISO currency codes that are supported by the provider and that are available for the requested date.

    The job runs at 8 PM EDT  with the parameters below and returns the a warning like above

    Image

    If I run a single day import with the parameters below the missing rates from last night's run will import.

    Image

    Oanda says from their side they are successfully pushing the information. Has anyone else ran into the issue?

    #FinanceandOperations

    ​​​

    ------------------------------
    Kamar Wilks
    BlueCrest Inc
    Danbury
    ------------------------------


  • 2.  RE: Oanda Imports Subset of Exchange rates

    TOP CONTRIBUTOR
    Posted Apr 12, 2021 01:29 PM
    4/7 was a bank holiday (Easter Monday) in the UK, so there wouldn't have been a GBP rate for the day. Not sure why USD wouldn't have updated, unless it's because it's part of your GBP-USD pair.

    ------------------------------
    Steve Latta
    Accountant
    Ortec, Inc.
    Easley SC
    ------------------------------



  • 3.  RE: Oanda Imports Subset of Exchange rates

    SILVER CONTRIBUTOR
    Posted Apr 19, 2021 06:08 AM
    Thank you Steve


    I don't think the holiday was the issue. I have seen these messages almost everyday. It seems as if the only day I don't see the errors or missing rates is on a Saturday night.

    ------------------------------
    Kamar Wilks
    BlueCrest Inc
    Danbury
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role