Want to create a Script Report for Salary Slip

Rajat96318 · April 3, 2024, 5:25am

When we have a Draft, Submitted data (basically data is present), then we can make a report (script report etc)
But my problem is I want to make a report of Salary Slip, with the column names as Employee name, Salary Components name (amount as row value)
WITHOUT creating the Salary Slip

Let say i want the report of all employee of April month, but currently i have not made the Salary Slip of employees, the task is to generate the Report before actually making the Salary Slip

Anyone know is it possible, or it can’t be
Open for any suggestion

NCP · April 3, 2024, 7:25am

Hi @Rajat96318,

Based on your requirements, generating a report of Salary Slip details without actually creating the Salary Slips is not feasible. The system requires the existence of Salary Slips to pull data for reports accurately. In other words, since the Salary Slip data is contingent upon the creation of the slips themselves, you cannot generate a report without first creating the Salary Slips for the specified period.

Thank You!

vijaywm · April 4, 2024, 7:00am

check this code…hrms/hrms/payroll/doctype/salary_structure/salary_structure.js at version-14 · frappe/hrms · GitHub

github.com

frappe/hrms/blob/943ec5d888f6a3aba0d727b8d91f562e6555e0ff/hrms/payroll/doctype/salary_structure/salary_structure.py#L315


      
          	if salary_structures_assignments:
          		frappe.msgprint(
          			_(
          				"Skipping Salary Structure Assignment for the following employees, as Salary Structure Assignment records already exists against them. {0}"
          			).format("\n".join(salary_structures_assignments))
          		)
          	return salary_structures_assignments
          
          
          @frappe.whitelist()
          def make_salary_slip(
          	source_name,
          	target_doc=None,
          	employee=None,
          	posting_date=None,
          	as_print=False,
          	print_format=None,
          	for_preview=0,
          	ignore_permissions=False,
          ):
          	def postprocess(source, target):

there is a preview salary slip, so you could try a script report and call make_salary_slip with for_preview = 1, as_print = False for all employees and use the retured doc to make your report