How can i optain Salary slip report with all components or just a component and its value of all employee with help of Query Reports?

, , ,
2

Hi there,

Both Earnings and Deductions are tables that store data in the Salary Detail child doctype (called tabSalary Detail in mariadb). To get that data, you just need to do a join in your sql query on tabSalary Slip.name = tabSalary Detail.parent