Is it possible to optain Salary slip report with all components and its value of all employee with help of Query Reports?

I was trying to find a solution for exporting salary slips in to a single excel sheet with all components and its value. I came to know that there is no option to export salary slip in such a way.

So i was curious about Reports section we have in ERPNext whether it is possible to create a Query Report for Salry Slip.

Is it possible to fetch the employee salary slip with components and its values from the database itself ? If it is possible from which database table i can fetch those data ??

Please help!!

@rajeeb,

Yes, It Possible.

Salary Slip is associated with two tables first one is “tabSalary Slip” and second one is “tabSalary Detail”.

1 Like