Friday, November 15, 2024

SQL Payroll Latest Version (v213) Date : 29 Oct 2024

 

SQL Payroll 1.2024.266.213

Released on October 29, 2024
Release Notes
  • 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

Monday, October 7, 2024

SQL Payroll Latest Version (v212) Date : 02 Oct 2024

 

SQL Payroll 1.2024.265.212

Released on October 2, 2024
Release Notes
  • #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

Tuesday, October 1, 2024

SQL Payroll Latest Version (v211) Date : 26 September 2024

 

SQL Payroll 1.2024.264.211

Released on September 26, 2024
Release Notes
  • 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

SQL Payroll Latest Version (v210) Date : 30 August 2024

 

SQL Payroll 1.2024.262.210

Released on August 30, 2024
Release Notes
  • #6089: Payroll yearly reports missing access rights
  • #6087: Update CP22 LHDN file format
  • #6062: Add payment method option before process payroll

SQL Payroll Latest Version (v209) Date : 14 August 2024

 

SQL Payroll 1.2024.261.209

Released on August 14, 2024
Release Notes
  • 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

Tuesday, July 16, 2024

SQL Payroll Latest Version (v208) Date : 13 July 2024

SQL Payroll 1.2024.260.208

Released on July 13, 2024
Release Notes
  • 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

Wednesday, May 29, 2024

SQL Payroll Latest Version (v207) Date : 30 April 2024

SQL Payroll 1.2024.259.207

Released on April 30, 2024
Release Notes
  • 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