Hi, dear colleagues!
We have issue with foreign currency revaluation for vendor.
There are a lot of records related to revaluation, but, final balance is not correct as you can see at screenshot below.
1 - there was a fully settled invoice from year-2014
2 - in 2016, why, when calculating the exchange rate difference, the amount is calculated on it. The amount is visible in the unrealized exchange rate difference
3 - between the balance of vendtransopen and vendtrans there is a difference of 278,000 (the balance does not show the amount, the turnover sheet shows)
4 - Reversed settlement postings on this invoice for 31.12.2017 and re-calculated (settled) on a new date, compared open invoices, set the revalution of the exchange rate difference - the difference between the amounts of tables on the contrary increased
5- there are currently no open transactions;
6-Vendors's foreign currency balance 0 - Local currency balance 0, amount by vendtrans - 2935465,97 (local currency)
How we can manually (x++) reverse (cancel or delete) this revaluation records (vendsettlement, generaljournalentry, generaljournalaccountentry) and recalculate currency revalution?
Thanks in advance!
