SQL Payroll Releases

Read all current and past software build releases

SQL Payroll 1.2023.241.195

Released on May 22, 2023

Release Notes
  • Fixed PR.Tax.CP22-2021 Logo black when export to pdf
  • #5852: Preview payroll summary report doesn’t follow grid column visibility
  • Bank Muamalat Payroll file format missing some bank codes
  • Database upgrade to version 125
  • Fixed black box when export to pdf for PR.Tax.CP22A-2021
  • Revise Show Map form in Sync Cloud
  • Add EarlyOutBuffer column to TA_SESSION and TA_CALENDAR table
  • Revise Show Log form in Sync Cloud
  • Fixed cannot run OT script for public holiday and rest day
  • Remove icon from menu for Work Schedule Summary
  • Add Post Date column to OT tab and Leave Tab in Sync Cloud
  • Add PostDate column to TA_TRANS table
  • Revise old Maintain Calendar to Maintain Public Holiday
  • Fix Work Unit Summary report return incomplete resultset

SQL Payroll 1.2023.239.194

Released on May 8, 2023

Release Notes
  • Database upgrade to version 124
  • #5843: Time in minute for wages should refer to employee maintain contribution working hour per day
  • Fixed PR.Tax.Lampiran B not Min Remuneration not follow user set
  • Fixed HR.Employee.Appointment Signature & date missing
  • Revise Pending Payroll Listing report
  • Add History Listing report
  • Add Permit No and Expiry Date for Permit, Immigration and Passport
  • #5866: Update Maybank2E-RC Universal Payment IRB file format based on version 7.2
  • #1249 & #1624: Add Permit No and Expiry Date for Permit, Immigration and Passport
  • Add PassportExpiryDate, ImmigrationExpiryDate, PermitNo, PermitExpiryDate columns to HR_EMP table
  • Add Time Attendance Multi-Location & Map View
  • Add Clear All Schedule and Location option when select multi employees
  • Allow delete records for TA_Calendar, TA_Summary, TA_Location in EMS if clear all records in local db
  • Feature #5832: Show map on GPS Range column in Sync Cloud
  • Feature #5833: Add Maintain Traveller Location entry form
  • Allow to show log from OT and Leave tab in Sync Cloud
  • #5865: Disable site photo if found drive is “Off”
  • Fix error prompt “RowIndex out of range” in Maintain Calendar
  • #5850: Fix unable to delete employee if employee have existing Time Attendance records
  • By default no rest days are selected for calendar wizard
  • Work Summary Summary remove grey background on today’s date
  • #5860: Fixed prompt ‘At end of table’ in Maintain Calendar
  • TimeInMinute field is missing from PT.Overtime datamap
  • Fix Work Unit Summary report access right does not work
  • #5858: Append an overtime record to employee payroll prompt assertion error if a borne allowance record contributes to overtime.
  • #5857: Payroll Summary report filter by Payment Type prompt “Conversion error from string” error
  • #5856: Payroll summary no data display when filter with category
  • Fixed slow calendar drop down when editing TMS clock in and clock out time

SQL Payroll 1.2023.238.193

Released on April 18, 2023

Release Notes
  • #5848: Payroll summary dataset sort order doesn’t match with sort order in grid table view when preview report
  • #5847: Payroll Summary report prompt “PISeq (AD) not found” error
  • #5424: Employer SOCSO number can only have up to 12 characters
  • Database upgrade to version 123
  • Add PR.Yearly.IndividualPay.Report-NoAD format
  • Replace pdf to jpg for PR.Tax.CP21-2021
  • Fixed PR.Tax.CP22B-2021 Tax number not correctly shown
  • #5781: Work Unit Summary support grouping
  • Adjust statutory body window caption
  • #5844: Paste record from excel into payroll detail dataset prompt “D_Wages: Dataset not in edit or insert mode” error
  • #5842: Time attendance log missing clock by default follow actual date
  • #5837: Allow user to set work session on current day
  • #5840: e-AmBiz Bulk Payment file format missing some bank codes
  • Feature #5841: Add UOB EIS file format
  • #5839: Pending unpaid leave record “Time in Minute” field is null if the record created via leave application
  • #5830: Reposition the Process button on Process Payroll window
  • Fixed missing OT records in Sync Cloud
  • Fixed Sync Time Attendance could not parse SQL TimeStamp string error
  • Add total late in, total early out, clock status and location status variable to Leave Rule script
  • Remove Maintain Calendar from Leave Menu
  • Maintain Branch set default radius to 60 meters
  • Map window allow to maximize in Maintain Branch
  • Rename ELeave tab to E HRSM in Company Profile and Maintain Employee
  • #5831: Allow to edit previous dates without session to rest day and public holiday
  • Remove Batch Edit and multiselect, Disable employee column sorting and branch column editing, Add cancel button, Set default work session text to ‘To Assign’
  • Revise GPS Location label to GPS Monitoring (Work Hour) in Maintain Work Session and Maintain Calendar and revise variable name
  • Fix folder share being deleted on disable SQL Drive
  • #5835: Change HRDF contribution in paysheet does not recalculate HRDF
  • Fix Main menu invalid command ID for Import Data
  • #5811: Leave application table view show “Time in Minute” column
  • #5828: CP8D text format should merge records when the “New IC” or “Old IC” or “Passport No” are the same
  • #5823: Data entry form supports OnBeforeSave DIY event
  • #5822: Maintain Employee window shows Age and Service Year
  • #5827: Add Traveller, Manager Approval, Manager Review and Leave Malaysia column to Maintain Employee
  • Fixed Sync Cloud unable to load claim trans
  • #5824: Leave application attachments drop down prompt error “No mapping for the Unicode character”
  • #5821: OCBC bank Easi-Giro file format missing number of bank codes
  • #5836: Add “Require ID Check” option to OCBC bank Easi-Giro file format

