SQL Payroll Latest Version (v230) Date : 25 Sept 2025

 1.2025.286.230

September 25, 2025

Database upgraded to version 144 (230)

Database

Database upgraded to version 144

SQL Payroll Latest Version (v229) Date : 19 Sept 2025

1.2025.285.229

September 19, 2025

Database upgraded with EPF rate updates for non-Malaysian employees, enhanced payroll processing controls, and fixes for time attendance calculations and bank file formats. (229)

Database

Database upgraded to version 143

---

Updates

• EPF contribution rate for non-Malaysian employees updated to 2%, effective 1 October 2025
• Improved payroll processing by updating claim transaction status from PendingCommit to Approve before aborting payroll process
• Enhanced PB Enterprise ECP file format with updated BIC codes
• Added Employee Bank column filter for more efficient payroll processing
• Updated AmAccess Biz Bulk Transfer Excel file with latest Bank Code sheet version

---

Bug Fixes

• Fixed Time Attendance Summary report total OT value deduct break time twice
• Maintain Loan browse form is not functional with SQL View
• Fix SY_VIEW record not deleted when drop auto-created view fails
• Bank of America BulkCSV format leaves "Ordering Party ISO Country Code" and "Receiving Party ISO Country Code" columns empty
• Restore "Optional Tax Relief" BO index and state after reaching the last record

 

SQL Payroll Latest Version (v228) Date : 27 Aug 2025

 1.2025.284.228

August 27, 2025

Allow to edit TMS log after process month end (228)

Updates

• Allow to edit TMS log after process month end

SQL Payroll Latest Version (v227) Date : 23 Aug 2025

 1.2025.283.227

August 23, 2025

Adds SOCSO Borang2 and UOB Universal file formats, with fixes for payroll transaction signatures, PCB calculator errors, and e-AmPayDay EPF submissions. (227)

Updates

• Add SOCSO Borang2 file format
• Add UOB Universal File Format

Bug Fixes

• Generating payroll transaction signatures does not include compensation and gratuity related transactions
• Print PCB prompt "Access violation" error when using PCB calculator "Schedule Table & Formula" for x64 version
• Unable to display "&" in PCB calculator caption on paysheet form
• Submit e-AmPayDay Net Payroll EPF payment to bank prompt error "Employee NRIC Number is mandatory" when there is a foreign worker record in details

SQL Payroll Latest Version (v226) Date : 01 Aug 2025

 1.2025.282.226

August 1, 2025

Adds Bank Islam eBanker Pro file format, improves paysheet and sync prompts, and fixes for OT rules, payroll calculations, and reporting. (226)

Updates

• Add Bank Islam eBanker Pro file format
• Rename paysheet's OtherPay field to OtherEarning
• Prompt confirmation if sync payslip month and year is before last synced

Bug Fixes

• Reset branch option in Maintain Traveller Location Map
• Fix OT Rule form to show edit value on reopen and save edit value on insert
• Fix possible incorrect calculation of paysheet's gross pay, gross deduct and net pay
• RHB Bulk Pay file format "ePayment File Identifier" column is not set to "02"
• The CP22 text file "Spouse Identification Card Type" column is filled even "Spouse Name" column is empty
• The "PR.Summary.Grouped-L1.Report 2.fr3" report's "Others" column does not include gratuity amount

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

SQL Payroll Latest Version (v217) Date : 05 February 2025

SQL Payroll 1.2025.271.217

Released on February 5, 2025

Release Notes

• Database upgrade to version 138
• #6142: Fix UBS Payroll import to raise exception if detect invalid or out of range date value
• #6144: Add TransDate to PR.Cloud.Claim datamap
• Fix Reminder to generate Calendar Date prompted for non TMS user
• Fix Some data processors access rights are not functional
• Fix "Pending Payroll Listing - Gratuity" access right is missing

SQL Payroll Latest Version (v216) Date : 17 January 2025

 

SQL Payroll 1.2024.270.216

Released on January 17, 2025

Release Notes

• Add payroll calculator 2025
• Add income tax EA and EC reports for year 2025
• Add TP1 and TP3 reports for year 2025
• #6140: Add "Edit Statutory Contribution Amount" access right
• Fix Recalculate leave entitlement prompt error "Invalid argument to date encode"
• #6138: Maybank Universal Payment Zakat format missing Payment Indicator option
• #6121: Add Access Right for Time Attendance
• Fix Duplicate Key error when Sync Time Attendance for same Employee with same AdjTransDate
• Add Reminder to generate Work Session for next year in Sync Cloud
• Add leave entitlement processor reminder on after login
• #6136: The rate of pending wage record is not filled with the employee wage rate if the code of pending wage record is changed
• Fix Paysheet contribution amount is incorrect if the Esc key is pressed after editing
• #6135: Add Leave Passage tax exemption