SQL Payroll Latest Version (v202) Date : 10 Jan 2024

SQL Payroll 1.2024.250.202

Released on January 10, 2024

Release Notes

• Database upgrade to version 130
• Update PR.Claim.Report field mapping
• Add TP1 & TP3 for 2024
• #5980: Get public holidays from web
• Add payroll calculator year 2024
• Add income tax EA and EC reports for year 2024
• Optional Tax relief 2024 changes
• Add payroll calculator year 2024
• Add income tax CP8D year 2023
• Add Classification, RetirementDate, ContractExpiryDate to Maintain Employee
• Revise Time Attendance Work Schedule Processor TestCase
• #5981: RHB Smart Payroll format unable to generate record when beneficiary bank is not RHB
• #5978: Preview PR.Claim report prompt error "Field not found. Main."Amount""
• Revise TMS process to get the calendar data up to current date time
• Add RemarkIn and RemarkOut to time attendance summary report pipeline
• #5976: EA form raise item not found error for employee with payroll opening but without payroll process
• Fix Pending paid leave doesn't display leave day with full decimal when editing leave day column

SQL Payroll Latest Version (v201) Date : 29 Dec 2023

SQL Payroll 1.2023.249.201

Released on December 29, 2023

Release Notes

• #5975: Add email for UOB IBG file format with payment advice
• #5973: Tax exempted allowance calculated wrongly when more than 1 allowance with same tax code
• #5969: Add Alliance Bank BizSmart Zakat file format
• #5972: RHB Smart Payroll format does not support Rentas bank code
• #5941: MC leave type Process script default to "Based on calendar year, no proportion, round to 1 decimal"
• #5971: Claim transaction project different from pending claim transaction project after process payroll
• #5970: Add Pending Director Fee, Bonus, Paid Leave, Compensation, Advance Paid, Loan, CP38, Unpaid Leave data import from command line

SQL Payroll Latest Version (v200) Date : 13 Dec 2023

SQL Payroll 1.2023.248.200

Released on December 13, 2023

Release Notes

• Add PR.Zakat-Sarawak format
• Add Time Attendance Summary Report with Location Status & Photo
• Time Attendance Summary Report - Add Attachments & LocationStatus to pipeline
• #5955: Add Merchantrade Top Up file format
• #5953: Stores instruction file output directory in DB registry
• #5965: Leave entitlement recalculation clear last year entitlement
• #5964: Update UOB Instant Transfer file format v2.3
• #5960: Add China Construction Bank Malaysia IBG file format
• #5958: Unable to reconfigure leave group entitlement policy if the script is missing

SQL Payroll Latest Version (v199) Date : 27 Oct 2023

SQL Payroll 1.2023.247.199

Released on October 27, 2023

Release Notes

• Added Effective Date under Section ii (Action Taken) page 2 in HR.Employee.Confirmation Evaluation Form
• Add PR.Zakat-Perlis format
• Add Prorate Info for LV.Yearly.Report
• Database upgrade to version 129
• #5950: Clone Master Data required to clone over Maintain Work Session
• Sync Cloud Time Attendance filter resigned employees
• Work Schedule Summary - Add PH and Rest label for Public Holiday and Rest Day
• Time Attendance Summary - Default checked On Time and Append script name to Clock Status
• Add new time attendance day type - Rest Day (Special Rate 2) & Rest Day (Special Rate 3)
• Sync Cloud Leave and Claim unchecked Rejected by default
• #5946 & #5947: Time Attendance Summary - Add TotalWork, TotalOT, TotalBreakTime, TotalLateIn, TotalEarlyOut for the day
• #5795: Leave application report Main dataset added "Time in Minute" field
• #5921: Tax calculation sensitive to year and month
• Add Tax exemption calculator
• Add Tax relief calculator
• #5954: Income tax CP21 report B-3 column does not include commission amount
• #5952: Unable to generate loan schedule based on loan balance amount
• #5949: Add Age field to Main Dataset of Employee report
• Optimize performance for Sync Cloud TMS
• #5945: Add payment advice if have email for AffinMax Corporate IBG excel file format
• #5936: Remove leave day limitation when claim leave on the same day in Leave Application

SQL Payroll Latest Version (v198) Date : 16 August 2023

SQL Payroll 1.2023.246.198

Released on August 16, 2023

Release Notes

