SQL Payroll Latest Version (v174) Date : 23/10/2021

SQL Payroll 1.2021.206.174

Released on October 23, 2021

Release Notes

• Add GetTitle option & Parameter pipeline for Batch Email in EA for 2019 to 2021
• Add GetMonth & GetTitle Option for Batch Email in Payslip
• Fix Number of bank file formats are invalid
• #5572: Bank EPF file format detail record employee name column value missing a character when employee name length exceed 40 characters
• Add Grand Total for Remuneration column for EIS, EPF & Socso List report
• Revise bank excel file formats only assign cell object string value when value is not empty
• Adjust leave application rule to allow insert leave taken and leave replacement on the same date

SQL Payroll Latest Version (v173) Date : 25/09/2021

 

SQL Payroll 1.2021.205.173

Released on September 25, 2021

Release Notes

• Fix HRDF report amount not calculated when remuneration less than 0
• Fixed PR.Payslip1C.Report-V2 payslip detail for AL, DE & UL not match with Header Amount
• Bug #5566: Income tax CP22A report incorrect number of children
• Fixed PR.EPF.List.Report Remuneration is empty
• #5567: Resigned employee deduction calculated with wage, ot and unpaid leave in column B1 in CP22A
• Fix payroll sync to address GetMemDS throw error
• Fixed HR.Employee.Payment By Cash Letter batch print footer employee name not correctly shown
• Reduce Row usage on export to excel for PR.Summary.Grouped-L1.Report 1
• Add support of preview payment voucher or journal entry before save to file
• Add cloud claim report
• #1636: Add Rate column in bonus to calculate amount
• Database upgrade to version 112

SQL Payroll Latest Version (v172) Date : 13/08/2021

 

SQL Payroll 1.2021.204.172

Released on August 13, 2021

Release Notes

• #5563: Add payment method parameter in coinage report
• Reduce Column Usage on Export to excel & add contribution No for EFF, EIS, Socso & Tax List report
• Adjust grid view column auto width property for pending payroll entry forms
• Fixed unable to link e claim for 1st time setting

SQL Payroll Latest Version (v171) Date : 02/08/2021

SQL Payroll 1.2021.203.171

Released on Aug 02, 2021

Release Notes

• Fixed LV.Yearly.Report reduce Row on export to Excel
• #5554: Leave inquiry prompt "Dynamic SQL error"
• Fixed PR.Zakat-Penang format unable shown record more then 26 employee
• #5555: Show negative symbol on Payroll Yearly Report
• Revise RHB Bank SOCSO Format
• #5553: Upload AffinMax AutoPay text file to bank return errors
• #5552: PCB amount not round up when employee is non-resident and remuneration with cents
• #5556: Upload AffinMax Corporate IBG excel file to bank return error
• #5557: PCB amount is not correct when accumulated remuneration greater than 0 and current month allowance with tax code contribute to PCB (A)
• #5558: Fixed Incorrect CR and DR posting for HRDF JE and Accrual
• #5526: Income tax CP8D and eData Praisi reports added "Gross Remuneration - Without Cents" column
• Prompt warning when changing payroll opening amount after payroll was processed

SQL Payroll Latest Version (v170) Date : 18/06/2021

SQL Payroll 1.2021.201.170

Released on Jun 18, 2021

Release Notes

• Update Pending Reports - Reduce Column Usage on Export to Excel
• Update Maintenance Reports - Reduce Column Usage on Export to excel
• Add PR.Tax.List.Report format
• #5483: Auto +60 if mobile number contains only 0..9
• Feature #5546: HRDF levy exemption for year 2021
• #5545: Fixed total AL taken exceed entitled message prompt
• #5537: Change some format specification on Maybank Bulk Payment
• Add Public Bank Excel format for EPF, SOCSO, TAX
• #5538: Add 'Print HRDF' button to Month End for December
• Revise AffinMax AutoPay Excel and AffinMax CorporateIBG Excel
• Add Sync Cloud access right
• #5536: Access Right for Print Loan Repayment History

