fix: query for salary component in salary structure
fix: query for salary component in salary structure
diff --git a/erpnext/payroll/doctype/salary_structure/salary_structure.py b/erpnext/payroll/doctype/salary_structure/salary_structure.py
index bf1c746..e718031 100644
--- a/erpnext/payroll/doctype/salary_structure/salary_structure.py
+++ b/erpnext/payroll/doctype/salary_structure/salary_structure.py
@@ -217,8 +217,12 @@
select t1.salary_component
from `tabSalary Component` t1, `tabSalary Component Account` t2
where (t1.name = t2.parent
- and t1.type = %s
- and t2.company = %s)
- or (t1.statistical_component = 1)
+ and t1.type = %(type)s
+ and t2.company = %(company)s)
+ or (t1.type = %(type)s
+ and t1.statistical_component = 1)
order by salary_component
- """, (filters['type'], filters['company']))
+ """,{
+ "type": filters['type'],
+ "company": filters['company']
+ })