SQL Payroll Releases

• #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

• #5588: Convert Boolean field to actual Boolean Type
• Database upgrade to version 136
• #6112: The Employment Act 1955 reduce maximum weekly working hours from 48 to 45 for Peninsular Malaysia and Labuan, with effect from 1 January 2023
• Rename other income form grid column caption
• #6127: Repeating the pasting of paysheet detail records, then deleting them, results in an incorrect gross pay
• #5812: Income tax EA form does not exclude employee record where none of the remuneration contribute to PCB, PCB (A) or EA for the year
• Fix Payment voucher missing companyname field
• #6122: Submit CP22A text file to IRBM return error “No Telefon Majikan Wajib Diisi”
• #6119: OTContribDS dataset does not contain pending payroll items for current process

• 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

• #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

• 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

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

• Add PR.Tax.CP21-2023.fr3 format
• Add leave entitlement processor “< 1 Year - Based on completed months of service proportion" script.
• Add Late In Buffer and Early Out Buffer column to Maintain Calendar
• #6074: Update CP22A and CP22B LHDN file format
• Fix Print Time Attendance Summary fr3 unable to show attachments
• #6071: Unable to upload CP22 due to wrong Gender info
• Fix bug: Ad hoc payroll calculated PCB additional differs from PCB additional calculated by IRBM calculator

• Database upgrade to version 133
• #6059: Add Attendance Reward for non TMS user
• Add AttendanceReward column to HR_EMP table
• #6058: Employee payroll support taxable other income
• Add pending taxable other income
• Optimize Time Attendance Summary report form performance
• Update day Type for TA.Attendance reports
• Add PT_OI table
• Add HRDF Info for Yearly Individual Report
• Fixed TA.Attendance1.Report report DayType not correctly shown
• Add PR.Tax.CP22B-2023 format, Remove PR.Tax.CP22B-2015 format & update PR.Tax.CP22B-2021 format
• #6068: Add Yearly EPF, Yearly SOCSO and Yearly EIS reports
• Add PostDate index to pending transaction tables
• Total tax benefit and total tax deduction are not updated if press Esc key
• #6064: Add Income Tax CP22 text file format
• #6048: Prompt confirmation message in Maintain Employee if wage is entered below 1500
• #6067: Foreign workers contribute to SOCSO First Category with effect from 1 July 2024
• #6065: Maybank2E-RC Universal Payment file format support Duitnow Transfer payment mode
• #6063: Add HRDF amount to Yearly Individual report
• #6061: AmAccess Biz Payroll SOCSO file format IC number column is not filled with SOCSO number for foreign worker
• Update RowVer for HR_BRANCH, PR_CL, LV_ENTITLE, LV_GROUP_DTL. LV_TYPE, TA_CALENDAR, TA_OT to fix cannot show special characters for Code and Description field
• #6060: Compensation and Gratuity month end calculation error if calculated pcb in adhoc
• #6057: After process month end, able to edit earlier process in the same month for an employee
• #6056: Hong leong bank connect first giro file format missing bank codes
• #6055: Add Affin Bank AffinMax Statutory Excel format
• Database upgrade to version 131 prompt “string truncation” error when execute procedure APPEND_PT_TRANS if source column contains unicode characters
• #6051: Print Time Attendance Summary Photo capture different from Sync Cloud
• #6050: MBSB Journey Corporate Payroll file format incorrect bank codes
• Disable inserting and deleting on Maintain Traveller Location grid
• #6049: Am-Access Biz Payroll file format missing columns I & J for non resident
• #6044: UOB IBG with payment advice file format missing payment currency for some employee
• Set MgrAutoApproval to false when create new employee
• Fixed PR.Summary.Grouped-L3.Report 2 export to excel Bonus amount not shown

• Database upgrade to 132
• #5625: Cloud pending claim window added “Trans Date” grid column
• #6042: CP8D employer section file is still created even the “Include Employer’s Particular” option is checked
• #6041: HSBC bank EIS file format has an incorrect filename
• Add MgrAutoApproval to HR_EMP
• Fixed PR.Zakat-Penang & Sarawak Format report some data not correctly shown
• Add Country parameter to TCreateDatabase constructor
• #6038: Exempted compensation and gratuity should not add in EA form column F and EC form column E
• #6037: MBSB Journey Corporate unable to capture Recipient Reference and Other Payment Details

• Database upgrade to 131
• Add HR.HistoryListing report
• Add Gratuity for PR.Payslip Report with V2 format
• Add Gratuity column PR.Summary.Grouped Report
• Add Transaction Code for PR.Yearly reports
• PR.SOCSO.Borang2.Report-Foreign Add passport validity and permit starting date
• #5642: Add support gratuity
• Add PT_GR table; add DOB column to PT_INFO
• Add Code column to PT_CP table
• Fixed Lampiran 2 report not showing total compensation
• #6008: Add PassportIssueDate, ImmigrationIssueDate, PermitIssueDate to Maintain Employee
• #6034: Add GX Bank to employee bank lookup
• #6033: e-AmPayDay net payroll socso file format IC number column is not filled with SOCSO number for foreign worker
• #6032: Add “Include Employer’s Particular” option to income tax CP8D and eData Praisi windows
• #6028: Income tax CP8D report exclude employee record with gross remuneration equal to zero
• #6027: Payroll yearly individual report rearrange employee eis position
• #6026: Empty child DOB error message is unclear
• Revise Sync Cloud DateTime format to follow system format
• Revise Time Attendance show map marker icons
• #5989: Add day name to Print Time Attendance Summary
• Revise Print Work Schedule Summary to exclude resigned and inactive employees
• #6000: Print Time Attendance Summary error when untick few status
• Revise Time Attendance Summary report to show logs without session
• Add DayType field to Time Attendance Leave Rule scripts
• Fix override note field and post employee userkey to PT_CL_LOG when update status in Sync Cloud Pending Claim

• 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”

• 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

• 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

• 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

• #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

• 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

• 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