VERSION 2.3294 2025/11/05
1) CIMB STATUTORY DOWNLOAD AND EPF LISTING, Bug Fixed to change epf_employee >0 to epf_employee + epf_employer > 0


VERSION 2.3293 2025/09/25
1) CHECKHTTPLICENSE AND CHECKHTTPLICENSEUUID DIRECT TO GGSB.DYNDNS.ORG

VERSION 2.3291 2025/06/25
1) Adhoc Cimb Auto Pay (Adhoc) for create payroll export file for month 202506, used manualpay202506 table as reference for pay, amount is manualpay202506-> dianacheckedamount

VERSION 2.3290 2025/06/01
1) Bug fixed Allowance on 8th columns above, mistake calculate added 7th + 8th + 8th instead of 7th + 8th + 9th 

VERSION 2.3289 2025/06/01
1) Updated Bonus Module, in the event if the bonus is calculated via bonus module instead of entering directly into payslip

VERSION 2.3287 2025/05/15
1) Bug fix during creation of new employee, when navigating to other column tries to add audit log with no previous data to refer to causes eof error, reported by diana fima 2025/05/14

VERSION 2.32387 2025/05/02
1) Edit Employee, fixed error when edit employee. changed emp_gender_id to emp_gender (bug)
   Issue raised by Diana 2025/05/02

VERSION 2.32386 2025/04/16
1) Enhanced Security Login, added User Lockout after 3 unsucessful password attempt, use will be locked for 15 minute
2) Added Unlock Locked Out User In Xenix Web, To unlock locked user, goto Management-Users, there will be a link to unlock locked-out user

VERSION 2.32385 2025/02/26
1) Employee Details report added allow to show active or all staff
2) add audit log emp entry

VERSION 2.32384 2025/02/26
1) Enhance user security
2) Xenix Web User security and audig log feature added

VERSION 2.32383 2025/02/26
1) Add Salary Tally Checking Report to check pay is tally or not
2) Add Checking mechanism to ensure not allow to save if working netpay is not tally with netpay column in payslip entry

VERSION 2.32381 2025/02/26
1) cp159 crete bug fix -> pcb eligible = pay_basic_salary + pay_incometax_deduction_amount

VERSION 2.32381 2025/02/25
1) added comp_ea_worksheet_folder
2) Edit EA Form, allow view of worksheet
3) company info setup, ea worksheet folder setup
4) grosspay = basic + ot - att + allow + deduct

VERSION 2.32380 2025/02/19
1) EMP PAYSLIP ENTRY, ADD UPDATEOTAMOUNT IN EARNING TOTALCHANGE
   ADD CHANGE EVENT BASIC RATE COLUMN COPY CHANGE EVENT BASIC SALARY
   UPDATE LCLSPAY.BASICRATE WHEN BASIC RATE OR BASIC SALARY COLUMN CHANGE   
   UPDATE LCLSPAY.BASICSALARY WHEN BASIC RATE OR BASIC SALARY COLUMN CHANGE
   IF NEED TO MANUAL EDIT BASIC RATE AND WISH TO UPDATE THE OT
   - FIRST NEED TO UPDATE THE BASIC SALARY IN EMPLOYEE PAYROLL INFO SETUP
   - THEN IN THE EMP PAYSLIP ENTRY, ENTER THE BASIC RATE AND BASIC SALARY COLUNM


VERSION 2.32379 2025/02/03
1) DEFAULTED EMP_ABSENT_DEDUCTION_ENABLED AND EMP_INCOMPLETE_DEDUCTION_ENABLED TO 0 WHEN CREATING NEW EMPLOYEE
2) ADD LOG_APP_VERSION IN AUDIT_LOG TABLE

VERSION 2.32378 2025/01/14
1) SHOW ERROR IF STAFF NOT YET JOIN WHEN CREATE PAYSLIP FOR NEW STAFF, FOR BATCH PROCESS IGNORE THE CREATE PAYSLIP SKIP TO NEXT EMP

