SQL Payroll Latest Version (v156) Date : 10/12/2019

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 Latest Version (v155) Date : 05/11/2019

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 Latest Version (v154) Date : 23/10/2019

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

SQL Payroll Latest Version (v153) Date : 03/10/2019

SQL Payroll 1.2019.177.153

Released on October 3, 2019

Release Notes

• Upgrade Database to Version 100 - Add PT_CP table
• #5336: Payroll summary report unable to sort by employee name
• #5104: Remove unused "Inquiry" menu
• Add #5307: Tax exemption on compensation for loss of employment
• #5334: Add bank code for Islamic banks
• #5345: Open and close employee payroll windows prompt error "Cannot focus a disabled or invisible window"

SQL Payroll Latest Version (v152) Date : 28/08/2019

SQL Payroll 1.2019.176.152

Released on August 28, 2019

Release Notes

• Upgrade Database to Version 99 - Tunning SY_USER table
• Update PR.EPF.BorangA.2009.Report No Rujukan Borang A format
• Fix incorrect account number of detail record of Affin bank AutoPay text file format
• Allow user choose to include employee payroll info before sync to server
• Add data import from EMAS payroll
• Add Unpaid Leave detail to sub report 3 for PR.Payslip1A.Report format

SQL Payroll Latest Version (v151) Date : 20/08/2019

SQL Payroll 1.2019.175.151

Released on August 20, 2019

Release Notes

• Enhance & Retuning Report
• Fix #5287: Unable to display message with unicode string on payslip report
• Fix #5289: Incorrect length of SOCSO account number column of AmBank AutoPay SOCSO text file format
• Fix leave application cloud_autokey always null after sync if the leave application created by user

SQL Payroll Latest Version (v150) Date : 05/08/2019

SQL Payroll Releases

SQL Payroll 1.2019.174.150

Released on August 5, 2019

Release Notes

• Upgrade Database to Version 98
• Fix LV.Yearly Title not show correctly
• Fix unable to select field names when uses CSV data import due to commit 4cdd8608 "Set default filter windows to Excel mode"
• Feature #5282: Prompt message to user if apply leave application on the same date exceed 1 day
• Feature #5265: Store STD calculator method for each employee payroll after process

SQL Payroll Latest Version (v149) Date : 26/07/2019

SQL Payroll Releases

SQL Payroll 1.2019.173.149

Released on July 26, 2019

Release Notes

• Upgrade Database to Version 97
• Tuning LV_APP table
• Feature #5216: Add income tax Lampiran B report for year 2019
• Add PR.Tax.Lampiran B - Format 1 & Format 2
• Add PR.Summary-30C-L2.Report 
• Add Sub Detail for Yearly Individual Pay report
• Fix unable to delete employee due to there is leave application with leave day 0 before sync to server
• Fix bug #5254: Current month additional remuneration no separate to bonus, commission, director fees and others when pre-fill data on IRB calculator
• Feature #5206: Add AmBank Net Payroll EIS text file format
• Fix missing trailing spaces on receiver name column of Affin bank CIB Bulk Payment text file format
• Fix missing 6 spaces on trailer record of Affin bank AutoPay text file format
• #5235: OCBC bank EPF text file format "Employee Identification No column is blank if the employee has passport number only
• #5247: Incorrect amount of deduction summary due to same cube cell ID even though employees code are unique
• Fix Hong Leong bank Connect BIZ EIS payment column B of header and detail header are blank

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.

SQL Payroll Latest Version (v140) Date : 12/10/2018

SQL Payroll Latest Version (140)
Information
Last updated: 12/10/2018
Current version: 1.2018.159.140

Release notes

• Add LV.Balance.Report-Leave Application
• Fix LV.Balance.Report-Employee Performance preview error
• Change leave balance report day columns footer summary kind to sum
• Adjust UOB Interbank Giro and Inter Account Fund Transfer file format due to file control header and batch details exceed 1802 columns
• Feature #4708: Add CIMB Bulk Payment with Email Notification file format
• #4740: Enter leave application with day as time more than 8 hours will reset to 0 hour
• Add Hong Leong bank Connect First file format
• #4758: Alliance bank BizSmart Bulk Payment excel "Beneficiary Old IC No" column spelling error
• #4741: Change date of annual leave prompt error "payroll already closed, apply unpaid leave is not allowed"
• #4739: Incorrect file name of Public bank ECP excel file