SQL Payroll Latest Version (v225) Date : 12 July 2025

 1.2025.281.225

July 12, 2025

Introduces support for Firebird 5.0 database engine (225)

Database

• Added support for Firebird 5.0
  • New databases will be created using Firebird 5.0 automatically
  • Once upgraded to Firebird 5.0, there is no rollback path to version 3.0

SQL Payroll Latest Version (v223) Date : 10 July 2025

1.2025.279.223

July 10, 2025

New Payment Method column for payroll processing's employee filter & important bug fixes. (223)

Updates

• Add Payment Method column to filter employee when processing payroll

---

Bug Fixes

• Fixed Pending payroll display incorrect number of transactions in 64bit application
• Fixed missing logs after Update Payroll
• Fixed unable to delete records if clear all future records in Traveller Location
• Fixed unable to show Session and Script field after recalculate
• Fixed Work OT Clock Time and Tier form delete button not working
• Fix unable INSERT Script field to TA_TRANS table

SQL Payroll Latest Version (v222) Date : 30 June 2025

1.2025.278.222

June 30, 2025

Enhancements to payroll and attendance reports, smarter cloud sync and mapping, new file formats, and several key bug fixes. (222)

Database

Database upgraded to version 142

---

Features

• Payroll Attachments: Added attachments column to cloud pop-up form for payroll yearly claim, and included attachment data in claim reports.
• Print Work Schedule Summary: Added option to include resigned and inactive employees.
• Income Tax CP39 Form: Added Include Zero PCB option.
• Bank File Format: Added support for JP Morgan Access file format.

---

Updates

• Map Optimization: Reduced Google Map and Geocoding API usage to minimize cost and improve performance
• Mission Entitlement:
  • Revised batch edit and entitlement UI
  • Now retrieves past 6 months of mission records
• Sync Cloud:
  • Show active employee TMS records during Sync Cloud

---

Bug Fixes

• Fixed Absent showing for past and next day after resolving missing log issue.
• Fixed issue preventing edited records from being updated.
• Fixed packetmeta method bug that caused duplicate employee codes.
• Fixed missing sheets in AmAccess Biz Bulk Transfer Excel export.

SQL Payroll Latest Version (v221) Date : 4 June 2025

SQL Payroll 1.2025.277.221

Released on June 4, 2025

Release Notes

• Database upgraded to version 141
• Add Bank of America Bulk CSV file format
• Add Al-Rajhi bank Payment Upload excel file format
• Add Al-Rajhi bank Payment Upload excel file format
• Delete traveller location records if Traveller is unchecked in Maintain Employee
• Show clock remark on Print Time Attendance Summary grid
• Allow to update work session if summary is not processed Allow to update past Rest Day and Public Holiday if no Work Day exist in that year for that employee
• Fixed PR.Tax.Lampiran B - Format 4 total to word wrap
• Fixed PR.Tax.CP22-2021 report page 2 data not shown due to overlapping
• Fixed incorrect session time during Sync Cloud
• Fixed Access violation when re-calculating yesterday's TMS log
• Fixed Access violation during ShowMap in Sync Cloud
• Fixed incorrect gender captured when importing employee using CSV file
• Fixed a bug which caused "Import Data" button is missing from Maintain Leave Type
• Fixed UOB Instant Transfer file format, Batch Header Originating A/C Name field cannot accept up to 140 chars
• Fixed a bug when submitting CP22A text file to IRBM return Jenis No. Rujukan Pasangan Wajib Disi error if employee marital status is divorce or widow
• RHB Reflex EPF and SOCSO file format ID Number column should padded with twelve zeros if employee does not have New IC number

SQL Payroll Latest Version (v220) Date : 26 April 2025

SQL Payroll 1.2025.274.220

Released on April 26, 2025

Release Notes

• Database upgrade to version 140
• Add "Process Bonus" access right
• Add PITypes column to PT_INFO table
• Fix server raise "Duplicate entry..." error when sync paysheet
• Fix server raise "Duplicate entry..." error when sync leave entitlement
• Allow user to set announcement period
• Add DateTo column to HR_ANNCMNT table
• #5967: Add OT tier up to 5 levels in Work OT
• Add new leave type when create new sample database
• Add OT4, OT5 to TA_OT_DTL
• Delete Public Holiday record if that year doesn't have any Work Day records
• Fix Possible having less than 365 / 366 calendar dates when copying work schedule
• Fix Unable to fix TMS log due to different calendar date
• Revise rollback if error occurs when posting to time attendance tables
• Fix Reminder to generate calendar date still prompt even before October
• Add PR.Tax.CP8D-2024-English format
• Fixed export to excel total shown white color for PR.Summary.Grouped-L1.Report 1
• #6166: Saving paysheet changes prompt error "is not a valid boolean value"
• #6163: Alert if nationality is MY and New IC is empty
• #6164: Maybank Universal Payment EIS file format footer record "Total Employer Contribution Amount" column value is incorrect
• Fix Employee age and service year are not refresh after reset payroll
• #6162: CIMB ePayroll Payment / Bulk Payment file format missing some bank codes
• #6157: Win64 - Change and save employee master record wage prompt error "Access Violation"

SQL Payroll Latest Version (v219) Date : 01 March 2025

SQL Payroll 1.2025.273.219

Released on March 1, 2025

Release Notes

• Print PCB year 2025
• Add checking for Join & Resign Date for EA & EC format
• Fix Saving a pending optional tax relief record with code "TD.7001" prompt error "Code (TD.7001) not found"

SQL Payroll Latest Version (v218) Date : 18 February 2025

SQL Payroll 1.2025.272.218

Released on February 18, 2025

Release Notes

• Database upgrade to version 139
• Update income tax EA and EC form
• #6120: Auto update City and State after input PostCode
• Auto update City and State after input PostCode
• Add Country to HR_EMP table
• Increase SMTP_URI field length to 500
• Revise MI_ENTITLEMENT table
• Update PR.Tax.CP8D-2024 Note
• Add paysheet OPF year 2025
• Revise commit dd952162: Close paysheet prompt error "Cannot focused a disabled or invisible window"
• #6148: Auto-fill benefit-in-kind description in income tax EA form
• #6147: Submit Maybank Universal Payment Zakat file to bank return error "Address 1 is mandatory" if payment indicator is equal to 01 in header record
• Revise commit 28a3855f: Reminder to generate Calendar Date prompted for non TMS user
• #6152: PCB amount is incorrect if employee paysheet deduction record type is changed to zakat
• #6149: AffinMax EPF excel format "Contribution Month and Year" column value is invalid
• Add i-bizRakyat Salary Payment, LHDN, SOCSO, EIS excel formats
• Add income tax CP8D report for year 2024
• Prompt confirmation message in Maintain Employee if wage is entered below 1700