Error while generating "Provident Fund deductions" Report

[goapaints]

Information about bug

Above error while generating deductions report.

Module

Payroll

Version

Frappe Framework: v14.77.1 (HEAD)
ERPNext: v14.70.7 (HEAD)
Frappe HR: v14.28.7 (HEAD)

Installation method

FrappeCloud

Relevant log output / Stack trace / Full Error Message.

### App Versions

{
	"erpnext": "14.70.7",
	"frappe": "14.77.1",
	"goapaints_customization": "0.0.1",
	"hrms": "14.28.7",
	"india_compliance": "14.28.0"
}

Route

query-report/Provident Fund Deductions

Traceback

Traceback (most recent call last):
  File "apps/frappe/frappe/app.py", line 97, in application
    response = frappe.api.handle()
  File "apps/frappe/frappe/api.py", line 55, in handle
    return frappe.handler.handle()
  File "apps/frappe/frappe/handler.py", line 48, in handle
    data = execute_cmd(cmd)
  File "apps/frappe/frappe/handler.py", line 86, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "apps/frappe/frappe/__init__.py", line 1619, in call
    return fn(*args, **newargs)
  File "apps/frappe/frappe/__init__.py", line 815, in wrapper_fn
    retval = fn(*args, **get_newargs(fn, kwargs))
  File "apps/frappe/frappe/desk/query_report.py", line 241, in run
    result = generate_report_result(report, filters, user, custom_columns, is_tree, parent_field)
  File "apps/frappe/frappe/__init__.py", line 815, in wrapper_fn
    retval = fn(*args, **get_newargs(fn, kwargs))
  File "apps/frappe/frappe/desk/query_report.py", line 93, in generate_report_result
    res = get_report_result(report, filters) or []
  File "apps/frappe/frappe/desk/query_report.py", line 74, in get_report_result
    res = report.execute_script_report(filters)
  File "apps/frappe/frappe/core/doctype/report/report.py", line 128, in execute_script_report
    res = self.execute_module(filters)
  File "apps/frappe/frappe/core/doctype/report/report.py", line 145, in execute_module
    return frappe.get_attr(method_name)(frappe._dict(filters))
  File "apps/hrms/hrms/payroll/report/provident_fund_deductions/provident_fund_deductions.py", line 11, in execute
    data = get_data(filters)
  File "apps/hrms/hrms/payroll/report/provident_fund_deductions/provident_fund_deductions.py", line 120, in get_data
    entry = frappe.db.sql(
TypeError: Database.sql() got multiple values for argument 'as_dict'

Request Data

{
	"type": "GET",
	"args": {
		"report_name": "Provident Fund Deductions",
		"filters": "{\"company\":\"Goa Paints & Allied Products Pvt. Ltd.\",\"month\":\"7\",\"year\":\"2024\"}",
		"ignore_prepared_report": false,
		"are_default_filters": false
	},
	"headers": {},
	"error_handlers": {},
	"url": "/api/method/frappe.desk.query_report.run"
}

Response Data

{
	"exception": "TypeError: Database.sql() got multiple values for argument 'as_dict'"
}

### Code of Conduct

- [X] I agree to follow this project's Code of Conduct

[frappe-pr-bot]

🎉 This issue has been resolved in version 14.29.3 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀

[frappe-pr-bot]

🎉 This issue has been resolved in version 15.25.2 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