If you’ve made a Journal Entry that posted to the Ledger with the wrong Posting Date, the textbook method for resolving this issue is to create a new Journal Entry exactly as the original, posting date and all, and with the sign of the amount being opposite of the original incorrect entry. Post that Journal, and at that point the Ledger will look as though the transaction(s) never took place as they negate each other.
Now, create another Journal with the correct amount and Posting Date and post that.
Once you start making edits directly to any of the ledger entry tables, you have blown the audit trail and made your auditor’s hair spontaneously spark on fire. Ledgers are not supposed to be written to by any means other than posting routines.
I wold make a backup of your problem company, restore it to your test database, and test this series of reversing and re-entering transactions to see whether it solves you problem. If it does, then repeat the process in the production database.
Just my thoughts on the subject. You will probably hear others.