SQL Payroll Releases

• 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

• Upgrade Database to Version 97 – Tuning LV_APP table
• Feature #5216: Add income tax Lampiran B report for year 2019
• Add PR.Tax.Lampiran B – Format 1 & Format 2
• Add PR.Summary-30C-L2.Report
• Add Sub Detail for Yearly Individual Pay report
• Fix bug #5254: Current month additional remuneration no separate to bonus, commission, director fees and others when pre-fill data on IRB calculator
• Feature #5206: Add AmBank Net Payroll EIS text file format
• Fix missing trailing spaces on receiver name column of Affin bank CIB Bulk Payment text file format
• Fix missing 6 spaces on trailer record of Affin bank AutoPay text file format
• #5235: OCBC bank EPF text file format “Employee Identification No” column is blank if the employee has passport number only
• #5247: Incorrect amount of deduction summary due to same cube cell ID even though employees code are unique
• Fix Hong Leong bank Connect BIZ EIS payment column B of header and detail header are blank

• Fill employee name line 2 continuation from employee name line 1 if employee name exceed 40 characters
• Fix Hong Leong bank Connect BIZ SOCSO payment excel file format “Member SOCSO No” column cannot leave blank
• Adjust implementation of leave application data item
• Fix sync error of approved leave application
• #5221: Missing records in IRB payment file format
• #5209: Pre-filled data for verification in LHDN calculator

• Upgrade Database to Version 96 – Add HR_EMP_MGR table
• Fix income tax lampiran 2 report contains record “zakat from deduction” even though the actual deduction without subject to zakat deduction
• Add HR.Employee.Payment By Cash Letter
• #5178: Display error on tax rate percentage when preview PCB calculation
• #5170: Add commission to non month end payroll will calculate PCB amount even though the payroll processed without calculate PCB
• #5172: Unable to remove temporary tables after process payroll
• Allow user to change post date of pending leave application via sync cloud; exclude cancelled leave application before display on grid
• Feature #5162: Add Affin bank EIS text file format
• Add Affin bank CIB Bulk Payment text file format
• #5177: Application always start with default theme even though user already disabled the theme
• #5100: Add RHB bank BulkPay Payroll file format
• #5099: Add RHB bank BulkPay Statutory Payment file format
• Add support of manager by branch or department

• Fixed HR.Employee.Listing Export Excel Allowance empty
• Fixed HR.Employee.Increment.Report Export to Word content overlap
• Add Employee Socso no in NRIC column for PR.SOCSO.Borang8A(201407).Report
• Add income tax EA, EC, CP8D and eData Praisi reports for year 2019
• Add Payable HRDF amt for PR.HRDF-HRDFOnly
• Feature: Default theme set as stardust
• Add data import from a zip file contains multiple csv files – File | Import Data | Batch Import.
• Feature #5153: Add EcoTimePrint under File | Import Data
• Feature #5106: Add AmBank AutoPay Payroll EIS text file format
• Update AmBank AutoPay Payroll text file format based on version 4.1
• Feature #5136: Add OCBC bank EIS text file format

• Database upgrade to version 95. – Tunning PR_AL, PR_CONTRIB, SY_DIY_OBJECT, SY_DIY & PT_TD Tables
• Fixed PR.Tax.BorangEA-2018 & 2019 -English – Column B3 & B4 line overlap with amount
• Add income tax Lampiran 2 report
• Fix #5019: Employee tax category is blank when preview payroll yearly individual report
• Fix “Myco ID/SSM Number” column of EIS Lampiran 1 text file format can contains only characters A-Z and 0-9
• Fixed PR.Tax.CP8D-2016 & 2017 field mapping error
• Fixed PR.Tax.CP8D-2018 export excel all font in white color
• Enable Batch Email for PR.Tax.PCB2(II)-2012
• Enlarge the Receipt No field to support up to 18 char for PR.Tax.PCB2(II)-2012
• Feature #5066: Auto add allowance contribute to PCB if employee SOCSO borne by employer
• Add EA Form to Sync Cloud
• Add Hong Leong bank Connect BIZ EIS excel file format
• Generate Public bank ECP excel file with .xlsx extension
• Add Affin bank AutoPay text file format

• Database upgrade to version 93. – Tunning Contribution Table
• Enable PDF password for Batch Email for EC 2018 & 2019
• Enable PDF password for Batch Email for EA 2018 & 2019
• Fixed PR.Tax.CP8D-2018 detail at page 2 not correctly shown column
• Fixed PR.Tax.CP8D-2018 Year not not update in 2nd page
• Feature #5039: Reduce contribution EPF rate by half if rate is 22% and above

