Hi,
Its difficult to comment without seeing your exact figures so below is a worked example from my demo system.
I created a new EURO Bank Account (my LCY currency is GBP)
I then posted these 3 transactions:
Therefore, my bank account balance is €600 with a GBP equivalent of £516, (GBP is my LCY currency)
I then added the exchange rate for 30/11/22 of 1.5 to the currencies table ready for the revaluation.
I then ran the Adjust Exchange Rate using the options below
This produced the following adjustment:
The GL Entries are:
As you can see the system has posted an adjustment of £116.00 which is correct. (the GBP balance at a rate of 1.5 should be £400 so the system posts an adjustment of £116)
Therefore, check the running balance LCY in the bank account ledger entries after you have ran the revaluation.
Please note its only the bank account ledger entries that the system uses to calculate the adjustment. It doesnt look at the GL entries as this doesnt hold any foreign currency amounts. (other than reporting currency which is something different)
Hope this helps you figure out what's happening on your system.
Thanks
Gavin