VERSION 2.32377 2024/08/14
1) ADDED DEDUCTION FOR UNPAY ABSENT AND INCOMPLETE TO OPTION BY PAYROLL DAYS OR NUMBER OF DAYS IN THE PAYROLL MONTH

VERSION 2.32376 2024/08/13
1) ADDED AUTO DETECT SHIFT

FIMA, INSULFLEX,THI, MSM, MUAZIQ
VERSION 2.32375 2024/07/23
1) add CP22, CP22A, CP21
2) added TP1, TP3
3) Added Audit Log for Accessing Every Menu Items, Time Card Entry, Edit Emp Payslip
4) Print Audit Log at Tools Report->Audit Log Report
5) Added Employee Status emp_deceased


VERSION 2.32374 2024/06/21
1) add 2 reports
   Work More than 12 hours a day 
   OT more than 104 hours 

VERSION 2.32374 2024/05/31
1) ADD LOGIN PASSWORD POLICY

VERSION 2.32372 2024/04/19
1) Added TA.EMPJOBCATEGORYID AND TA.EMPJOBGRADEID IN TA class

VERSION 2.32372 2024/03/27
1) update after export to different drive error cannot open sql server appear

VERSION 2.32369 2024/03/27
1) updated cp8d 2023

VERSION 2.32369 2024/03/07
1) Rectified payslip entry when delete deduction by pressing delete key on deduction column error appears

VERSION 2.32368 2024/03/01
1) EA Form Export, Email and E-EaForm

VERSION 2.32367 2024/02/21
1) Payslip Entry, rectified ot disappeared after enter of allowance 
2) Enhance Tracelog for EA creation, user can check EaLOGyyyymmdd.txt for how EA is calculated


VERSION 2.32366 2024/01/12
1) Payslip will load total amount in table instead of recalculate everytime when edit emp payslip, this
   is to avoid non-tally when system first load, previously if there is any changes to allowance
   or deduction or salary or ot it will recalculate and showed result differ from what is on the table.

VERSION 2.32365 2023/12/26
1) Fixed Division by Zero (remove calculateMTD)

VERSION 2.32364 2023/09/27
1) Export payslip 6 export consist of multiple payslip issue solved
2) Payslip6rpt.rpt updated


VERSION 2.32362
1) Edit Employee PAYSLIP Deduction runtime error rectification
2) remarked CalculateMTD function in processpayroll, this process will do more precise calculation however there are some glitches, will deal with it later day


VERSION 2.32361
1) KWSP BORANG 8A, LIST INCLUDE SOCSO + SIP AMOUNT > 0 
2) EMP Entry, removed the load photo, and optimized the select statement for data combo

VERSION 2.32360
1) EXPORT PAYSLIP, COLUMN NOT MATCH WITH PRINT PAYSLIP, REMOVED PAY_PASSPORT_NO

VERSION 2.32360 2023/08/01
1) Employee offday setup, correct error for duplicate offdays in same day
2) CREATEPAYTEMP FUNCTION RECTIFICATION DUE TO NEW COLUMN ADDED
3) PROCESSTIMEATTENDANCEWEBNEW for new calculation of attendance

VERSION 2.32359 2023/07/27
1) change in payslip entry during form activate event, change for overtime show after allowance load, 
   there is a problem with customer, enter ot directly into amount column, when allowance load it will 
   auto refresh ot amount.
2) during form activate, will not recalculate because we set lfirstload to true and if not lfirstload, 
   when amount triggers refresh, it will first check if not lfirstload
   

VERSION 2.32358 2023/07/11
1) Socso Borang 8A Diskette download added Socso + SIP option
2) MTD CALCULATION
3) TP3 ENTRY
4) BONUS MODULE INCLUDES ACCUMULATED 
5) PAYSLIP ADDED AMT ELIGIBLE FOR BETTER UNDERSTANDING WHICH AMOUNT IS ELIGIBLE FOR DEDUCTION