SQL Payroll Latest Version (v169) Date : 21/05/2021

 

SQL Payroll 1.2021.200.169

Released on May 21, 2021

Release Notes

• Update PR.Tax.CP22A to support ESOS in Tax Benefit
• Update PR.Tax.LampiranB to support ESOS in Tax Benefit
• Update CP8D 2016 to 2020 to support ESOS in Tax Benefit
• #5520: Add on 'Pampasan kerana kehilangan kerja' to total in CP21, CP22A, CP22B
• Add PR.Tax.CP21-2021 format & fix PR.Tax.CP21-2015 error on preview
• #5495: Income tax CP8 report B2 column exclude tax benefit amount
• Fixed CP8D format export to excel font become white color
• #5514: Add "Employee Share Option Scheme" tax benefit
• Feature #5533: Calculate unpaid leave amount using formula default wage / 26
• #5535: Uncheck HRDF when create new commission code
• #5534: Grid filters out newly marked as rejected leave if "Show Rejected Record" property is false
• #5532: Add Ambank-Access Biz format
• Add New Excel class for EPF, SOCSO, EIS, CP39 and Zakat
• #5525: Add AffinMax Statutory Text format
• #5528: Change Bank Swift Code to Bank Name in Maybank Bulk Payment
• Update HSBC bank code list
• #5527: Allowance work unit is zero after process payroll due to fixed allowance rate is zero
• Public bank excel file format "Total Amount" column doesn't have formula
• #5522: Add AffinMax AutoPay Excel, AffinMax AutoPay Text
• #5521: Delete and reprocess employee payroll prompt error "Employee payroll already closed"
• #5517: Prompt reminder when exceed leave limit including forward date taken
• Add income tax EA data cloud sync for year 2019 & 2020
• #5512: Generate journal entry for employer contribution accrual include HRDF

SQL Payroll Latest Version (v168) Date : 06/04/2021

 

SQL Payroll 1.2021.199.168

Released on April 6, 2021

Release Notes

• Upgrade Database Version 111
• Add PR.Payslip3A.Report-V2 format
• Income tax CP8D report column I return unexpected value when there is compensation record
• Fix display mistake on yearly individual report title
• #5506: Added Min Remuneration per Month to Lampiran B
• Add Total Amount for PR.Tax.CP21-2015
• Fixed CP8D-2020 Grand Total Amount for Column R no decimal point
• Add "Company ID From BIB" parameter to UOB Bulk Payment file format
• #5507: Allow user to delete income tax EA & EC customized
• Pending overtime calculate system pay rate return zero
• #5208 : Sort past payroll with descending order
• #5383: Added check duplicate rest day or public holiday upon click save
• Rename Affin bank AutoPay Excel 2 to AffinMax Corporate IBG Excel
• #5510: History records are appended into incorrect employee master when use batch editor
• #5503: Adjust leave application inquiry window
• #5504: Remove Open Leave History window
• #5502: Remove country code from mobile no. for bank file export
• Fix Employee payroll right click open payroll info does nothing
• Fix UOB IBG file format File Control Header record "File Name" field is empty

SQL Payroll Latest Version (v167) Date : 05/03/2021

 

SQL Payroll 1.2021.197.167

Released on March 5, 2021

Release Notes

• #5501: RHB Bank incorrect Batch Number
• #5499: Public Bank ECP Text (BIF) incorrect Bank Rakyat bank code
• #5485: Update Maybank file format names

SQL Payroll Latest Version (v166) Date : 26/02/2021

 

SQL Payroll 1.2021.197.166

Released on February 26, 2021

Release Notes

