Thursday, February 20, 2025

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

Tuesday, February 11, 2025

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

Sunday, January 26, 2025

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

Monday, December 30, 2024

SQL Payroll Latest Version (v215) Date : 19 Dec 2024

 

SQL Payroll 1.2024.269.215

Released on December 19, 2024
Release Notes
  • #6134: Revise DB metadata to include O_TA_LOG_PAIR and O_TA_SUMMARY
  • Revise Work OT sample data to include MinOT
  • Revise DB upgrade version 122 to insert Work OT using INSERT query to fix possible 'Invalid class typecast' error
  • Revise DB upgrade version 136. Run Boolean script convert in main thread to prevent random exception
  • #6133: Submit RHB CP39 text file to bank return error "Country code is mandatory if passport no. is entered" when there is an employee record with NewIC and Passport entered
  • Database upgrade to version 137
  • Revise TMS Status field to boolean
  • Add IsClaimLeave field to TA_Log_Pair and O_TA_Log_Pair
  • #6130: Sync cloud leave balance not tally with leave balance report
  • Rollback if error occurs when posting to time attendance tables
  • Revise Cloud.TimeAttendance.fm to exclude inactive and resign employee in total employee count
  • #6131: Submit Interbank Giro file to UOB return error

SQL Payroll Latest Version (v214) Date : 03 Dec 2024

 

SQL Payroll 1.2024.267.214

Released on December 3, 2024
Release Notes
  • Database upgrade to version 135
  • Bug #6113: Submit Maybank2E RC Universal Payment file to bank return error "Favorite Beneficiary/Biller Code is mandatory"
  • Add Giro column to HR_EMP table
  • #6101: Add Rate field to Maintain Wages
  • Add Rate column to HR_WA table
  • Fixed PR.Tax.CP22A-2023 format employee email not shown
  • Update PR.Coinage.Report by add 20 column
  • Fix Sync Cloud Time Attendance grid export to spreadsheet unable to show Clock Status
  • Add WorkStart and WorkEnd to Time Attendance Summary Report
  • Fix Sync Cloud Edit Log that may cause duplicate InKey or OutKey
  • #6024: Rename employee classification options
  • #6116: Payroll summary shows empty result if filtered by payment type of the payroll process
  • #6115: Display color and status for Grid Export in Excel file from Sync Cloud
  • #6114: Generate payment voucher including e-Invoice fields
  • #6105: Coinage report added currency note 20
  • #6104: Month end payroll overtime pay rate is incorrect calculated if pending allowance is processed first in Ad Hoc
  • #6111: Submit AmAccess Biz salary file to bank return error "Zakat Tab - Zakat Employer Reference Number is required"
  • Revise TimeAttendance.Map to exclude records which coordinates is 0 when show route
  • Fix Sync Cloud Time Attendance OT tab unable to edit if license is unregistered or expired
  • Fix Income tax report when printed or saved to file is not based on grid view filtered records
  • #6106: Bank of China file format incorrect beneficiary bank name

Friday, November 15, 2024

SQL Payroll Latest Version (v213) Date : 29 Oct 2024

 

SQL Payroll 1.2024.266.213

Released on October 29, 2024
Release Notes
  • Database upgrade to version 135
  • Bug #6113: Submit Maybank2E RC Universal Payment file to bank return error "Favorite Beneficiary/Biller Code is mandatory"
  • Add Giro column to HR_EMP table
  • #6101: Add Rate field to Maintain Wages
  • Add Rate column to HR_WA table
  • Fixed PR.Tax.CP22A-2023 format employee email not shown
  • Update PR.Coinage.Report by add 20 column
  • Fix Sync Cloud Time Attendance grid export to spreadsheet unable to show Clock Status
  • Add WorkStart and WorkEnd to Time Attendance Summary Report
  • Fix Sync Cloud Edit Log that may cause duplicate InKey or OutKey
  • #6024: Rename employee classification options
  • #6116: Payroll summary shows empty result if filtered by payment type of the payroll process
  • #6115: Display color and status for Grid Export in Excel file from Sync Cloud
  • #6114: Generate payment voucher including e-Invoice fields
  • #6105: Coinage report added currency note 20
  • #6104: Month end payroll overtime pay rate is incorrect calculated if pending allowance is processed first in Ad Hoc
  • #6111: Submit AmAccess Biz salary file to bank return error "Zakat Tab - Zakat Employer Reference Number is required"
  • Revise TimeAttendance.Map to exclude records which coordinates is 0 when show route
  • Fix Sync Cloud Time Attendance OT tab unable to edit if license is unregistered or expired
  • Fix Income tax report when printed or saved to file is not based on grid view filtered records
  • #6106: Bank of China file format incorrect beneficiary bank name

Monday, October 7, 2024

SQL Payroll Latest Version (v212) Date : 02 Oct 2024

 

SQL Payroll 1.2024.265.212

Released on October 2, 2024
Release Notes
  • #6102: SOCSO new wage ceiling increase to 6000 effective on 1 Oct 2024
  • #6099: UOB Interbank Giro and Inter Account Fund Transfer file format should contain all records in one file, regardless of IBG or internal fund transfer
  • #6103: Submit Maybank2E-RC Universal Payment file to bank portal return error if payment mode is Duitnow Transfer
  • #6097: Fix Maintain Announcement window unable to resize