• Database upgrade to version 128
• Add PR.SOCSO.Borang2.Report-Foreign format
• Change Pipeline from Country to Nationality for PR.Tax.CP22-2021
• Add Grand Total for PT.Claim.Report
• Show Payment Type Description for Parameter PayType instead of number when selected 1 PayType for Payroll summary report
• Add PR.Zakat-Sabah format
• Update mapping City for PR.Tax.CP22-2021
• #5916: Increase Passport, ImmigrationNo and PermitNo field length to 40 characters
• #5904: Add "Send ELeave Email Notification" in Company Profile | E HRMS
• Add EmailNotif_ELeave column to SY_PROFILE table
• Fix unable to fill in missing clock in and revise time attendance date range filter
• Redesign Work Schedule Summary and Rename to Print Work Schedule Summary
• Display the day of the week in Maintain Calendar, Maintain Public Holiday and Maintain Traveller Location
• Add label to show ETMS last update date
• Add PIType and PICode support for TMS Leave Script
• Rename Print Time Attendance Transaction Listing to Print Time Attendance Unassigned Listing
• Disable inserting and deleting on sync Time Attendance grid
• #5897 & #5925: Public Holiday setting removed after user edit employee details
• #5912: Maintain Public Holiday Calendar - W change to C
• Change action to "Cancelled" if deductible is 0
• Add IsOT column to Leave tab in Sync Cloud and support IsOT in Leave Rules script
• Add IsOT column to TA_TRANS table
• Add schedule option in Maintain Calendar wizard for Rest Day
• #5933: Hong Leong bank Connect First IRB file format Country Code column is empty and Staff No column contains non-alphanumeric characters
• #5932: Leave Attendance report detail record decimal place not same as grand total
• #5929: Add Nationality dataset to Payroll and Employee reports
• #5906: Add time mask popupedit for time in minute entry
• #5923: Maintain employee service year show in years and months
• #5924: UOB EPF file format version 2.3
• #5919: Some CP22A, CP22B and CP21 fields does not exclude tax exempted amount
• #5819: Add Bank of China IGTB Payroll file format
• Fix sync cloud WorkingHourPerDay value type from integer to TBcd for leaveday calculation
• #5920: Add Attendance Reward column to employee browse window
• #5915: Leave entitlement that is manually entered become 0 when recalculate
• #5918: Allowance Reward script aTransDS dataset added TransDate, WorkUnit, TimeInMinute and Rate field
• #5917: Delete tax benefit in maintain employee prompt out of bounds error

SQL Payroll Latest Version (v197) Date : 06 July 2023

SQL Payroll 1.2023.243.197

Released on July 06, 2023

Release Notes

• Database upgrade to version 127
• Update mapping PostCode & State for PR.Tax.CP22-2021
• Fixed TA.Attendance1 & TA.Attendance2 not Scale to A4 side
• Lookup new entry form support access right approval
• Revise sync manager data to include only active employees
• #5903: Unable to capture Permit Expiry Date in report Employee Listing
• #5901: Employee tax category in payroll summary report differs from employee master tax category
• #5898: Revise existing LZS Zakat format to CSV format
• #5885: Add Access Right for Time Attendance in Sync Cloud
• Fix error prompt "Dataset not in edit or insert mode" when copy & paste time attendance location
• Revise Show Map marker in Sync Cloud
• #5893: Payroll accounting employee EPF, employee SOCSO, employer SOCSO, employee EIS, employer EIS and PCB support GL code by contribution
• #5886: Add income tax CP22A file format
• #5894: Access right "Print Payroll Summary - All" is not working
• #5892: Incorrect description when preview Work Unit Summary report
• Revise implementation of export PTPTN, CP8D, eData Praisi and Lampiran2
• #5888: By default, Rest Day is checked in Leave Application
• #5887: Alliance bank BizSmart Bulk Payment file format version 1.7
• #5889: Incorrect Commission Summary report data form caption
• #5880: Standard Chartered bank Bulk Payment format update
• #5876: Generate new script for Leave Entitlement Policy, Leave Calculate BF and Leave Calculate Amount when pasting Leave Group from clipboard
• #5884: The default HRDF rate for new company is 1%
• #5883: Add "Age 60 and above" to EIS category on Maintain Employee window
• #5870: Pending Overtime doesn't recalculate WorkUnit when Code is changed

SQL Payroll Latest Version (v196) Date : 09 June 2023

SQL Payroll 1.2023.242.196

Released on June 09, 2023

Release Notes

• Database upgrade to version 126
• Add monthly tax deduction computerized calculation year 2023 test cases
• Fix bug: Incorrect monthly tax deduction amount calculated using the Knowledge Worker computerized calculator
• Add HomeScreen
• #5874: Add Postcode, city and state fields in Maintain Employee | Personal
• Update TP1 & TP3 2023 new format
• Fixed PR.SOCSO.Borang8A.Report Export to pdf Logo Black
• Set late in buffer and early out buffer to 0 when create new session
• Add Work Session and Work OT report
• Add OT Remark to Print Time Attendance Summary
• Fixed Time Attendance Summary report not in order
• Add new time attendance day type - Rest Day (Special Rate)
• Add Time Off Leave Type
• Add Script Name col in Sync Cloud OT and Leave tab
• Add Script column to TA_Trans table
• Add Batch Edit to Sync Cloud
• Add Time Attendance Transaction Listing Report
• Add Flexi Working Hour script
• Allow to choose custom script in Maintain Work OT
• 5875: Preview pending claim in pending payroll listing prompt conversion error
• #5872: Automation process for current year leave entitlement is not applied to newly created employee
• #5871: Delete employee prompt "Delete is not allowed" but no TMS trans posted to payroll