SQL Payroll Releases

• #5501: RHB Bank incorrect Batch Number
• #5499: Public Bank ECP Text (BIF) incorrect Bank Rakyat bank code
• #5485: Update Maybank file format names

• Upgrade Database to Version 110
• Add TaxCode column for Yearly Allowance, Code column for Yearly Tax Benefit and Yearly Tax Deduction
• Fixed CP8D for 2016 – 2020 grand total not correctly sum in some scenario
• Add Lampiran B format 4
• Feature #5497: Income tax lampiran B report add SOCSO and EIS field
• Fixed TP1 from 2017 to 2021 wrong Field mapping
• Feature #1484: Paid leave support auto calculate rate
• Feature #5359: Add Note member to claim tran
• #5492: Resize note and photo components on Employee.EF
• Feature #5490: Update Maybank2E-RC Universal Payment file format based on version 6.0, Maybank hash formula
• Add OTContribDS variable to calculate overtime payrate script

• Upgrade Database to Version 109
• #5475: Allowance tax code does not refresh based on master setting
• PR.Payslip1A.Report-V2 Unpaid Leave shown 0 when batch print

• Upgrade Database to Version 108
• Add CP22, CP22A & CP22B 2021 format
• Fixed PR.Summary.Grouped-.Report 2 Display Format not consistent
• Add CP8D 2020 Format
• #5470: Copy to excel prompt error index out of bounds when select all employees on browse form
• Feature #5415: Add Maybank Bulk Payment file format
• #5471: Account Name too short in Mizuho Giro

• Upgrade Database to Version 107
• Add Feature E-Claim
• #5454: Tabung Haji deduction from employee fixed deduction does not contribute to Tabung Haji after process payroll
• Feature #5450: Reduce employee EPF rate to 9% with effect from 1 Jan 2021 to 31 Dec 2021
• Add payroll calculator for year 2021
• Fix LV.Balance.Report-Employee Performance preview date format error

• Enable CSV export for PR.EPF.KWSP17A.Khas2021 format
• Add Analyse Data Integrity – Trim Code Leading and Trailing Spaces
• #5454: Tabung Haji deduction from employee fixed deduction does not contribute to Tabung Haji after process payroll
• Feature #5456: Add “Educational Loan” tax exempt allowance
• Click left or right arrow scroll button on date navigator of leave application will append record
• Import and save pending transactions prompt error duplicates not allowed

• Fixed PR.Zakat Report spelling error
• Fixed PR.Payslip1C format Unpaid Leave Day incorrectly shown when Batch print
• Fixed PR.Credit.BankInstruction report ROC not correctly shown
• Add Tabung Haji report
• Fixed Hong Leong bank Connect First excel file format – Validation ID value not in uppercase
• Fixed #5446: Mizuho bank IBG file format is invalid
• Feature #5445: Add Affin bank “AutoPay Excel 2” file format
• Feature #5448: Add Invotime under File | Import Data
• Feature #5449: Add AmBank Bulk Payment file format
• Show tax calculation on Edge web browser
• Allow user to select WhatsApp contact, WhatsApp group, application contact on WhatsApp window

• Upgrade Database to Version 105. Tunning SY_PROFILE & PT_AD table
• Add Total Unpaid Leave Day beside Description for Payslip
• Add leave application data import on Check Time window
• #5433: Copy and paste employee record prompt error “No argument for format %s(%s) not found”
• Feature #5432: Add leave entitlement processor script – based on 365 days proportion, round to day
• Trim space and replace non-breaking space (nbsp) in email field with empty string
• Feature #5430: Add Maybank Universal Payment Zakat file format
• Feature #5436: Add Mizuho bank IBG, InHouse file format
• Fix out of memory error on syncing leave application & paysheet resources
• Feature #5435: Increase employer zakat number field length to 20
• #5437: Bank Islam Salary Credit text file format “Credit Account Number” column is only applicable for intra-bank transfer
• HSBC HUB MRI and ACH file format – Incorrect bank code if employee bank is HSBC Amanah
• Feature #5440: Hong Leong bank Connect First EIS excel file format
• #5439: Maybank2E-RC Universal Payment file format – Invalid bank code of Bank Muamalat
• Fix Save pending transaction prompt project cannot be blank when employee code is invalid
• #5441: Missing bank codes in AmBank Net Salary file format
• Add data provider and data import via command line

