ERPNext: v11.1.18 (master)
Frappe Framework: v11.1.18 (master)
I have a journal entry (
JV-2019-00028) which was posted on the wrong day (April 8, instead of April 9). Now I try to correct this by changing the
posting_date of that faulty entry
update `tabJournal Entry` set posting_date = replace(posting_date, '2019-04-08', '2019-04-09') WHERE name="JV-2019-00028";
then I check the database and the
posting_date value was altered as planned.
Also when I look at the Journal Entry
JV-2019-00028 in the GUI it has the altered Posting Date.
So, thus far everything is looking good. When I look at the General Ledger filtered to one of the involved accounts of this JE (Cash In Hand) the posting date is still shown on April 8 (which is the date that was used when posted the JE in the GUI).
I have executed
bench restart with no result in this regards. Can someone advise what is the mistake I am making?
P.S. I am aware I can
Amend the Journal Entries, but out of the desire to learn am trying “the SQL way”