Hello, I am having a lot of time validating Journal Vouchers in ERPNext, most of those JV came from a upload via template (last year journals megration to a new system from a really old one), I try running in MariaDB:
UPDATE tabJournal Entry
SET docstatus = 1 WHERE docstatus = 0;
With that the Journal Voucher apears like presented in the JV list but it is not taken into acount in Reports like General Ledger, Balance Sheet and Profits and Lost.
Is there a way to present Journal Vouches by Batch?