Subject: | Leave Liability Report does not match Leave Allocation for employees |
Summary: | The Leave Liability Report uses transactions to sum up the Leave Hours, which does not match with what is shown on the Leave Allocation screen. An example from the standard DEMO environment is shown below:
Figure 1 - Leave Allocation Screen

Figure 2 - Leave Liability Report

|
Audit Notes: | Edited by sanjay on 25/03/25 14:25. Edited by sanjay on 18/03/25 15:24. Edited by sanjay on 18/03/25 15:24. |
19 Mar 2025 | 07:13AM Comment 1 by Sitla (Edge Business Solutions) This comment has been removed |
19 Mar 2025 | 08:00AM Comment 2 by Sitla (Edge Business Solutions) This comment has been removed |
22 Mar 2025 | 04:23PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 24-03-2025 10:19 PM Time Taken: 26.00 Notes: ETC extended from: 21/03/2025 to 24/03/2025 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 15.70 and 15.60.250322 2. The following changes were made (Include Database object names, Program classes, and any other relevant information): - Corrected Anniversary Leave Rollover to correctly adjust Rollover amount to next Year
- Added validation so Leave Codes cannot be changed once they are used in transactions
- Improved Narration on Leave Transactions so we can clearly see the Allocations, Entitlements, Brought Forwards and Accruals
3. Affected Areas: - Leave Processing
4. The issue was caused by: - Changes to Leave Codes after it has been used in pay processing is causing the leave amount to incorrectly reflect in the Leave Liability report
5. Other Relevant Notes: 6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT |
|
23 Mar 2025 | 10:09AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 24-03-2025 04:06 PM Time Taken: 16.00 Notes: Edited by sanjay on 23/03/25 10:10. |
| Made the following changes in version 15.60.230323 - Allow Leave Adjustments in prior periods so we can clear old Leave Balances
- Show "Allocation", "Brought Forward", "Accrual" and "Taken" columns in the "Leave Allocation History Transactions" view. Menu: "Leave Management ~> Leave Allocation" Expand to "Leave Allocation History".
|
|
24 Mar 2025 | 07:06PM Comment 5 by Sitla (Edge Business Solutions) This comment has been removed |
25 Mar 2025 | 02:22PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-03-2025 08:17 PM Time Taken: 24.00 |
| 1. The change will be available in version: 15.61 and 15.60.250325 2. The following changes were made (Include Database object names, Program classes, and any other relevant information): - Cannot close a PERIOD if there are Pay Teams that have the "Next Pay date" before "Period End Date". This is to prevent Accidental Period Close.
- We do not allow you to change the "Pay Control" to a closed period. This is the case of Leave Accrual Issues as the period is closed.
- Grade Leave can be activated in Months instead of Years. to Activate in Months, set "Min Service Years" to N/12, where "N" is the number of months. i.e. 6 months = 6/12 = 0.5.
3. Affected Areas: - Leave Allocation, Period Close, Pay Control Update.
4. The issue was caused by: - Improvement and Bug Fixes
5. Other Relevant Notes: 6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
25 Mar 2025 | 02:25PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-03-2025 08:22 PM Time Taken: 18.00 |
| UAT performed by Sanjay and Sitla. The following tests were performed: - Process multiple payments with Anniversary and Calendar types over multiple years and verify Accruals, Roll-over, Balance Calculations and verify with Leave Liability Report.
- Check EDIT function on Leave Codes that have been allocated to employees
- Check Period Close function where there are "Pay Teams" that have not been completed
- Check Pay Control update to Closed Period
Testing Environment: LinkSOFT-DEMO-EDGE |
|
31 Mar 2025 | 10:42AM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 31-03-2025 04:34 PM Time Taken: 48.00 |
| A utility has been built to correct Leave Data. Below is the description of this utility. Please contact Link Support if you need details on how to use this utility: - Zero VOID Leave:
- If a Leave is marked as VOID, the Utility checks to see if the transaction History match the Leave allocation summary.
- If there is a mismatch, an entry is passed to "zero" the summary
- This results in all VOID Leave having Zero sum
- Leave Allocation Rebuild:
- If there are any leave entries in the incorrect period, the leave entry is moved
- The summary value for "Brought Forward" is calculated using history
- The summary values for "Accrued" and "Taken" is recalculated and updated
To use this patch, you must be on version 15.61.250331 or later. Before using this script, please apply to training environment and get USER SIGNOFF Please NOTE: This script will change Leave allocation amounts and will not send integration entries. Figure 1 -- Execute Statement -- DECLARE @UserID UNIQUEIDENTIFIER SELECT @UserID = ID FROM LT_SYS_User_vw WHERE UserName = 'admin' EXEC LT_HRM_UTILITY_LeaveAllocationZero_VoidLeave_Company_All @UserID = @UserID EXEC LT_HRM_UTILITY_LeaveAllocationReBuild_Company_All @UserID = @UserID |
|