Getting error on Provident Fund Deduction on erpnext v14

App Versions

	"erpnext": "14.0.0-dev",
	"frappe": "14.0.0-dev",
	"hrms": "0.0.1",
	"payments": "0.0.1",
	"whitelabel": "0.0.1"


query-report/Provident Fund Deductions


Traceback (most recent call last):
  File "apps/frappe/frappe/", line 69, in application
    response = frappe.api.handle()
  File "apps/frappe/frappe/", line 54, in handle
    return frappe.handler.handle()
  File "apps/frappe/frappe/", line 45, in handle
    data = execute_cmd(cmd)
  File "apps/frappe/frappe/", line 83, in execute_cmd
    return, **frappe.form_dict)
  File "apps/frappe/frappe/", line 1598, in call
    return fn(*args, **newargs)
  File "apps/frappe/frappe/", line 782, in wrapper_fn
    retval = fn(*args, **get_newargs(fn, kwargs))
  File "apps/frappe/frappe/desk/", line 253, in run
    result = generate_report_result(report, filters, user, custom_columns, is_tree, parent_field)
  File "apps/frappe/frappe/", line 782, in wrapper_fn
    retval = fn(*args, **get_newargs(fn, kwargs))
  File "apps/frappe/frappe/desk/", line 87, in generate_report_result
    res = get_report_result(report, filters) or []
  File "apps/frappe/frappe/desk/", line 68, in get_report_result
    res = report.execute_script_report(filters)
  File "apps/frappe/frappe/core/doctype/report/", line 142, in execute_script_report
    res = self.execute_module(filters)
  File "apps/frappe/frappe/core/doctype/report/", line 159, in execute_module
    return frappe.get_attr(method_name)(frappe._dict(filters))
  File "apps/hrms/hrms/payroll/report/provident_fund_deductions/", line 11, in execute
    data = get_data(filters)
  File "apps/hrms/hrms/payroll/report/provident_fund_deductions/", line 113, in get_data
  File "apps/frappe/frappe/database/", line 209, in sql
    self._cursor.execute(query, values)
  File "env/lib/python3.10/site-packages/pymysql/", line 148, in execute
    result = self._query(query)
  File "env/lib/python3.10/site-packages/pymysql/", line 310, in _query
  File "env/lib/python3.10/site-packages/pymysql/", line 548, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "env/lib/python3.10/site-packages/pymysql/", line 775, in _read_query_result
  File "env/lib/python3.10/site-packages/pymysql/", line 1156, in read
    first_packet = self.connection._read_packet()
  File "env/lib/python3.10/site-packages/pymysql/", line 725, in _read_packet
  File "env/lib/python3.10/site-packages/pymysql/", line 221, in raise_for_error
  File "env/lib/python3.10/site-packages/pymysql/", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'component_type' in 'field list'")

Request Data

	"type": "GET",
	"args": {
		"report_name": "Provident Fund Deductions",
		"filters": "{\"company\":\"HUI COASTAL BREWERY & DISTILLERY LIMITED\",\"month\":\"8\",\"year\":\"2022\"}"
	"headers": {},
	"error_handlers": {},
	"url": "/api/method/"

Response Data

	"exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'component_type' in 'field list'\")"

Have you found any solution?
i amgetting same error in Provident Fund Deductions eport

Error: pymysql.err.OperationalError: (1054, “Unknown column ‘component_type’ in ‘field list’”)
I am on Version 13.15


Have you found any solution @Ubaid_Khanzada. I am getting same error

No, I am still searching for it.