Updating Exchange Rates Automatically in SAP Business One

This is a personal itch I had to scratch, instead of waiting for our accountant to update the exchange rates in SBO to allow us enter new orders, I wrote a small PowerShell script to do that for us.

Please note that this script was created for my personal use, and I never tested it on other systems. So don’t blame me if it blow up your system while trying it.

The script is quite simple and I didn’t put much effort to cover all corner cases so keep that in mind if you intend to use it. What the script dose, it connect to BOI API service at `http://www.boi.org.il/currency.xml` and fetch the exchange rates for the current date, if no ER (exchange rate) was published that day, it will go back and will try to fetch the ER of the day before (up to 7 days).

2 Responses

  1. charles says:

    hi pls help
    Method invocation failed because [System.String] doesn’t contain a method named ‘SelectSingleNode’.
    tks

    • Rabin says:

      can you share more info on which stage you get this error ?
      I updated the API url to use https, please give it another try.

Leave a Reply

Your email address will not be published.