Friday, September 26, 2025

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

 1.2025.286.230

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

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

 

Wednesday, September 17, 2025

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

 1.2025.284.228

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

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

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

Wednesday, August 13, 2025

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

 1.2025.281.225

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

Sunday, July 20, 2025

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

1.2025.279.223

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