UK Check/Cheuqe Payslip Report
UK Cheque payslip report query
I am adding the SQL query for custom cheque payslip report.
Employee will have the payment method as cheque or BACS but functionality wise they can override and we cannot just check employee personal payment method for cheque generation as that is the setup but the result might be different if they override. So ideally the prepayment results need to be used to get the payment method for the employee and the personal payment method can be a cross verification one.
Personal payment methods might be set as BACS for employees but they can override the payment method during payroll calculation and whatever they selected during payroll is what need to be generated for the employee.