SQL Payroll

Tuesday, April 9, 2019

SQL Payroll Latest Version (145)

Information
Last updated: 02/04/2019
Current version: 1.2018.166.145

Release notes

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

SQL Payroll Latest Version (144)

Information
Last updated: 18/02/2019
Current version: 1.2018.164.144

Release notes

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

SQL Payroll Latest Version (142)

Information
Last updated: 11/01/2019
Current version: 1.2018.162.142

NEW FEATURES:

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.

Fixed bug list:

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.

SQL Payroll Latest Version (141)

Information
Last updated: 23/10/2018
Current version: 1.2018.161.141

Release notes

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.

SQL Payroll Latest Version (140)
Information
Last updated: 12/10/2018
Current version: 1.2018.159.140

Release notes

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

SQL Payroll Latest Version (139)
Information
Last updated: 26/07/2018
Current version: 1.2018.157.139

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"

SQL Payroll Latest Version (138)
Information
Last updated: 16/04/2018
Current version: 1.2018.156.138

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