SQL Payroll: December 2024

Monday, December 30, 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

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