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).