SQL Payroll Latest Version (120) Date: 12th Nov 2016

Information

Last updated: 12/11/2016
Current version: 1.2016.128.120

New in this version

• Fix missing amount column header in Hong Leong bank Connect BIZ file format
• Fix bug #3940: Incorrect SOCSO amount calculated for remuneration exceed 3000 if process Jan 2017
• Fix bug #3939: Copy and paste record in pending payroll prompt "You are not allowed to change ContribAttr" error
• Update (VAR)CHAR fields to support unicode character sets
• Database upgrade to version 79 (unicode)

Previous Update Version 127.119

• Add PR.Tax.CP22B-2015 & PR.Tax.CP21-2015 report
• Adjust number of controls not align properly on paysheet form
• Add support of HSBC HUB ACH file format
• Fix blob columns not display correctly in employee browse grid
• Set employee photo to read only on leave application form
• Fix bug #3866: Unable to apply unpaid leave even though leave date does not fall in cut-off date range of final payroll for the month
• Add support of compress employee photos (size below 180KB)
• Fix missing an employee record after upload csv file to EPF web server due to first row is not blank in csv file
• Fix incorrect employee tax number in IRB file formats
• Fixed PR.Tax.CP22A-2015 no Grand Total
• Add support of generate bank excel files without microsoft excel installed on the machine
• Add support of Hong Leong bank Connect BIZ file format; update Hong Leong bank ePayment file format to version 4.0
• Feature #3767: Upgrade database numeric fields to support precision 18 so that can store more digit numbers
• Feature #3766: All Phone and Fax Fields upgrade from 20/30 to 200 characters
• Fix bug #3924: Employee IC number, EPF number and Socso number columns not pad with zero if blank in EPF and Socso excel file of RHB Reflex file format
• Feature #3869: New overtime record exempted from EPF contribution
• Database upgrade to version 78

SQL Payroll Latest Version (119) Date: 25 Oct 2016

 Information

Last updated: 25/10/2016
Current version: 1.2016.127.119

New in this version

• Add PR.Tax.CP22B-2015 & PR.Tax.CP21-2015 report
• Adjust number of controls not align properly on paysheet form
• Add support of HSBC HUB ACH file format
• Fix blob columns not display correctly in employee browse grid
• Set employee photo to read only on leave application form
• Fix bug #3866: Unable to apply unpaid leave even though leave date does not fall in cut-off date range of final payroll for the month
• Add support of compress employee photos (size below 180KB)
• Fix missing an employee record after upload csv file to EPF web server due to first row is not blank in csv file
• Fix incorrect employee tax number in IRB file formats
• Fixed PR.Tax.CP22A-2015 no Grand Total
• Add support of generate bank excel files without microsoft excel installed on the machine
• Add support of Hong Leong bank Connect BIZ file format; update Hong Leong bank ePayment file format to version 4.0
• Feature #3767: Upgrade database numeric fields to support precision 18 so that can store more digit numbers
• Feature #3766: All Phone and Fax Fields upgrade from 20/30 to 200 characters
• Fix bug #3924: Employee IC number, EPF number and Socso number columns not pad with zero if blank in EPF and Socso excel file of RHB Reflex file format
• Feature #3869: New overtime record exempted from EPF contribution
• Database upgrade to version 78

Previous Update Version 126.118

• Add HR.Employee.Report-Invalid Value report
• Fix bug #3830: Payroll calculator prompt EPF option not supported when click calculate

PP10How to Process Loan and SQL Loan(additional module)

SQL Payroll Latest Version (118) Date: 09 Aug 2016

Information

Last updated: 09/08/2016
Current version: 1.2016.125.118

New in this version

