I found that, if I use more than one currencies, I can create offers/orders/invoices etc. in foreign currency when my customer/vendor has an account with that currency.
In this case I am able to set an exchange rate for a specific day. The simplest rule in here (Hungary) to use the MNB's daily exchange rate (MNB is similar to FED or other central bank, which controls the country policy or whatever).
As I do businessess in worldwide (vendors, customers sometimes in the EU and outside of EU), sometimes it happens, wrong exchange rate entered and needs to adjust it. Typical is, copy the value from somewhere else by Ctrl+C - Ctrl+V and the value format is wrong: like 221,38 become 22138 when it saved. It can happen and will happen.
An other example, in the same day I issue an invoice for USD and I entered the MNB's exchange rate, but I also receive for example some USD into my bank account, but the bank converts it in his exchange rate which different than MNB.
So, in SL (and the Hungarian modificaton of SL) it is possible to:
- list exchange rates for a specific day (not comfortable, limited functionality)
- keep track of two independent exchange rate, one is like for MNB, the other is for bank's exchange rate (this is also limited to 2)
After all, my questions:
- is that possible to get a list of actual exchange rates? date from-to, currency could be ok for first
- it would be nice to be able to manage these kind of issues when accidentaly wrong exchange rate entered -> in this case all related transaction should be recalculated, fixed somehow in the books, but keep it somehow in the "history" of course
- I did not check this specifically, but how can we manage that case, when some has more than one bank accounts and some of them are in different currency and wants to keep tracking that in USD/EUR/whatever?
Regarding filling up automatically the exchange rate is possible with direct sql manipulation, using a script, for example every morning or whatever.
So, what is your experience/needs with exchange rates?