Company: Link Technologies
Case No: L13106. Project: 15.70: LinkSOFT Version 15.70
Logged By: Sitla (Edge Business Solutions) on 04 Feb 2025 09:26AM
Priority: Low
Product: Payroll & HR
Group: Support
Time Taken: 29.00 (Weight: 18.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay, Sitla, Vineshwar Prasad
Resolve By: Wednesday, 30 April 2025 09:26 AM [39 days since logged date]
Status: Resolved
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
  1. URL: https://www.linktechnologies.com.au/LinkSOFT-XXX
  2. Company: 56
  3. 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 202503:16PM Comment 1 by Sanjay (Link Technologies) ETC was changed from 04/02/2025 to 30/04/2025
05 Mar 202509: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 202508:40AM Comment 3 by Sitla (Edge Business Solutions) This comment has been removed
10 Mar 202504: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):

  1. When calculating Leave Balance, we now Exclude any Leave that has been VOIDED

3. Affected Areas:

  1. Leave Balance Calculations showing on the Leave Allocation Screen, as well as Leave Liability Reports

4. The issue was caused by:

  1. Not excluding VOIDED leave in Liability Calculations.
  2. 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 202504:32PM Comment 5 by Sanjay (Link Technologies) Case L13106 added to project 15.70
11 Mar 202504: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:

  1. Mark all transactions as VOID where there isn't a VALID leave allocation
  2. Rebuild CURRENT YEAR (based on calendar) Leave Allocation Accrual Amounts based on Accrual History.

Testing completed on REDDY GROUP and JACKS Databases.


11 Mar 202504: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 202512: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 202503: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 202504: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.


If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L13106 in the subject line of all emails regarding this issue.

Document size: 573.6 KB
For call complaints, please contact the Managing Director of the company using this form