VERSION 2.32357 2023/05/22
1) Added Email payslip export (1st half)

VERSION 2.32355 2023/03/30
1) added Borang e-E Report, which you can select as an checkbox option in create CP8D module under payroll report section
2) in cp8d report and export, the column m was ea_ip_kasar but it was wrong and replaced with ea_elaun_dikecualikan_cukai

VERSION 2.32354 2023/03/28
1) PROCESS EA, the ea_jumlah_pelepasan_anak will be updated based on ea_bilangan_anak_dibawah_18 * 2000
2) set ea_cukai_pendapatan = 2 (was 0)
3) uPDATE CP8D report format complying 2022 
4) in cp8d report and export, the column m was ea_ip_kasar but it was wrong and replaced with ea_elaun_dikecualikan_cukai
5) the column f alsao wrong, cukai ditanggungkan oleh majikan (if 0 then 1 else 2) should be 2 by default 


VERSION 2.32353 2023/02/25
1) FIXED CREATE CP159 ISSUE UNDER PAYROLL TAB, HAPPENS WHEN HAVE EMPLOYEE TRANSFER BETWEEN SUBSIDIARY AND THE
   TOTAL NOT TALLY, ORIGINAL USE EMP AS LOOP, WE CHANGED TO USE PAY TABLE AS LOOP


VERSION 2.32348 2023/02/25
1) FIXED OT Not refresh after allowance involved included in ot calculation, added UpdateOTAmount after AllowanceTotalChanged is Called 

CHANGE UR OT10, OT15, OT20, OT30 in formula to take effect
0T10 -> ROUND((PAY.LOT10HOUR * 1.0 * (PAY.LBASICSALARY + PAY.LALLOWANCEFOROTCALCULATION) / PAY.GCOMPPAYROLLDAYS / PAY.GCOMPPAYROLLHOURS) + (PAY.LOT10MINUTE * 1.0 * (PAY.LBASICSALARY + PAY.LALLOWANCEFOROTCALCULATION) / PAY.GCOMPPAYROLLDAYS / PAY.GCOMPPAYROLLHOURS / 60),2)
OT15 -> ROUND((PAY.LOT15HOUR * 1.5 * (PAY.LBASICSALARY + PAY.LALLOWANCEFOROTCALCULATION) / PAY.GCOMPPAYROLLDAYS / PAY.GCOMPPAYROLLHOURS) + (PAY.LOT15MINUTE * 1.5 * (PAY.LBASICSALARY + PAY.LALLOWANCEFOROTCALCULATION) / PAY.GCOMPPAYROLLDAYS / PAY.GCOMPPAYROLLHOURS / 60),2)
OT20 -> ROUND((PAY.LOT20HOUR * 2.0 * (PAY.LBASICSALARY + PAY.LALLOWANCEFOROTCALCULATION) / PAY.GCOMPPAYROLLDAYS / PAY.GCOMPPAYROLLHOURS) + (PAY.LOT20MINUTE * 2.0 * (PAY.LBASICSALARY + PAY.LALLOWANCEFOROTCALCULATION) / PAY.GCOMPPAYROLLDAYS / PAY.GCOMPPAYROLLHOURS / 60),2)
OT30 -> ROUND((PAY.LOT30HOUR * 3.0 * (PAY.LBASICSALARY + PAY.LALLOWANCEFOROTCALCULATION) / PAY.GCOMPPAYROLLDAYS / PAY.GCOMPPAYROLLHOURS) + (PAY.LOT30MINUTE * 3.0 * (PAY.LBASICSALARY + PAY.LALLOWANCEFOROTCALCULATION) / PAY.GCOMPPAYROLLDAYS / PAY.GCOMPPAYROLLHOURS / 60),2)

VERSION 2.32347 2022/11/15
1) Enhancement on Email Payslip, include selection criteria and staff level
2) update payslirpt4 using arial western instead of courier new western cause numbering will be truncated of right hand side.
3) Added syncdata with remote server
4) Payslip Entry and allowance, deduction type setup show code + name instead of just name only on datacombo
5) the hrenabled tab bug fix, for checkweblicense the hr tab not showing but based on xenix.ini