• Add HR.Employee.Report-Invalid Value report
• Fix bug #3779: Zakat report does not exclude record with zero amount
• Fix bug #3780: Zakat output file does not match with grid filter condition
• Scale leave type button on leave application form to support high DPI monitor
• Prompt user friendly message when fail to generate excel output file due to microsoft excel not installed on the machine
• Experimental: Add support of Al Rajhi bank payment upload file format
• Use WorkingDate for Date at footer for EA & EC Form
• Fix bug #3794: Child of 18 years old with tax code (TC.2000 and TC.2500) not entitled for deduction in monthly tax deduction calculation for year 2016
• Fix bug #3795: Application always prompt message if last month final payroll not processed even though first time process final payroll
• Adjust contact number column should pad to left in Public bank EPF file format
• Add PR.Credit.BankInstruction-2.Report & remove PR.Credit.BankInstruction-EON.Report
• Feature #3764: Calculate EPF based on remuneration in the AdHoc process only, without balancing
• Database upgrade to version 77

Previous Update Version 117

• Rename description for pending payroll items in maintain DIY view template
• Fix bug #3727: Socso borang 3 report does not exclude employee with no socso category if employee resigned on the month
• Fix bug #3765: Missing "like" and "not like" filter operator on View Template form
• Fix Payslip Batch E-Mail Subject is empty
• Enable Payroll Summary Title following selected Report Type

SQL Payroll Latest Version (117) Date: 01 July 2016

Information

Last updated: 01/07/2016
Current version: 1.2016.124.117

New in this version

• Rename description for pending payroll items in maintain DIY view template
• Fix bug #3727: Socso borang 3 report does not exclude employee with no socso category if employee resigned on the month
• Fix bug #3765: Missing "like" and "not like" filter operator on View Template form
• Fix Payslip Batch E-Mail Subject is empty
• Enable Payroll Summary Title following selected Report Type

Previous Update Version 116

• Add SOCSO calculator for year 2016
• Fix incorrect hash total due to employee EPF No / SOCSO No / Tax No may exceed column length in Maybank HRPay file format
• Fill employee's identifying initials column with employee code for each EPF record if maybank universal payment file format selected
• Fix incorrect total record of employee or employer contribution if there is record contains employee or employer contribution amount with zero (maybank universal payment file format)
• Fix bug #3715: There are fields (such as WorkUnit, Rate or PayRate) without display format when preview report
• Add feature #3714: Remove temporary tables before start of backup operation, as default setting
• Fix bug #3699: Compile "User Entry Form" OnOpenForm script prompt access violation error
• Fix bug #3682: Unable to export to e-mail client if PDF format is selected
• Fix bug #3668: Memory leak occurred if preview report with FastReport template that contains codes call TfrxDataSet.GetLocalData method

SQL Payroll Latest Version (116) Date: 02 June 2016

Information

Last updated: 02/06/2016
Current version: 1.2016.123.116

New in this version

• Add SOCSO calculator for year 2016
• Fix incorrect hash total due to employee EPF No / SOCSO No / Tax No may exceed column length in Maybank HRPay file format
• Fill employee's identifying initials column with employee code for each EPF record if maybank universal payment file format selected
• Fix incorrect total record of employee or employer contribution if there is record contains employee or employer contribution amount with zero (maybank universal payment file format)
• Fix bug #3715: There are fields (such as WorkUnit, Rate or PayRate) without display format when preview report
• Add feature #3714: Remove temporary tables before start of backup operation, as default setting
• Fix bug #3699: Compile "User Entry Form" OnOpenForm script prompt access violation error
• Fix bug #3682: Unable to export to e-mail client if PDF format is selected
• Fix bug #3668: Memory leak occurred if preview report with FastReport template that contains codes call TfrxDataSet.GetLocalData method

Previous Update Version 115

• Report will now calculate correctly if report param window contains parameter using TcxSpinEdit control and application tabbed docking mode is enabled
• PR.Tax.CP8D-2015 Nama field renamed to Company Name
• SOCSO excel file should now be able upload to Hong Leong bank web server as previously may fail due to state code contains invalid value
• Join date and resign date field is now correctly bind in customized EA form
• Adjust bank instruction, EPF, SOCSO and IRB text file format save with ANSI encoding
• Fill SSM number with company register number for SOCSO file format
• Database upgrade to version 76

