Hi! Sorry for the rookie issue!
I chose the wrong date for the field "Reversal date" and the field "Revaluation date" in Cash & Bank's Foreign currency revaluation.
The date I chose for Reversal and Revaluation is 11 Jan 2022, which is later than the correct date 31 Dec 2022.
As a result, now the revaluation amount is not reflected in the bank's 2021 closing balance.
Now, I need a way to redo all the 11 Jan 2022 revaluation and reversals so that I can post a revaluation for the date 31 Dec 2021.
In details, this is what happened:
1. On 11 Jan 2022, we posted a bank currency revaluation with the "Revaluation date" field set as 31 Dec 2021. This is the correct revaluation date.
2. On 13 Jan 2022, I reversed the revaluation in Step 1 (because there was something that we needed to correct).
This time, I chose the "Reversal date" as 11 Jan 2022 instead of 31 Dec 2021.
3. On the same day, 13 Jan 2022, I re-ran the revaluation.
This time, I still chose the "Revaluation date" as 11 Jan 2022 instead of 31 Dec 2021.
At this point, the bank balance of this year is not correct because the revaluation was not run for December as it should have.
4. After realizing the mistake, I reversed the revaluation on Step 3. The "Reversal date" is Jan 11.
5. Then, I tried to run the revaluation again, this time with 31 Dec 2021 as "Revaluation date".
However, the system answered that "No adjustments were found for the foreign currency revaluation".
Do you know of a way to redo the revaluation and reversals of Step 2, 3, 4?
Or alternatively, do you know of a way to correct the bank's balance for this year?
Here's a screenshot to make it clearer what I'm talking about:
Thanks in advance!