How to fix The move is not balanced error.

accounting finance

Best Answer

Hello,

You can try the below solution in Staging (TEST) DB before applying it in Production.

You can use Update query in DB to update the journal items Debit, credit, Balance

update account_move_line set Debit=VALUE,credit=Value,Balance= Value Where id = JOURNAL ITEM ID.

Thanks.

3 Comments

- 10 July 2025

Thank you, Waleed.
I tried that but it is not allowing to import the file.

- 10 July 2025

I see, the other solution is to update the value from DB using Update statement.

- 10 July 2025

Thank you for helping, Waleed. It resolved the issue.

Best Answer

Hi,

I tried that but it is not allowing to import.

2 Comments

- 10 July 2025

I see, the other solution is to update the value from DB using Update statement.

- 10 July 2025

Tried that as well. It updated the values on the record but the error is not going away. May be it is still using some stored values.

Help