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 clear-cache
, bench clear-website-cache
, 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 Cancel
‘n’ Amend
the Journal Entries, but out of the desire to learn am trying “the SQL way”