General Balance Bug


When I try to access general balance, I simply get this bug, with nothing in the screen :

Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/", line 55, in application
    response = frappe.handler.handle()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/", line 20, in handle
    data = execute_cmd(cmd)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/", line 55, in execute_cmd
    return, **frappe.form_dict)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/", line 1007, in call
    return fn(*args, **newargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/", line 489, in wrapper_fn
    retval = fn(*args, **get_newargs(fn, kwargs))
  File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/", line 174, in run
    result = generate_report_result(report, filters, user)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/", line 65, in generate_report_result
    res = frappe.get_attr(method_name)(frappe._dict(filters))
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/trial_balance/", line 15, in execute
    data = get_data(filters)
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/trial_balance/", line 71, in get_data
    filters.to_date, min_lft, max_rgt, filters, gl_entries_by_account, ignore_closing_entries=not flt(filters.with_period_closing_entry))
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/", line 359, in set_gl_entries_by_account
  File "/home/frappe/frappe-bench/apps/frappe/frappe/database/", line 117, in sql
    query = re.sub(r'ifnull\(', 'coalesce(', query, flags=re.IGNORECASE)
  File "/home/frappe/frappe-bench/env/lib/python2.7/", line 155, in sub
    return _compile(pattern, flags).sub(repl, string, count)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 74: ordinal not in range(128)


It has been corrected in the latest v11 beta version. Just update and you should be fine.

Have a nice evening!

Hi thank you,

How Can I update without loosing data ?


Hi @Chaibi_Alaa,

This is just a report (a data display) so there should be no data loss linked to the report update itself.

If you do a simple bench update it should do the job.

Have a nice day,