• Upgrade Database to Version 104
• Add PR.Tax.CP22-2020 format
• Enable Payslip to support User Define EMail Content Using EMail Template
• Fix Payslip Batch Email Client body Content not properly shown
• Feature #5420: Add Bank Islam Salary Credit text file format
• Prevent employees have the same email before sync to server
• #5403: RHB bank SOCSO excel file format – Fill “Employee SOCSO Number” column when employee new IC number is blank
• #5413: LHDN CP39 text file format detail record “Employee No” column doesn’t exclude non-alphanumeric characters
• #5412: Add HSBC bank EIS text file format
• #5408: UOB Interbank Giro and Inter Account Fund Transfer file format – Invalid purpose code of batch detail record if beneficiary is non-resident

• Upgrade Database to Version 103
• Add PR.Tax.Lampiran B – Format 3
• Add PR.Zakat.BorangSkimBerkat-Kelantan format
• Enable user Self Define Body Email & Subject for EC 2019 & 2020
• Increase PCB Receipt No. Size for PR.Tax.PCB2(II)-2012 format
• Add PR.Tax.CP8D-2019-BorangE – Part A format
• Fixed PR.Tax.CP8D-2019 page 2 header not update
• #5401: Reduce employee EPF rate to 7% with effect from 1 Apr 2020 to 31 Dec 2020
• #5378: Prevent user unchecked PCB if allowance had assigned with tax code when edit employee paysheet
• Fix cloud server employee data not up to date after sync due to employee record rowver not increase after append, update or delete detail dataset record
• #5391: Marital status column of each employee record is blank in income tax lampiran 2 text file

• Add income tax calculation for year 2020
• #5369: Change employee country to non “MY” auto uncheck resident
• #5368: Prompt message when contribution EPF rate is below statutory contribution rate
• #5367: Allow user to group payment summary by branch, department, hrgroup or category (either one)
• #5373: Alliance BizSmart Bulk Payment – Add “Payment Advice Indicator” option
• Fix cloud server data not up to date due to change code of master data
• Add PT.Compensation.Report

• Upgrade Database to Version 102. – Tunning HR_LO_TRANS table
• Add Compensation Column for PR.Summary.Grouped.Report 1 format
• Rename PR.Summary.Grouped.Report to PR.Summary.Grouped.Report 1 format
• Add PR.Summary.Grouped.Report 2 format
• Add HR.Employee.Appointment.Report-BM format
• Fixed PR.Yearly.IndividualPay.Report Detail Overlap when use Merge Options
• Fixed OT Description unable fully shown for PR.Payslip1A.Report-V2 & PR.Payslip1C.Report-V2 format
• Add HR.Employee.Report-BM, PR.Payslip1A.Report-V2-BM and PR.Payslip1C.Report-V2-BM format
• Add PR.Payslip1C.Report-V2 format
• Add Summary OT for PR.Payslip1A.Report-V2 format
• Add overtime summary dataset to payslip report
• Add No. of Working Days for PR.Payslip1A.Report-V2
• Fixed PR.Tax.CP22 Spouse Tax Number not fully shown

• #5356: EPF, SOCSO and income tax output file detail records not same as grid filtered records
• Fix sync cloud prompt error could not convert variant of type (null) into type (integer)
• #5355 Process payroll based on filtered employee list

• Upgrade Database to Version 101 – Tunning Table SY_PROFILE & PT_UL table
• Feature #5346: Income tax reports sort by employee name
• Fix number of reports exclude from top 5 employees restriction
• Increase field length for company Name for PR.Tax.PCB2(II)-2012
• #5350: Apply payroll summary report prompt error “column unknown” if group by project, job or task
• #5348: Add rate to pending unpaid leave
• Feature #5267: Click “Print PCB” label open built-in PCB calculation if no internet connection

• Upgrade Database to Version 100 – Add PT_CP table
• #5336: Payroll summary report unable to sort by employee name
• #5104: Remove unused “Inquiry” menu
• Add #5307: Tax exemption on compensation for loss of employment
• #5334: Add bank code for Islamic banks
• #5345: Open and close employee payroll windows prompt error “Cannot focus a disabled or invisible window”

• Upgrade Database to Version 99 – Tunning SY_USER table
• Update PR.EPF.BorangA.2009.Report No Rujukan Borang A format
• Fix incorrect account number of detail record of Affin bank AutoPay text file format
• Allow user choose to include employee payroll info before sync to server
• Add data import from EMAS payroll
• Add Unpaid Leave detail to sub report 3 for PR.Payslip1A.Report format

• Enhance & Retuning Report
• Fix #5287: Unable to display message with unicode string on payslip report
• Fix #5289: Incorrect length of SOCSO account number column of AmBank AutoPay SOCSO text file format
• Fix leave application cloud_autokey always null after sync if the leave application created by user