SQL Payroll Releases
SQL Payroll 1.2022.217.181
Released on 31 May 2022
Release Notes
- Database upgrade to version 116
- Fix inconsistence font type and size in grid for employee browse form
- Employee EPF, SOCSO, EIS and TAX will only calculate upon save
- Remove unused payroll yearly calculator windows
- #5648: SQL View setting does not apply to pending claims
- Set Default Header to Code if Description is Empty for Payroll Summary Work Unit Reports
- Set Default Header to Code if Description is Empty for Payroll Summary Reports
- Fixed CP22 & CP22A 2021 data should be in uppercase
- Fixed PR.Tax.CP22A-2021 missing subtitle
- Add Total Levi to be Paid column for PR.HRDF reports
- Fixed PR.Summary.Grouped Report 1 – Process Parameter not fully shown
- #5589: RHB Bulk Payment format “ePayment File Identifier” field value must be 01
- Add “Include Zero HRDF” option to HRDF report
- Fix Process HRDF prompt error “Duplicates not allowed”
- #5654: Remove feature #5315 auto fill Gender, DOB and SOCSO number after enter New IC number
- #5658: “Division by zero” error prompt when click Leave Dashboard after create New Database
- #5652: Error when filter by Employee for HRDF report
- Adjust overlapped controls position
SQL Payroll 1.2022.215.180
Released on 23 Apr 2022
Release Notes
- Database upgrade to version 115 – Add LV_ENTITLE_CALC table
- Feature #5641: Recalculate employee leave entitlement for current working year when user sets employee resign date
- Feature #5276, #5600: Redesign HRDF report
- Reduce Column Usage on FR3 Export to excel for Payslip 2A format
- Reduce Column Usage on FR3 Export to excel for Payslip 1C format
- Reduce Column Usage on FR3 Export to excel for Payslip 1B format
- Reduce Column Usage on FR3 Export to excel for Payslip 1A format
- Update PR.SOCSO.Borang8A(201407).Report with Status
- Reduce Column Usage on FR3 Export to excel for Payroll Summary Reports
- Reduce Column Usage on FR3 Export to excel for HR Module reports
- #5644: Add access right for Show Amount in Payroll Summary (Work Unit)
- Revise the number of children displayed for Lampiran B report
- Fixed #5645: RHB Smart Payroll format “Al Rajhi Bank” BIC code is missing
- Feature #5643: Add PB enterprise EIS excel format
- Fix Upload AmAccess Biz excel file to bank unable to read first row of record
- #5639: Upload PB enterprise IRB excel to bank return error “Country code is mandatory if passport no is filled; otherwise must be blank – MY”
- Feature #5636: Add Project, Job and Task group by option for Payment Summary
SQL Payroll 1.2022.214.179
Released on 26 Mar 2022
Release Notes
- Rename PR.Tax.CP22 to PR.Tax.CP22-2011
- Enable Support UseNameICPass pdf password for Batch email for EC 2020, 2021 & 2022
- Enable Support UseNameICPass pdf password for Batch email for EA 2020, 2021 & 2022
- Enable Support Name2 & UseNameICPass pdf password for Batch email for Payslip
- Database upgrade to version 114
- Customize EA form Employee List do not follow SQL View setting
- #5613: Customize EA form Employee List do not follow SQL View setting
- #5628: Yearly individual main dataset records not match as filters
- #5634: User still can apply tax beneft/optional tax relief summary report even though doesn’t have access right
- #5615: Add RHB Reflex SOCSO text format (new)
- #5633: HRDF calculation doesn’t exclude foreign worker remuneration
- #5631: Hide number of grid columns on HRDF data form window
- Feature #5632: New deduction master record uncheck HRDF contribution by default
- #5630: Income tax EC form C1 column include CP38 amount
- Adjust move up and down button position of group and sort by
- Fix sync cloud to load leave app log in filtered record
- #5626: Incorrect tax exemption amount calculated when employee pending allowance is not added in order
- Add Attachments column to batch leave application form
SQL Payroll 1.2022.213.178
Released on 01 Mar 2022
Release Notes
- Add PR.Contribution.Info-Detail format
- Fixed PR.Tax.PCB2(II)-2012 Field Mapping error
- Add filtering option to sync LeaveApp
- Add sync cloud LeaveApp, Pending Claim and Payroll access right
- Add PR.Tax.Lampiran2 format
- #5604: Revise income tax lampiran 2 report
- #5609: Upload PB Enterprise ECP Payroll excel file to bank return error “Invalid Total Amount” due to missing thousand separator
- #5623: Maintain Opening Balance should not allow save if Retired Civil Servant Life Insurance and Life Insurance is not 0
- Feature #5581: Add Agro Bank Bulk Payment format
- Fix gateway-timeout error when sync paysheet with payslip
- Revise Bank Giro to exclude record with Amount less than 0 when export
- #5617: Revise to exclude Amount less than 0 when Print Payment Summary for credit bank report
- #5620: Upload RHB Bulk Pay file to bank return error “Total hash value is not correct”
- #5619: Revert income tax exemption for Loss of employment for YA2022 back to RM10,000 per full year
- Adjust sync payroll ui
- #5610: Pending Director Fee pay year does not change on 2nd record when post date year change
- #5611: Preview error on CP22A
SQL Payroll 1.2022.211.177
Released on 07 Feb 2022
Release Notes
- Allow user to edit pending claim after sync from server
- Change sync pending claim line chart to bar chart
- #5606: Maybank Bulk Payment start with empty row
- #5605: Incorrect header format info in EPF Borang A PB Enterprise Excel Format
- 5603: Annual Leave’s B/F Show Result is ‘0’ When Last Year Balance Is Negative
- #5598: Incorrect turnover result where there is a resigned staff in a month
- Add income tax 2021 EA to sync
- Feature #5597: Revise missing Employer Tax No. in PB enterprise Excel
- #5599: eData Praisi 2021 upload error due to Donation amount is empty
- Fix Prompt Install WebView2 due to windows update
SQL Payroll 1.2022.210.176
Released on 18 Jan 2022
Release Notes
- Feature #5594: Add income tax eData Praisi for year 2021
- Update income tax EA, EC year 2021 and 2022
- Feature #5587: Add new field for income tax EA 2021 and EC 2021 report
- #5593: Process payroll prompt error “Interface not supported” when STD calculator is Return Expert Program
- Feature #5591: Add Excel format for Tabung Haji
- Fix Payroll dashboard get wrong result for last year YTD, leave dashboard headcount include inactive employee
- #5588: Apply income tax report prompt error “Dynamic SQL error column unknown C.DeductionType”
SQL Payroll 1.2022.208.175
Released on 06 Jan 2022
Release Notes
- Add dashboard access right
- Database upgrade to version 113
- Add dashboard
- Add payroll calculator year 2022
- Add TP1 & TP3 2022 report in Maintain Employee
- Add auto append optional tax relief for EIS
- Add Attr column to PT_TD table
- Feature #5570: Add PTPTN deduction
- Revise zakat and tabung haji options on employee deduction, master deduction and pending deduction
- Add DeductionType, DeductionAttr column to HR_EMP_DE, PR_DE and PT_DE table
- Sync payroll payslip to server
- Sync leave application attachment to and from server
- Add Attachments column to LV_APP table
- Enable Support Name2 option for PDF Password for batch email for EA 2020 & 2021
- #5586: Upload RHB Reflex SOCSO excel file to bank return error “Employee SOCSO Number must not be greater than 9 digits”
- #5585: Maybank2E-RC Universal Payment SOCSO file format “New ID No” column is not filled with SOCSO number when the employee is foreign worker
- Add PR.EPF.KWSP17A.Khas2022 & remove PR.EPF.KWSP17A.Khas2021 format
- Fixed PR.Zakat-Kelantan Mobile Number not properly shown
- #5583: No Value for UOM field in Wages Pipeline for Payslip
- #5582: Prompt access violation when click “calculate amount” on PCB receipt
- Feature #5315: Auto fill Gender, DOB and SOCSO number after enter New IC number
- #5580: Adhoc allowance error when just check Allowance
- Add Entitle variable to calculate BF leave script
- Add Process Pipeline for Batch email for Payslip
- Fixed GetTitle shown empty for Batch Email in EA for 2019 to 2021
SQL Payroll 1.2021.206.174
Released on 23 Oct 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 1.2021.205.173
Released on 25 Sep 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 1.2021.204.172
Released on 13 Aug 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 1.2021.203.171
Released on 02 Aug 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 1.2021.201.170
Released on 18 Jun 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 1.2021.200.169
Released on 06 Apr 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 1.2021.199.168
Released on 06 Apr 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 1.2021.197.167
Released on 05 Mar 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 1.2021.197.166
Released on 26 Feb 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 1.2021.193.165
Released on 30 Jan 2021
Release Notes
- Upgrade Database to Version 109
- #5475: Allowance tax code does not refresh based on master setting
- PR.Payslip1A.Report-V2 Unpaid Leave shown 0 when batch print