SQL Payroll Latest Version (115) Date: 19 Apr 2016

Information

Last updated: 19/04/2016
Current version: 1.2016.122.115

New in this version

• Report will now calculate correctly if report param window contains parameter using TcxSpinEdit control and application tabbed docking mode is enabled
• PR.Tax.CP8D-2015 Nama field renamed to Company Name
• SOCSO excel file should now be able upload to Hong Leong bank web server as previously may fail due to state code contains invalid value
• Join date and resign date field is now correctly bind in customized EA form
• Adjust bank instruction, EPF, SOCSO and IRB text file format save with ANSI encoding
• Fill SSM number with company register number for SOCSO file format
• Database upgrade to version 76

Previous Update Version 114

• Add Bahagian A information for PR.Tax.CP8D-2015
• Other performance & stability improvements

SQL Payroll Latest Version (114) Date: 21 Mar 2016

Information

Last updated: 21/03/2016
Current version: 1.2016.121.114
Size: 32.5 MB

New in this version

• Add Part A information for PR.Tax.CP8D-2015
• Other performance & stability improvements

Previous Update Version 113

• Add Email Script for EA & EC for 2015 & 2016
• Add support of income tax CP8D report for year 2015
• Add support of OCBC bank SOCSO file format version 2.0
• Adjust Payroll AutoPay AmBank (EPF, SOCSO and Income Tax) file format implementation
• Other performance & stability improvements

SQL Payroll Latest Version (113) Date: 08 Mar 2016

Information

Last updated: 08/03/2016
Current version: 1.2016.120.113
Size: 32.5 MB

New in this version

• Add Email Script for EA & EC for 2015 & 2016
• Add support of income tax CP8D report for year 2015
• Add support of OCBC bank SOCSO file format version 2.0
• Adjust AmBank AutoPay Payroll (EPF, SOCSO and Income Tax) file format implementation
• Other performance & stability improvements

Previous Update Version 112

• Add support of EPF rate sensitive to year and month
• PT.UnpaidLeave.Report add Leave Days column
• Contribution setting changed if refresh data entry form after copy and paste record
• Add support of income tax CP22A report for year 2015
• Other performance & stability improvements

SQL Payroll Latest Version (112) Date: 25 Feb 2016

Information

Last updated: 25/02/2016
Current version: 1.2016.119.112
Size: 32.5 MB
License: Demo (Username & Password: ADMIN) 

New in this version

• Add support of EPF rate sensitive to year and month
• PT.UnpaidLeave.Report add Leave Days column
• Contribution setting changed if refresh data entry form after copy and paste record
• Add support of income tax CP22A report for year 2015
• Other performance & stability improvements

Previous Update Version 111

• Disable Windows TaskBar thumbnail button by default
• Add IsActive field in main dataset of loan repayment history report
• Add EPF report for year 2011
• Fill employee's IC number with employee old IC or passport number if new IC number is empty for CIMB EPF file format
• Other minor improvements

SQL Payroll-Latest Training (Express Course)

NEW INTAKE 招生!! (Express Course)
SQL-Payroll Latest Training
Eng/Malay Class (英/巫 講解)
Date: 27th Jan 2016 (Wednesday)
Time: 02.00pm-04.00pm
------------------------------------------------------
How to Reserve Your Seat?
(This step is compulsory otherwise consider unregistered.)

Whatapps/sms to HP: 017-891 6008
<Company Name> space <P> space <No of seat>

Example:
Super Star Sdn Bhd P 2 seat
---------------------------------------------------------
Fee:
**RM350per pax.
**F.O.C. for Concept Software Sdn Bhd existing customer with CSS Cover Plan.
---------------------------------------------------------
Venue :
Concept Software Sdn Bhd
(SQL Training Centre)
87A, Jalan Raja Uda, Pusat Perniagaan Raja Uda, 12300 B'worth.
(Beside Nasi Kandar Salam, Raja Uda)