SQL Payroll - Releases

SQL Payroll 1.2020.182.158


Released on March 6, 2020

Release Notes

  • Upgrade Database to Version 103

  • Add PR.Tax.Lampiran B - Format 3

  • Add PR.Zakat.BorangSkimBerkat-Kelantan format

  • Enable user Self Define Body Email & Subject for EC 2019 & 2020

  • Increase PCB Receipt No. Size for PR.Tax.PCB2(II)-2012 format

  • Add PR.Tax.CP8D-2019-BorangE - Part A format

  • Fixed PR.Tax.CP8D-2019 page 2 header not update

  • #5401: Reduce employee EPF rate to 7% with effect from 1 Apr 2020 to 31 Dec 2020

  • #5378: Prevent user unchecked PCB if allowance had assigned with tax code when edit employee paysheet

  • Fix cloud server employee data not up to date after sync due to employee record rowver not increase after append, update or delete detail dataset record

  • #5391: Marital status column of each employee record is blank in income tax lampiran 2 text file

SQL Payroll 1.2020.181.157


Released on January 10, 2020

Release Notes

  • Add income tax calculation for year 2020

  • #5369: Change employee country to non "MY" auto uncheck resident

  • #5368: Prompt message when contribution EPF rate is below statutory contribution rate

  • #5367: Allow user to group payment summary by branch, department, hrgroup or category (either one)

  • #5373: Alliance BizSmart Bulk Payment - Add "Payment Advice Indicator" option

  • Fix cloud server data not up to date due to change code of master data

  • Add PT.Compensation.Report

SQL Payroll 1.2019.180.156


Released on December 10, 2019

Release Notes

  • Upgrade Database to Version 102. - Tunning HR_LO_TRANS table

  • Add Compensation Column for PR.Summary.Grouped.Report 1 format

  • Rename PR.Summary.Grouped.Report to PR.Summary.Grouped.Report 1 format

  • Add PR.Summary.Grouped.Report 2 format

  • Add HR.Employee.Appointment.Report-BM format

  • Fixed PR.Yearly.IndividualPay.Report Detail Overlap when use Merge Options

  • Fixed OT Description unable fully shown for PR.Payslip1A.Report-V2 & PR.Payslip1C.Report-V2 format

  • Add HR.Employee.Report-BM, PR.Payslip1A.Report-V2-BM and PR.Payslip1C.Report-V2-BM format

  • Add PR.Payslip1C.Report-V2 format

  • Add Summary OT for PR.Payslip1A.Report-V2 format

  • Add overtime summary dataset to payslip report

  • Add No. of Working Days for PR.Payslip1A.Report-V2

  • Fixed PR.Tax.CP22 Spouse Tax Number not fully shown

SQL Payroll 1.2019.179.155


Released on November 5, 2019

Release Notes

  • #5356: EPF, SOCSO and income tax output file detail records not same as grid filtered records

  • Fix sync cloud prompt error could not convert variant of type (null) into type (integer)

  • #5355 Process payroll based on filtered employee list

SQL Payroll 1.2019.179.154


Released on October 23, 2019

Release Notes

  • Upgrade Database to Version 101 - Tunning Table SY_PROFILE & PT_UL table

  • Feature #5346: Income tax reports sort by employee name

  • Fix number of reports exclude from top 5 employees restriction

  • Increase field length for company Name for PR.Tax.PCB2(II)-2012

  • #5350: Apply payroll summary report prompt error "column unknown" if group by project, job or task

  • #5348: Add rate to pending unpaid leave

  • Feature #5267: Click "Print PCB" label open built-in PCB calculation if no internet connection

esoft sql.png