SQL Payroll Latest Version (v148) Date : 03/07/2019

SQL Payroll Releases

SQL Payroll 1.2019.172.148

Released on July 3, 2019

Release Notes

• Fill employee name line 2 continuation from employee name line 1 if employee name exceed 40 characters
• Fix Hong Leong bank Connect BIZ SOCSO payment excel file format "Member SOCSO No" column cannot leave blank
• Adjust implementation of leave application data item
• Fix sync error of approved leave application
• #5221: Missing records in IRB payment file format
• #5209: Pre-filled data for verification in LHDN calculator

SQL Payroll Latest Version (v147) Date : 17/06/2019

SQL Payroll 1.2019.168.147

Released on June 17, 2019

Release Notes

• Upgrade Database to Version 96 - Add HR_EMP_MGR table
• Fix income tax lampiran 2 report contains record "zakat from deduction" even though the actual deduction without subject to zakat deduction
• Add HR.Employee.Payment By Cash Letter
• #5178: Display error on tax rate percentage when preview PCB calculation
• #5170: Add commission to non month end payroll will calculate PCB amount even though the payroll processed without calculate PCB
• #5172: Unable to remove temporary tables after process payroll
• Allow user to change post date of pending leave application via sync cloud; exclude cancelled leave application before display on grid
• Feature #5162: Add Affin bank EIS text file format
• Add Affin bank CIB Bulk Payment text file format
• #5177: Application always start with default theme even though user already disabled the theme
• #5100: Add RHB bank BulkPay Payroll file format
• #5099: Add RHB bank BulkPay Statutory Payment file format
• Add support of manager by branch or department

SQL Payroll Latest Version (v146) Date : 07/05/2019

SQL Payroll Latest Version (146)

Information
Last updated: 07/05/2019
Current version: 1.2019.167.146

Release notes

• Fixed HR.Employee.Listing Export Excel Allowance empty
• Fixed HR.Employee.Increment.Report Export to Word content overlap
• Add Employee Socso no in NRIC column for PR.SOCSO.Borang8A(201407).Report
• Add income tax EA, EC, CP8D and eData Praisi reports for year 2019
• Add Payable HRDF amt for PR.HRDF-HRDFOnly
• Feature: Default theme set as stardust
• Add data import from a zip file contains multiple csv files - File | Import Data | Batch Import.
• Feature #5153: Add EcoTimePrint under File | Import Data
• Feature #5106: Add AmBank AutoPay Payroll EIS text file format
• Update AmBank AutoPay Payroll text file format based on version 4.1
• Feature #5136: Add OCBC bank EIS text file format

SQL Payroll Latest Version (v145) Date : 02/04/2019

SQL Payroll Latest Version (145)

Information
Last updated: 02/04/2019
Current version: 1.2018.166.145

Release notes

• Database upgrade to version 95. - Tunning PR_AL, PR_CONTRIB, SY_DIY_OBJECT, SY_DIY & PT_TD Tables
• Fixed PR.Tax.BorangEA-2018 & 2019 -English - Column B3 & B4 line overlap with amount
• Add income tax Lampiran 2 report
• Fix #5019: Employee tax category is blank when preview payroll yearly individual report
• Fix "Myco ID/SSM Number" column of EIS Lampiran 1 text file format can contains only characters A-Z and 0-9
• Fixed PR.Tax.CP8D-2016 & 2017 field mapping error
• Fixed PR.Tax.CP8D-2018 export excel all font in white color
• Enable Batch Email for PR.Tax.PCB2(II)-2012
• Enlarge the Receipt No field to support up to 18 char for PR.Tax.PCB2(II)-2012
• Feature #5066: Auto add allowance contribute to PCB if employee SOCSO borne by employer
• Add EA Form to Sync Cloud
• Add Hong Leong bank Connect BIZ EIS excel file format
• Generate Public bank ECP excel file with .xlsx extension
• Add Affin bank AutoPay text file format

SQL Payroll Latest Version (v144) Date : 18/02/2019

SQL Payroll Latest Version (144)

Information
Last updated: 18/02/2019
Current version: 1.2018.164.144

Release notes

• Database upgrade to version 92. - Tunning SY_Profile Table
• Feature #4981: RHB EIS excel file format
• Feature #4996: Public bank EIS text file format
• Feature #5012: CIMB EIS text file format
• Feature #4974: Alliance bank EIS text file format
• Feature #4979: Change SOCSO type to "Second Category" auto change the EIS type to "No"
• Fixed PR.Tax.CP8D-2017 & PR.Tax.CP8D-2018 some total field not correct when more then 1 page
• #5001: Preview leave entitlement report prompt error access violation
• #4987: Payroll summary report show tax exemption of the process after user edit paysheet even though the process no calculate PCB
• #4992: Yearly payroll report | Yearly employer EIS , system no capture the new amended Employer EIS Amount.
• Fixed PR.Tax.CP8D-2017 & PR.Tax.CP8D-2018 field mapping not correct column
• Fixed PR.Tax.CP8D-2018-BorangE not correct year
• Fix PR.Tax.PCB2(II)-2012 format alignment problem
• Add PR.Tax.CP8D-2018 & PR.Tax.CP8D-2018-BorangE format
• Fixed PR.Tax.BorangEA-2019-BM.Report EA word not Fully shown
• #4985: Change employee SOCSO on paysheet prompt error "Interface not supported"

SQL Payroll Latest Version (v142) Date : 11/01/2019

SQL Payroll Latest Version (142)

Information
Last updated: 11/01/2019
Current version: 1.2018.162.142

NEW FEATURES:
• Database upgrade to version 92.
• Add PCB calculation for year 2019.
• Add Maybank2E-RC Universal Payment EIS text file format.
• Rename "Print Income Tax Lampiran B" to "Print Income Tax Lampiran B (PCB Audit)."
• Replace "ID Number" column with "New IC" column for SOCSO text file format.
• Reduce employer share of EPF contribution rate for post-retirees from 6% to 4%.
• Employer must make SOCSO contribution for foreign workers.
• Sync to Cloud.
Fixed bug list:
• Apply payroll summary (work unit) report prompt error "list index out of bound".
• CIMB Bulk Payment with Email Notification file format - "Payment Reference Number" column is empty, "Total Amount" column always zero amount.
• Incorrect average leave entitlement calculated if the employee with join date fall after January of the .
• UOB Interbank Giro and Inter Account Fund Transfer file format - "Beneficiary Resident Indicator" column is empty.
• Employee marital status can set as blank.

SQL Payroll Latest Version (v141) Date : 23/10/2018

SQL Payroll Latest Version (141)

Information
Last updated: 23/10/2018
Current version: 1.2018.161.141

Release notes

• Adjust implementation of AmBank AutoPay Payroll file format.
• #4795: Incorrect description of detail record of payment voucher after import.
• #4819: Public bank ECP Excel 3 - Column F is empty if the employee record with passport number only.