• Database upgrade to version 92. – Tunning SY_Profile Table
• Feature #4981: RHB EIS excel file format
• Feature #4996: Public bank EIS text file format
• Feature #5012: CIMB EIS text file format
• Feature #4974: Alliance bank EIS text file format
• Feature #4979: Change SOCSO type to “Second Category” auto change the EIS type to “No”
• Fixed PR.Tax.CP8D-2017 & PR.Tax.CP8D-2018 some total field not correct when more then 1 page
• Feature #4979: Change SOCSO type to “Second Category” auto change the EIS type to “No”
• #5001: Preview leave entitlement report prompt error access violation
• #4987: Payroll summary report show tax exemption of the process after user edit paysheet even though the process no calculate PCB
• #4992: Yearly payroll report | Yearly employer EIS , system no capture the new amended Employer EIS Amount.
• Fixed PR.Tax.CP8D-2017 & PR.Tax.CP8D-2018 field mapping not correct column
• Fixed PR.Tax.CP8D-2018-BorangE not correct year
• Fix PR.Tax.PCB2(II)-2012 format alignment problem
• Add PR.Tax.CP8D-2018 & PR.Tax.CP8D-2018-BorangE format
• Fixed PR.Tax.BorangEA-2019-BM.Report EA word not Fully shown
• #4985: Change employee SOCSO on paysheet prompt error “Interface not supported”

• Database upgrade to version 92
• Add PCB calculation for year 2019
• Add Maybank2E-RC Universal Payment EIS text file format
• Rename “Print Income Tax Lampiran B” to “Print Income Tax Lampiran B (PCB Audit)”
• Replace “ID Number” column with “New IC” column for SOCSO text file format
• Reduce employer share of EPF contribution rate for post-retirees from 6% to 4%
• Employer must make SOCSO contribution for foreign workers
• Sync to Cloud

• Apply payroll summary (work unit) report prompt error “list index out of bound”
• CIMB Bulk Payment with Email Notification file format – “Payment Reference Number” column is empty, “Total Amount” column always zero amount
• Incorrect average leave entitlement calculated if the employee with join date fall after January of the ???
• UOB Interbank Giro and Inter Account Fund Transfer file format – “Beneficiary Resident Indicator” column is empty
• Employee marital status can set as blank

• Adjust implementation of AmBank AutoPay Payroll file format
• #4795: Incorrect description of detail record of payment voucher after import
• #4819: Public bank ECP Excel 3 – Column F is empty if the employee record with passport number only

• Add LV.Balance.Report-Leave Application
• Fix LV.Balance.Report-Employee Performance preview error
• Change leave balance report day columns footer summary kind to sum
• Adjust UOB Interbank Giro and Inter Account Fund Transfer file format due to file control header and batch details exceed 1802 columns
• Feature #4708: Add CIMB Bulk Payment with Email Notification file format
• #4740: Enter leave application with day as time more than 8 hours will reset to 0 hour
• Add Hong Leong bank Connect First file format
• #4758: Alliance bank BizSmart Bulk Payment excel “Beneficiary Old IC No” column spelling error
• #4741: Change date of annual leave prompt error “payroll already closed, apply unpaid leave is not allowed”
• #4739: Incorrect file name of Public bank ECP excel file

• Upgrade Database to Version 91
• Add Total Wages for PR.EPF.List.Report
• Fixed HR.Loan.Repayment.History Grand Total not correct sum
• Fix incorrect sequence number of current month deduction when preview PCB calculation
• Remove redundancy field in LV.Application.Report
• Add HR.Employee.Interview Assessment Form, HR.Employee.Listing & HR.Employee.Termination.Letter format
• #4632: Incorrect sequence number on customize income tax EA and EC form
• Update PR.Tax.CP8D-2017 to enable print more records in 1 page
• Add PR.Summary-30C-L1.Report
• Feature #4670: Add Public Bank ECP Excel File Formats
• #4712: Project, job and task of pending wages record not updated if change employee
• Allow user to enter payment description for detail record of CIMB ePayroll Payment file format
• Update IBG participant banks of CIMB ePayroll Payment file format
• Featue #4614: Allow user to disable action dialog if apply leave exceed entitle limit
• Rename “Bank of Tokyo-Mitsubishi UFJ (Malaysia) Berhad” to “MUFG Bank (Malaysia) Berhad”

