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

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

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

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

SQL Payroll Latest Version (v211) Date : 26 September 2024

 

SQL Payroll 1.2024.264.211

Released on September 26, 2024

Release Notes

• Database upgrade to version 134
• #6094: Hong Leong Bank Connect First bank file format missing some routing code
• Sync Cloud add duplicate record checking and data transfer for TA_LOG_PAIR and TA_SUMMARY
• Add TA_LOG_PAIR & TA_SUMMARY unique indexes and set NOT NULL to TransDate of TA_LOG_PAIR
• Add HR Announcement
• Sync Announcement in Sync Cloud
• Add HR Announcement UI
• Add HR Announcement
• Add HR_ANNCMNT table
• Include Gratuity and Employement Loss of Compensation to paysheet when Sync Cloud
• #6093: Net pay is incorrect on employee payroll if adjustment is not equal to zero
• #6092: Employee listing grid column values become empty after using "Add to Payroll"
• #6072: Bank of China IGBT Payroll file format version 1.7

SQL Payroll Latest Version (v210) Date : 30 August 2024

 

SQL Payroll 1.2024.262.210

Released on August 30, 2024

Release Notes

• #6089: Payroll yearly reports missing access rights
• #6087: Update CP22 LHDN file format
• #6062: Add payment method option before process payroll