Updating Exchange Rates Automatically in SAP Business One

This is a personal itch I had to scratch, instead 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.

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 as, if no ER (exchange rate) was published that day, it will go back one day (up to 7 days) and will try to fetch the ER of the day before.


Leave a Reply

Your email address will not be published. Required fields are marked *