Subject: | Leave Allocation screen does not match with the Leave Liability Report |
Summary: | 1. Problem Details - Jacks Retail
Leave Allocation screen does not match with the Leave Liability Report for many Employees. Below is an example for 0309. Pays have been processed therefore the Liability Report is also generated till 26/01/2025.
2. Error Message (screenshot of the error) Image 1: Leave Allocation Image 2: Leave Liability
 3. Environment Details - URL: https://www.linktechnologies.com.au/LinkSOFT-XXX
- Company: 56
- Version - 15.51.250130.GA
|
Audit Notes: | Edited by sanjay on 10/03/25 16:32. Edited by sanjay on 10/03/25 16:26. Edited by sanjay on 05/03/25 09:38. Edited by sanjay on 03/03/25 15:16. Edited by sanjay on 18/02/25 10:43. |
03 Mar 2025 | 03:16PM Comment 1 by Sanjay (Link Technologies) ETC was changed from 04/02/2025 to 30/04/2025 |
05 Mar 2025 | 09:40AM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 30-06-2025 09:38 AM Time Taken: 2.00 |
| Hi Sitla, Please update this case based on Helpdesk Guidelines for Software Defect. I have changed this to support until the issue can be reproduced in DEMO. Helpdesk Guidelines has procedure on how to report issues that cannot be reproduced. |
|
07 Mar 2025 | 08:40AM Comment 3 by Sitla (Edge Business Solutions) This comment has been removed |
10 Mar 2025 | 04:31PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-03-2025 04:29 PM Time Taken: 16.00 Notes: Edited by sanjay on 12/03/25 10:57. |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 15.70, 15.51.250310 and 15.60.250310 2. The following changes were made (Include Database object names, Program classes, and any other relevant information): - When calculating Leave Balance, we now Exclude any Leave that has been VOIDED
3. Affected Areas: - Leave Balance Calculations showing on the Leave Allocation Screen, as well as Leave Liability Reports
4. The issue was caused by: - Not excluding VOIDED leave in Liability Calculations.
- There are lots of "Orphan Records" in some client's database. e.g. Reddy Group, someone has corrected "Leave Allocations" using SQL Scripts but not updated the relevant transaction data. We know this because this issue cannot be reproduced using the LinkSOFT application forms.
5. Other Relevant Notes: 6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
10 Mar 2025 | 04:32PM Comment 5 by Sanjay (Link Technologies) Case L13106 added to project 15.70 |
11 Mar 2025 | 04:00PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 14-03-2025 03:57 PM Time Taken: 5.00 Notes: Edited by sanjay on 12/03/25 12:19. Edited by sanjay on 11/03/25 16:04. |
| Data Correction script is available at this link. This script will do the following: - Mark all transactions as VOID where there isn't a VALID leave allocation
- Rebuild CURRENT YEAR (based on calendar) Leave Allocation Accrual Amounts based on Accrual History.
Testing completed on REDDY GROUP and JACKS Databases. |
|
11 Mar 2025 | 04:35PM Comment 7 by Sitla (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 14-03-2025 04:33 PM |
| Hi Sanjay, Both clients will be verifying data to day and tomorrow and give go ahead to apply to production.
I will await their confirmation. Sitla. |
|
12 Mar 2025 | 12:44PM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 20-03-2025 12:06 PM Time Taken: 4.00 |
| Hi Sitla, For the DATA Correction, I have updated the script to "VOID" instead of DELETE. Just in case we need to access this transactions later on during audit. Please use the updated script in production. Data Correction script is available at this link.
|
|
12 Mar 2025 | 03:59PM Comment 9 by Sitla (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-03-2025 03:49 PM |
| Hi Sanjay, SL and BL rollover transactions are showing in the new allocation. 31.12.2024 transactions in 2025 Example of employee ID's: 09760, 09733 -refer to the below attachments.
Figure 1 - BL for 09760 Figure 2 - SL for 09733 
|
|
13 Mar 2025 | 04:02PM Comment 10 by Sitla (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-03-2025 03:52 PM Time Taken: 2.00 |
| Hi Sanjay, After applying the updated recent patch, on the Reddy Group and the Jacks training environment. We can confirm that the data flow is reflecting correctly in the liability reports as well as payslips. Appreciate if the same can be applied on Jack's Production. Client has asked for a backup before the application. Thank you very much for all the effort.
Sitla. |
|