General Ledger KeyError: 'from_date'

1

Installed Apps
ERPNext: v11.x.x-develop (5899d98) (develop)
Frappe Framework: v11.x.x-develop (7249433) (develop)

Account → Profit and Loss → Sales → Ledger

Traceback (most recent call last):
  File "/home/erpnext/erpnext/apps/frappe/frappe/app.py", line 62, in application
    response = frappe.handler.handle()
  File "/home/erpnext/erpnext/apps/frappe/frappe/handler.py", line 22, in handle
    data = execute_cmd(cmd)
  File "/home/erpnext/erpnext/apps/frappe/frappe/handler.py", line 55, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "/home/erpnext/erpnext/apps/frappe/frappe/__init__.py", line 942, in call
    return fn(*args, **newargs)
  File "/home/erpnext/erpnext/apps/frappe/frappe/desk/query_report.py", line 96, in run
    res = frappe.get_attr(method_name)(frappe._dict(filters))
  File "/home/erpnext/erpnext/apps/erpnext/erpnext/accounts/report/general_ledger/general_ledger.py", line 39, in execute
    res = get_result(filters, account_details)
  File "/home/erpnext/erpnext/apps/erpnext/erpnext/accounts/report/general_ledger/general_ledger.py", line 102, in get_result
    gl_entries = get_gl_entries(filters)
  File "/home/erpnext/erpnext/apps/erpnext/erpnext/accounts/report/general_ledger/general_ledger.py", line 136, in get_gl_entries
    filters, as_dict=1)
  File "/home/erpnext/erpnext/apps/frappe/frappe/database.py", line 199, in sql
    self._cursor.execute(query, values)
  File "/home/erpnext/erpnext/env/lib/python2.7/site-packages/pymysql/cursors.py", line 168, in execute
    query = self.mogrify(query, args)
  File "/home/erpnext/erpnext/env/lib/python2.7/site-packages/pymysql/cursors.py", line 147, in mogrify
    query = query % self._escape_args(args, conn)
KeyError: 'from_date'

or

Account → General Ledger

Traceback (most recent call last):
  File "/home/erpnext/erpnext/apps/frappe/frappe/app.py", line 62, in application
    response = frappe.handler.handle()
  File "/home/erpnext/erpnext/apps/frappe/frappe/handler.py", line 22, in handle
    data = execute_cmd(cmd)
  File "/home/erpnext/erpnext/apps/frappe/frappe/handler.py", line 55, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "/home/erpnext/erpnext/apps/frappe/frappe/__init__.py", line 942, in call
    return fn(*args, **newargs)
  File "/home/erpnext/erpnext/apps/frappe/frappe/desk/query_report.py", line 96, in run
    res = frappe.get_attr(method_name)(frappe._dict(filters))
  File "/home/erpnext/erpnext/apps/erpnext/erpnext/accounts/report/general_ledger/general_ledger.py", line 39, in execute
    res = get_result(filters, account_details)
  File "/home/erpnext/erpnext/apps/erpnext/erpnext/accounts/report/general_ledger/general_ledger.py", line 102, in get_result
    gl_entries = get_gl_entries(filters)
  File "/home/erpnext/erpnext/apps/erpnext/erpnext/accounts/report/general_ledger/general_ledger.py", line 136, in get_gl_entries
    filters, as_dict=1)
  File "/home/erpnext/erpnext/apps/frappe/frappe/database.py", line 199, in sql
    self._cursor.execute(query, values)
  File "/home/erpnext/erpnext/env/lib/python2.7/site-packages/pymysql/cursors.py", line 168, in execute
    query = self.mogrify(query, args)
  File "/home/erpnext/erpnext/env/lib/python2.7/site-packages/pymysql/cursors.py", line 147, in mogrify
    query = query % self._escape_args(args, conn)
KeyError: 'from_date'

How to fix it ?

2

I found this :

From KeyError - Python Wiki

Python raises a KeyError whenever a dict() object is requested (using the format a = adict[key]) and the key is not in the dictionary.

Check the JS file of the general ledger report. Is from_date defined there or not ?

3

from_date is present in general ledger js

4

Is this error solved or still there ?

I hate to say this but does bench update and start after it solve this ? Or if already solved please post the steps.

5

check the filters in general_ledger.js

6

from_date is present in js, running latest version but error still present

7

@Yogesh_Sharma

I checked the code and it could be a bug. Why not raise a issue at Github ?

It is possibly related to how from_date is being substituted into the query.

8

That happen when the report name is different in the .js and .json files. Check that and reload.

9

Finally got a chance to update to latest and issues is resolved.

ERPNext: v11.x.x-develop (8448d90) (develop)
Frappe Framework: v11.x.x-develop (d2ce42f) (develop)

1 Like