Currency Exchange Rate Service with Swiss Admin website

JérémieJérémie Posts: 4Member
good afternoon!
I am trying to setup the Currency Exchange Rate Service on NAV2016with the following xml.
http://www.afd.admin.ch/publicdb/newdb/mwst_kurse/estv/mittelkurse_xml.php
I am struggling to setup this service.
Have you ever done it with this website?
Thanks in advance
Jérémie

Best Answer

Answers

  • archer89archer89 Posts: 328Member
    best regards
    Franz Kalchmair, MVP
    Alias: Jonathan Archer

    please like / agree / verify my answer, if it was helpful for you. thx.
    Blog: http://moxie4nav.wordpress.com/
  • JérémieJérémie Posts: 4Member
    edited 2016-07-25
    Thanks for the links. I have already checked this out but I did not manage to fully setup the currency Exchange rate with the swiss website...
  • JérémieJérémie Posts: 4Member
    I don't know how to import the Exchange Rate amount from the website. Sometimes the value is 1 EUR, sometime 10000 IDR etc... as shown below in the exemple
    Indonesien 10000 IDR 0.76067
    Euro 1 EUR 1.09484
    http://www.afd.admin.ch/publicdb/newdb/mwst_kurse/estv/mittelkurse_xml.php
    Is it possible to take only the Numeric part of 10000 IDR, 1 EUR etc...?
    thanks a lot for your help
    Jérémie
  • rosietesmenrosietesmen Posts: 6Member
    The availability of current rates cannot be guaranteed 100% for technical reasons. The following applies for the value added tax on imports: In the event of system failure, the exchange rates (sell) are to be obtained from a Swiss or Liechtenstein bank.
  • krikikriki Posts: 8,570Member, Moderator
    [Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2018: 22 & 23 November 2018, Antwerp (Belgium)
  • JérémieJérémie Posts: 4Member
    Thanks Jonathan!
  • MSchuermannMSchuermann Posts: 1Member
    Jérémie wrote: »
    I don't know how to import the Exchange Rate amount from the website. Sometimes the value is 1 EUR, sometime 10000 IDR etc... as shown below in the exemple
    Indonesien 10000 IDR 0.76067
    Euro 1 EUR 1.09484
    http://www.afd.admin.ch/publicdb/newdb/mwst_kurse/estv/mittelkurse_xml.php
    Is it possible to take only the Numeric part of 10000 IDR, 1 EUR etc...?
    thanks a lot for your help
    Jérémie

    Is there already a solution for this problem?
Sign In or Register to comment.