We have the following scenario:
- Create a transaction (say a sales invoice) on Sep 15 in EUR (main currency is GBP)
- On Oct 1, we update the exchange rate globally (Settings > Foreign currency) for the period of Sep 1 to Sep 31
- We notice that the sales invoice is stuck on the former exchange rate
- We have lots of invoices so we try to update them in batch, removing the exchange rate, expecting it to be recalculated (the exchange rate shows “Autofill” in edit mode)
- Now we have a huge FX gain / loss ; looking into the details of how the FX gains / losses are calculated, we see that our sales invoices are recorded with a transaction exchange rate of EUR 1 = GBP 1, instead of the proper rate.
Questions:
- Is there a way to fix this short of updating manually the exchange on all credit notes, sales invoices, purchase invoices and receipts?
- What would be the recommended course of action, instead of the one we’ve taken?