Hello Experts,
We are using Unrealized VAT functionality in Business Central Cloud.
This functionality works great with local currency, but we have some problems when it comes to foreign currency transactions.
For example, my local currency is PLN, I have Posted Purchase Invoice for 1000EUR Net and 230EUR VAT, with exchange rate of 4,5:
So with this exchange rate I have unrealized VAT calculated - 1035PLN.
When the payment is posted and settled with invoice, we have other exchange rate, because it is other day - in my example 6.0.
My accountant is expecting that when payment is posted, VAT will be posted (becasue we have unrealized VAT so the VAT is reposted between unrealized VAT and actual VAT account) with the new exchange rate, so not 1035PLN but 230EUR*6.0 = 1380PLN. But now I have VAT posted with the same amoutn, with excahnge rate 4.5:

Do you know if we can setup it differently, that when posting payment, system will use exchange rate from payment, not from invoice?
*My exchange rates are only examples ;)
Thank you in advance!