SQL Payroll Latest Version (v205) Date : 15 March 2024

SQL Payroll 1.2024.256.205

Released on March 15, 2024

Release Notes

• Fixed Export to PDF Leave Long Description Overlapping
• Fixed PR.Tax.CP22A-2023 A5 & A11 wrongly map
• #5999: Incorrect leave BF after process current year leave entitlement if last year leave application post date fall in current year
• #6023: CP8D employee section text file is required even though content is empty
• #6021: Leave.Entitlement.Processor.RoundToDay script return value with decimal place for employee has not completed one year of service
• #5911: Application does not prompt message when leave application fall outside acceptable transaction date
• #6001: Non resident PCB amount not tally with LHDN calculator
• #6014: Generate income tax CP8D year 2022 text file prompt error "Access violation"

SQL Payroll Latest Version (v204) Date : 22 Feb 2024

SQL Payroll 1.2024.254.204

Released on February 22, 2024

Release Notes

• Add PR.Tax.CP22A-2023 format
• Fixed EA 2023 & 2024 Typo Error
• Fixed PR.Tax.CP8D-2023 only shown 1 page even data more then 9
• Add PR.Tax.CP8D-2023-BorangE - Part A format
• #6004: Add income tax CP22A year 2023
• #6003: "Staff IC No" column in Public bank SOCSO excel format is not filled with foreign worker SOCSO number
• #6006: Infinite loop in leave entitlement processor script
• #6005: CP21 show record with commission for not resigned employee
• Fixed PR.SOCSO.Borang2.Report-Foreign Moble number shown unknow info when not enter
• #6011: Add MBSB Bank Journey Corporate Payroll file format
• #6010: User can still view employee wages even though user doesn't have access right
• Fixed PR.Tax.BorangEA-English version label not fully shown
• Bug #6013: Income Tax CP8D 2023 Borang E Part A incorrect A2 value

SQL Payroll Latest Version (v203) Date : 31 Jan 2024

SQL Payroll 1.2024.252.203

Released on January 31, 2024

Release Notes

• Add PR.Tax.CP8D-2023 format
• Update EA & EC for 2023 & 2024 to Pin 2023
• #5996: Revise income tax CP8D year 2023
• #5997: Rename "Maintain Public Holiday" to "Maintain Public Holiday Calendar"
• #5956: Application does not prompt warning message when ADMIN user process month end payroll fall outside acceptable transaction date
• #5968: Employee has not completed one year of service shall calculate AL entitlement based on number completed months service proportion
• #5994: Income tax EA report shows an incorrect amount for tax exemption allowance
• Change 2024 paysheet lhdn calculator to english
• #5991: Update CP22A LHDN file format

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