Opening balance entry listing of accounts

1

We would like to record our opening account balances manually via a journal entry. According to help video the whole chart of account should appear once selected type of journal entry “opening”.

This is not the case with us? What are we missing?

2

This feature was removed from the code in ERPNext v13
if you use v12 it will work as in the documentation

erpnext/erpnext/accounts/doctype/journal_entry/journal_entry.js at version-12 · frappe/erpnext (github.com)

as a work around you can add this code to a client side script or to your custom app

frappe.ui.form.on('Journal Entry', {
    voucher_type: function(frm) {
        if (frm.doc.voucher_type === "Opening Entry") {
            frm.clear_table("accounts");
            frappe.call({
                method: "frappe.client.get_list",
                args: {
                    doctype: "Account",
                    fields: ["name","report_type"],
                    limit_page_length: 9999999,
                    filters: {
                        report_type: ['in', ['Balance Sheet']],
                        is_group: 0,
                        company: frm.doc.company,
                    }
                },
                callback: function(r) {
                    if (r.message) {
                        r.message.forEach(function(account) {
                            var row = frappe.model.add_child(frm.doc, "Journal Entry Account", "accounts");
                            row.account = account.name;
                            row.debit = 0;
                            row.credit = 0;
                        });
                        frm.refresh_field("accounts");
                        cur_frm.set_value("is_opening", "Yes");
                    }
                }
            });
        }
    }
});

feel free to customize the code or edit it to fit your needs.