VERSION 2.32346 2022/10/20
1) Encrypted payslip options available
2) DBMv32210132.SQL (CRETE PAYSLIP TABLE, ADD PAYSLIPS IN WEB MENU)
3) Post Payslip to Web


VERSION 2.32345 2022/08/04
1) Fixed Employee attendance Check Report Format mis-aligned

VERSION 2.32344 2022/02/07
1) kwsp borang a diskette download, rectification for bonus, include bonus epf employer which for some above 60 years old employee
   where epf employee no more contribute but employer contribution remains.

VERSION 2.32343 2022/0112
1) CP 8A UPDATED PIN2021 ADD DERMA COLUMN

VERSION 2.32342 2021/09/09
1) Attendance Checklist Report revised 
2) Paylisting to split socso and pcb

VERSION 2.32341 2021/09/02
1) Incometax CP8d REPORT, to include all employees instead of eligible employees

VERSION 2.32340 2021/07/27
1) Update the import from 3rd party setup from f12w, change the card number length to 10 digit when importing, originally 9 digits

VERSION 2.32339 2021/04/02
1) ADD PBB AutopaY
2) Add PBB Statutory Download
3) DBVERSION 31210128 - create 2 menu items in menu tables


VERSION 2.32338 2021/02/17
1) update create cp8d report, remove header for submission for year 2020 and above

VERSION 2.32337 2021/02/17
1) cimb zakat issues rectifiec
2) Create EA Form issues rectified (solved non taxable allowance not exist will trigger error invalid use of null)

VERSION 2.32336
1)CIMB ZAKAT, FILL OLD IC WITH NEW IC NUMBER IN THE EVENT IF OLD IC NUMBER IS ZERO, CANNOT DO AT ENTRY CAUSE OLD IC NUMBER COLUMN SIZE IS SMALLER THAN NEW IC NUMBER


version 2.32335
1) change the max length for group time table -> create new time table name to max length 20 prevent truncate
2) rectify the last out and ot out inconsistency, last out and ot out now has set to same


version 2.32334
1) Add zakat no in company table
2) Add Zakat no in branch table
3) cimb zakat download module
MIGRATION DBVERSION DBMV31210127


version 2.349
new features added
1) Allow enable/disable calculation of OT in batch payroll process
2) Allow enable/disable calculation of EPF/SOCSO/PCB in batch payroll process

Bug Fixed
1) Runtime Error when enter on prorated date columns


version 2.347
new features added
1) Auto backup to different filename
2) Overtime 1,1.5,2&3 total minute recalculation formula defined

version 2.346
Bug Fixed
1) During Holiday or offday or onleave, whenever we overwrite time card, instead of total
   hour and minute going to OT, it went to Normal Hours.
   Solutions: Rectified. 

version 2.343
new features added
1) ot 1.0 formula added


Bug Fixed
1) payroll total worked days vs unpay leaves / pay leaves figures not tally
   solutions : Fixed.
2) ot 1st and 2nd session minus minute problem
   solutions : Fixed

version 2.342
new features added
1) basic salary formula added
2) basic salary daily formula added
3) basic salary half daily formula added
4) basic salary hourly formula added
5) basic salary per minute formula added

version 2.325
new features added
1) formula setting for overtime 1.5, 2.0, and 3.0

version 2.322
new features added
1) pro version only, individual dayset setting


Version 2.319  (Date 2003/08/13)

Bug Fixed
Problem
1) end cut off day for today taking cut off time of today instead of next day
   Solutions : Fixed. 

New Features Added
1) Multiple Overtime Rate for One day

2) Outstation Feature, for employee who is out for duty, just apply for outstation duty  under leave module

3) New parameter LIEODAYS has been added, indicates the number of days where employee late in/earlyout or lunch late in/earlyout