• Upgrade Database to Version 90
• Rename PR.Yearly.IndividualPay.Report filename
• Add LV.Balance.Report-Employee Performance report
• Update PR.Tax.BorangEA-2017 & 2018 Alignment for Export to Excel
• Enable support Batch EMail for Yearly Individual Pay report
• #4574: Fail to upload HRPay IRB text file to Maybank web server due to employer IT group not left padded with spaces, employee IT group cannot leave blank
• Feature #4586: Add DaysBetweenStartAndEndDate parameter to overtime pay rate calculation
• #4590: Employee age 60 years 0 month does not exclude from EIS contribution
• Fix GL account lookup unable to display unicode text
• Feature #4432: Standard Chartered Bank Bulk Payroll Excel File Format
• Feature #4219: Add RHB Reflex EPF and SOCSO Excel File Format
• Feature #4502: Add UOB Interbank Giro and Inter Account Fund Transfer File Format
• #4599 and #4601: Incorrect employee SOCSO type, EPF rate and employer EPF rate if employee age 60 years 0 month after process payroll
• Feature #4600: Add Nexpro TimeTracX under File | Import Data
• Feature #4534: Employer paid employee share for EIS contribution

• Internal Release

• Fix #4542: Apply HRDF report prompt dynamic SQL error if filter by project, job or task
• Fix #4549: Incorrect number of children qualified for tax relief in income tax reports if there is a child record with eligible rate 0%
• Fix #4543 Incorrect display the process parameter in Print Contribution Info report
• Fix #4563: Payroll yearly individual report filter by HR group not working
• Fix 4530: Unable to remove adhoc / frequency payroll process with empty transaction after process month end payroll
• Fix date of payment voucher or journal entry always one day less than actual date after import
• Feature #4537: Add “Bank of China (Malaysia) Berhad” to bank drop down list
• Feature #4528: Change “Auto claim SOCSO for calculate PCB” caption to “Claim SOCSO relief in PCB calculation (TP1 Form submitted)”
• Feature #4472: Add “Kuwait Finance House (Malaysia) Berhad” to bank drop down list
• Feature #4502: Add UOB SOCSO text file format

• Update EIS Lampiran 1 excel file to new format
• Feature #4529: Add EIS Lampiran 1 text file format
• Feature #4527: Add Remuneration field to main dataset of SOCSO Borang 8A and EIS Lampiran 1 report
• Fix failed to upload SOCSO form 8A text file to SOCSO portal assist due to file extension in uppercase
• Fix #4518: Save paysheet prompt error data is read only if auto mark finalize option is checked
• Feature #4523: Add “Print EIS Lampiran 1” button on welcome page of month end payroll process
• Feature #4519: Add spouse of an employer to EIS category
• Feature #4521: Update employee EPF rate to “A” if the rate below 11% and employer EPF rate to “A” if the rate below 12%
• Feature #4525: Open employee paysheet always show payroll info page

• Add EIS Lampiran 1 excel file format
• #4511: EIS Borang 2 / 2A report does not exclude employee age below 18 and age 60 and above

• No more support Windows XP & Windows Server 2008 and below
• Bug #4498: Hong Leong bank Connect BIZ excel “Beneficiary Email Address” column does not fill with employee email
• Bug #4497: Changes on leave application record will revert to old value after save
• Add support of MUFG Giro Email Notification file format
• Bug #4506: Change leave type of leave application prompt error access violation
• Feature #4504: No EIS contribution for employee age below 18
• Feature #4505: Rename description of EIS category and remove unused EIS category
• Bug #4507: Payroll yearly individual report does not exclude employee already resigned
• Fix incorrect number of children qualifed for tax relief in income tax reports
• Feature #4496: Change default output directory to C:\ for all banks and statutory bodies output file
• Fix incorrect value of tax exempted in income tax e-Data Praisi report for year 2017
• Add income tax Lampiran B report

• Fix EIS Borang 2 / 2A report does not exclude inactive employee, employee with EIS type equal to zero
• Add EIS type and EIS category column to employee record browse grid
• Fix bug #4491: Edit employee paysheet of adhoc payroll auto calculate EIS contribution even though the user choose not calculate EIS for the adhoc payroll
• Fix bug #4492: Missing leading zero for state code column in Hong Leong bank Connect BIZ EPF excel file format
• Fix bug #4493: Unable to process payroll for employee with join date fall after start of the payroll month
• Fix bug #4494: Employee default allowance contribution setting does not follow the origin allowance contribution setting after assign allowance code