SQL Payroll 1.2023.236.192

Released on March 18, 2023

Release Notes
  • Change EA & EC 2022 & 2023 to norm customise design format
  • #5816: Maintain Loan browse window unable to filter by Employee Name
  • #5817: CP8D 2022 column U contains decimals
  • #5818: Some reports still shown to user that does not have access right
  • Database upgrade to version 122
  • #5813: Add Religion field to income tax Lampiran 2 report Main dataset
  • Add Religion column to HR_EMP table
  • Add Online Approval for access right
  • Add remote approval message to access rights
  • SY_User add Mobile, Email & OpenID_Google fields. SY_Profile add Country field
  • Add Time Attendance module
  • Add support Attendance Reward
  • Add AttendanceReward column to HR_EMP table
  • Add validation when process payroll of there are error records
  • Add Time Attendance Summary Report
  • Add Time Attendance to Sync Cloud
  • Add Work Schedule Wizard, Work Schedule Summary and Redesign Calendar
  • Maintain Employee entry form add Work OT and IsTraveller field
  • Add GeoCoordinate input in Maintain Branch and GoogleMapsAPIKey input in Company Profile & sync GeoLat, GeoLong, Radius data
  • Add GeoLat, GeoLong & Radius column to HR_BRANCH and GoogleMapsAPIKey column to SY_PROFILE
  • Add TA Session, TA Calendar, TA Trans, TA Summary and TA OT
  • Add TA_CALENDAR, TA_SESSION, TA_LOG_PAIR, TA_SUMMARY, TA_TRANS, TA_OT_DTL, TA_OT table
  • Conversion of TimeInMinute to WorkUnit/LeaveDay and vice versa
  • Add TimeInMinute column to PT_WA, PT_AL, PT_OT, PT_CO, PT_DE, PT_PL, PT_UL, LV_APP table
  • #5815: CP8D filename contains leading zeros for employer tax number
  • Feature #5814: Add pending allowance and leave application for Invotime import data
  • #5810: Month end process tax amount is incorrect when ad hoc process compensation doesn’t calculate tax

SQL Payroll 1.2023.234.191

Released on February 28, 2023

Release Notes
  • Fixed PR.Tax.CP8D-2022 Total not correctly shown when more then 3 pages
  • Remove Word Wrap option for Company Information for EA & EC 2022 & 2023
  • 5743 : Fixed PR.Tax.CP22-2021 extra line on export to pdf
  • Fixed HR.Employee.Report-PCB.TP1-2023 page 3 not correct format
  • Remove Checking EPF code for PR.EPF.BorangA.2009.Report
  • Database upgrade to version 121
  • Feature #5801: Increase BankAccNo field length to 30 characters
  • #5793: Rename “Compensation” to “Employment Loss Compensation”
  • #5806: Zakat deducted from gross income when tick contribute to EA
  • #5807: E-Data praisi filename contains leading zeros for employer tax number
  • #5804: Sync EAForm detail and report not updated for year 2022
  • #5803: LampiranB employee socso amount include employee eis amount
  • #5799: Calculate EPF, SOCSO, EIS and Tax when paysheet field is changed
  • #5800: Incorrect employee EPF amount if select EPF option “Without balancing”
  • #5798: Pending unpaid leave “Leave Day As Time” doesn’t follow maintain contribution “Working Hour Per Day” after reopen
  • Feature #5778: Add workunit in yearly individual report
  • #5792: Process missing employee that exists in payroll process newer than current payroll process is allowed