• Upgrade Database to Version 110
• Add TaxCode column for Yearly Allowance, Code column for Yearly Tax Benefit and Yearly Tax Deduction
• Fixed CP8D for 2016 - 2020 grand total not correctly sum in some scenario
• Add Lampiran B format 4
• Feature #5497: Income tax lampiran B report add SOCSO and EIS field
• Fixed TP1 from 2017 to 2021 wrong Field mapping
• Feature #1484: Paid leave support auto calculate rate
• Feature #5359: Add Note member to claim tran
• #5492: Resize note and photo components on Employee.EF
• Feature #5490: Update Maybank2E-RC Universal Payment file format based on version 6.0, Maybank hash formula
• Add OTContribDS variable to calculate overtime payrate script

SQL Payroll Latest Version (v165) Date : 30/01/2021

SQL Payroll 1.2021.193.165

Released on January 30, 2021

Release Notes

• Upgrade Database to Version 109.
• #5475: Allowance tax code does not refresh based on master setting
• #5474: Pending tax benefit records with invalid code can be inserted through import data

SQL Payroll Latest Version (v164) Date : 23/01/2021

SQL Payroll 1.2021.191.164

Released on January 23, 2021

Release Notes

• Upgrade Database to Version 108.
• Add HR.Employee.Register.Report format
• #5463: Preview tax receipt prompt error access violation
• Feature #5465: Add Tax Benefit and Country datasets to income tax CP22 report
• Add CP22, CP22A & CP22B 2021 format
• Fixed PR.Summary.Grouped-.Report 2 Display Format not consistent
• Add CP8D 2020 Format
• Reduce Column Usage on Export to excel HR.Employee Reports
• #5469: Message box doesn't show until press Alt key
• #5470: Copy to excel prompt error index out of bounds when select all employees on browse form
• Feature #5415: Add Maybank Bulk Payment file format
• #5461: User can enter claim monthly limit greater than yearly limit
• #5464: Employee fixed tax benefit not processed when process payroll
• Feature #5452: Add shortcut to Print HRDF from Month End Payroll Welcome screen
• #5471: Account Name too short in Mizuho Giro
• #5460: Unable Select Employee When Invalid Phone Number Format

SQL Payroll Latest Version (v163) Date : 08/01/2021

SQL Payroll 1.2021.190.163

Released on January 8, 2021

Release Notes

• Upgrade Database to Version 107.
• Add Tax Benefit tab on HR Employee
• Fix Sum of "Self Medical" and "Complete Medical" show zero amount when click "Print PCB" on paysheet
• Feature #5451:Show message when duplicate employee name occurs
• Feature #5450: Reduce employee EPF rate to 9% with effect from 1 Jan 2021 to 31 Dec 2021
• Add payroll calculator for year 2021

SQL Payroll Latest Version (v162) Date : 21/12/2020

SQL Payroll 1.2020.188.162

Released on December 21, 2020

Release Notes

• Enable CSV export for PR.EPF.KWSP17A.Khas2021 format
• Add Analyse Data Integrity - Trim Code Leading and Trailing Spaces
• #5454: Tabung Haji deduction from employee fixed deduction does not contribute to Tabung Haji after process payroll
• Feature #5456: Add "Educational Loan" tax exempt allowance
• Click left or right arrow scroll button on date navigator of leave application will append record
• Import and save pending transactions prompt error duplicates not allowed

SQL Payroll Latest Version (v161) Date : 26/11/2020

SQL Payroll 1.2020.187.161

Released on November 26, 2020

Release Notes

• Fixed PR.Zakat Report spelling error
• Fixed PR.Payslip1C format Unpaid Leave Day incorrectly shown when Batch print
• Fixed PR.Credit.BankInstruction report ROC not correctly shown
• Add Tabung Haji report
• Fixed Hong Leong bank Connect First excel file format - Validation ID value not in uppercase
• Fixed #5446: Mizuho bank IBG file format is invalid
• Feature #5445: Add Affin bank "AutoPay Excel 2" file format
• Feature #5448: Add Invotime under File | Import Data
• Feature #5449: Add AmBank Bulk Payment file format
• Show tax calculation on Edge web browser
• Allow user to select WhatsApp contact, WhatsApp group, application contact on WhatsApp window