Wednesday, July 12, 2017

SQL Payroll Latest Version (129) Date :

Information

Last updated: 
Current version: 1.2017.142.129

New in this version

  • 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
  • Bug #4283: NextDocNo in all sales & purchase document entry screen not aligned with the label

Friday, May 19, 2017

SQL Payroll Latest Version (128) Date : 12th May 2017

Information

Last updated: 12/05/2017
Current version: 1.2017.139.128


New in this version

  • Add RHB Payroll excel file format

Previous Update Version 138.127
  • 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 bug #4202: Employment status (employee resigned within the month) is empty for detail record of Alliance bank SOCSO text file format
  • 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

Wednesday, May 3, 2017

SQL Payroll Latest Version (127) Date : 28th April 2017


Information

Last updated: 28/04/2017
Current version: 1.2017.138.127

New in this version

  • 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 bug #4202: Employment status (employee resigned within the month) is empty for detail record of Alliance bank SOCSO text file format
  • 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

Sunday, March 26, 2017

SQL Payroll Latest Version (126) Date : 24th March 2017

Information

Last updated: 24/03/2017
Current version: 1.2017.137.126

New in this version

  • Fix bug #4151: Unable to delete employee record due to there are records in PT_INFO_CHILD table after clone master data
  • Fix display format error in PR.Payslip.Report-PCB.TP1-2017
  • Add Total for Contribution for PR.HRDF
  • Fix bug #4160: Incorrect value of A1 column in income tax CP8D report for year 2016
  • Fix bug #4163: Incorrect tax category if an employee is divorced or widowed, without child
  • Remove limit checking for PR.Tax.CP8D-2016-BorangE format

Wednesday, March 15, 2017

SQL Payroll Latest Version (125) Date : 11th March 2017


Information

Last updated: 11/03/2017
Current version: 1.2017.136.125

New in this version

  • Replace crediting date with value date parameter on UOB dialog form
  • Feature #4113: Set Maybank2E-RC Universal Payment as default file format for payroll, EPF, SOCSO and IRB
  • Fix process payroll prompt "conversion error from string" error if region setting change to Chinese
  • Fix email EA and EC using Ms Outlook 2013 attachment missing due to Return Character
  • Fix bug #4131: Incorrect MTD calculated if MTD for additional remuneration less than RM10 before deduction for zakat
  • Fix bug #4130: Failed to upload Connect BIZ excel file to Hong Leong bank web server due to incorrect format cells
  • Remove RHB salary file format
  • Fix bug #4128: Crediting amount column contains format code (0.00) in RHB smart payroll excel file
  • Feature #4106: Add OCBC bank IRB text file format
  • Add TP1-2016 & TP3-2017 format
  • Fix bug #4137: Income tax CP8D report does not exclude employee record with total gross remuneration equal zero for year 2016
  • Fix bug #4138: Income tax CP8D text file contains record with passport number is blank for foreign worker
  • Fix incorrect header in Affin bank AutoPay excel format
  • Fix bug #4142: Current month additional remuneration show zero when preview PCB calculation even though there is bonus subject to PCB Additional contribution
  • Fix bug #4145: Unable to generate income tax CP8D text file based on grid filter condition
  • Feature #4135: Update Public bank ECP text file format to version 7
  • Add PCB TP1 for 2017 in Maintain Employee & Payslip
  • Feature #4129: Provide user an example of client batch ID if user select Maybank2E-RC Universal Payment file format
  • Feature #4136: Add "Auto claim SOCSO for calculate PCB" option to contribution setting

Previous Update Version 135.124
  • Fix duplicate records in PT_INFO_CHILD table after reset employee payroll
  • Fix bug #4107: Employee paysheet shows incorrect tax category after reset payroll

Sunday, February 19, 2017

SQL Payroll Latest Version (124) Date : 20th Feb 2017



Information

Last updated: 20/02/2017
Current version: 1.2016.135.124

New in this version

  • Fix duplicate records in PT_INFO_CHILD table after reset employee payroll
  • Fix bug #4107: Employee paysheet shows incorrect tax category after reset payroll

Previous Update Version 134.124
  • Fix import company profile from AutoCount payroll backup file prompt access violation error
  • Replace Affin bank EPF excel file format with EPF text file format
  • Replace Affin bank SOCSO excel file format with SOCSO text file format
  • Add support of Affin bank IRB text file format
  • Fix application prompt access violation error when generate RHB bank excel file if there are no records
  • Fix apply income tax EA report for year 2016 prompt access violation error if filter by department
  • Fine tuning Yearly Individual presentation for easy understand
  • Update UOB Interbank Giro Bulk Payment Services file format to version 2.1
  • Fix bug: Application auto append child record for employee even though employee tax category is C1 after import from autocount payroll
  • Fix bug #4099: Incorrect columns position in SOCSO excel file of Hong Leong bank Connect BIZ file format
  • Fix missing record in income tax e-Data Praisi report if employee resigned within the year
  • Feature #4092: Update Public bank ECP excel file to latest file format
  • Income tax e-Data Praisi contains 2 text files (employer and employee section)
  • Fix bug #4093: Gross salary column contains format code in RHB bank EPF excel file format
  • Fix bug #4094: Employee SOCSO number column exclude alphabet characters in RHB bank SOCSO file format
  • Fix bug #4101: Income tax e-Data Praisi report does not exclude employee record with total gross remuneration equal zero
  • Fix CP8D 2016 Column R & S should not be in negative
  • Fix Borang EA & EC Batch Email Subject is empty
  • Replace RHB Reflex excel file format (Salary, EPF and SOCSO) with text file format
  • Adjust calculation for "number of child qualified for tax relief" in income tax EA, EC and CP8D report for year 2016
  • Database upgrade to version 82

Sunday, February 12, 2017

SQL Payroll Latest Version (123) Date: 26th Jan 2017

Information

Last updated: 26/01/2017
Current version: 1.2017.133.123

New in this version

  • Fix bug #4078: Employee New IC number and EPF number as string value in RHB EPF excel file
  • Add "Recalculate EPF, SOCSO and PCB" popup menu item on paysheet form
  • Add support of income tax e-Data Praisi for year 2016

Monday, January 16, 2017

SQL Payroll Latest Version (122) Date: 13th Jan 2017

Information

Last updated: 13/01/2017
Current version: 1.2017.131.122

New in this version

  • Fix open leave entitlement prompt "Duplicate name AL_T in TFieldDefs" error
  • Fix bug #3982: Amount as string value in bank excel file formats
  • Fix bug #3984: Incorrect columns position in KWSP and SOCSO excel file of Hong Leong bank Connect BIZ file format
  • Fix bug #3980: RHB bank IRB text file does not follow file naming convention (LHDN employer number + contribution month_current year)
  • Fix bug #3989: Company register number column contains non-alphanumeric characters for SOCSO file format
  • Rename column caption from PA to PCB (A) for allowance and deduction grid on employee entry form
  • Fill old IC and new IC number columns with employee new IC number if old IC number is empty for CIMB bank zakat file format
  • Fix bug #4029: Incorrect auto EPF rate for employee if process payroll Jan 2017
  • Fix bug #4036: Default post date of pending advance deduct does not follow cut-off day for the payroll month
  • Add color setting to Remark field in Company Profile
  • Fixed PR.Tax.PCB2(II)-2012 still show receipt Receipt & Date even amount is zero
  • Add support of income tax EA, EC and CP8D report for year 2016
  • Add support of payroll calculator for year 2017
  • Feature #3800: Auto append tax deduction (SOCSO) for employee when process payroll
  • Database upgrade to version 80