• Fix bug #4486: EIS Borang 2A report does not exclude employee already resigned, employee with default remuneration does not contribute to EIS
• Fix unable to process payroll for employee with resigned date
• Add support of print EIS listing report
• Add feature #4485: Add income tax e-Data Praisi for year 2017
• Calculate EIS if employee EIS type is “Yes”
• Database upgrade to version 86

• Bug #4409: Missing employee information columns on leave application batch entry
• Feature #4418: Add “Bank Pertanian Malaysia Berhad” to bank drop down list
• Fix employee name is empty after read from MyKad
• Fix application prompt override access right window twice even though ADMIN override the access right
• Generate Hong Leong bank connect biz excel file with .xlsx extension due to bank web server return error message “system error”
• Prompt message to user before save employee leave application if total days on the date exceed 1 day
• Add process date, description 2, ref 1 and ref 2 columns to payroll process lookup
• Bug #4453: Print PCB calculation of year 2017 show “education and medical insurance premium” with “deferred annuity premium” amount
• Feature #4459: Add support of merge payroll yearly individual pay reports into one report
• Provide user an easy way to configure unpaid leave calculation without write script
• Provide user an easy way to configure leave bought forward without write script
• Provide user an easy way to configure leave entitlement policy without write script
• Add HRDF rate to company profile
• Calculate HRDF report for the month of the year
• Feature #4461: Application will not calculate amount for pending overtime or unpaid leave if amount not equal to zero unless “use system calculated amount for pending overtime/unpaid leave” option is checked
• Feature #4462: Allow user to process final payroll for the month by employee, branch, department, etc
• Add EIS calculation for year 2018
• Feature #4465: Employee EPF rate revert to 11% effective Jan 2018 payroll
• Add PCB calculation for year 2018
• Database upgrade to version 85

• Purpose code is not required if payment mode is “IFT” in AmBank Net Salary file format
• Fix bug #4346: Wages trans always post to default GL account regardless of GL account for each wages code, if generate payment voucher per employee
• Add support of print EIS listing reportReposition “Apply” button on report param form
• Fix HRDF report one cent different issue
• Add feature #4379: Add access right “Apply leave exceed leave entitle limit”
• Fix preview payroll summary report more than one time prompt error “Interface C? already registered”
• Fix bug #4347: Missing hidden columns in Hong Leong bank CONNECT BIZ EPF, SOCSO and IRB excel file format
• Fix bug #4395: Missing data for header, sub header and footer record in RHB EPF text file format
• Fix preview payroll summary report more than one time prompt error “Interface C? already registered”Fix bug #4339: Add category parameter to reports
• Set page buffers to 300 MB for existing database
• Database upgrade to version 84

• Show description of payroll process after user select a payroll process from drop down list

• Add HR.Employee.Acceptance Of Resignation Letter, HR.Employee.Confirmation Evaluation Form, HR.Employee.Employment Application Form
• Fix bug #4233: Failed to upload fixed length or csv file to KWSP web server due to employee name contains special character
• Add ANVIZ under File | Import Data
• Fix bug #4302: State code does not set 014 for header record of OCBC bank EPF text file format
• Fix bug #4276: RHB Payroll excel file format – field length without limit
• Add support of payroll accounting
• Database upgrade to version 83

• Purpose code is not required if payment mode is “IFT” in AmBank Net Salary file format
• Fix PR.Tax.CP8D-2016-BorangE unable to fully show amount more than 100000 for Grand Total
• Fix bug #4171: Incorrect caption of passport number field on customize income tax EA form
• Feature #4186: Add 0% option to eligible rate of claim child deduction
• Generate RHB bank smart payroll excel file with .xlsx extension due to bank web server return error message “unable to read the file” if without re-save the excel file with excel application
• Feature #4201: Add leave module to accountant set
• Allow user to enter generic payment information if user select Alliance bank BizSmart Bulk Payment file format
• Revert header of column E and F to “Employee Internal ID” and “Customer Reference” in Hong Leong bank ePayment excel file format
• Fix preview payroll summary report more than one time prompt error “Interface C? already registered”Fix bug #4339: Add category parameter to reports
• Fix PCB amount one cent different after recalculate
• Feature #4207: Rewrite note for employees receive monthly wages 5000 and below, the employer contribution is 13%
• Feature #4211: File naming convention is SCEF_CompanyShortName.txt for Alliance bank SOCSO-12 digit text file format
• Fix bug #4215: Open leave entitlement window prompt dynamic SQL error if leave code is numeric
• Fix bug #4216: Paste employee record prompt error “You are not allowed to change DeductAttr”
• Add View | Smart Card Reader