Company: Link Technologies
Case No: L13017. Project: 15.30: LinkSOFT Version 15.30
Logged By: Sanjay (Link Technologies) on 08 Apr 2024 12:00PM
Priority: Low
Product: Payroll & HR
Group: Enhancement
Time Taken: 18.00 (Weight: 8.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay, Vineet
Resolve By: Saturday, 20 April 2024 10:17 AM [22 days since logged date]
Status: Closed
Subject: Logging to identify Pay Close to assist with Performance (T14194)
Summary:    Add logging when pay is closed as there are some reports (GFI) where the time to close is > 30 minutes
Audit Notes:Edited by sanjay on 08/04/24 12:00. 
08 Apr 202401:48PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 12-04-2024 12:00 PM Time Taken: 5.00 Notes: ETC extended from: 08/04/2024 to 12/04/2024
PART A - Development work for this case has been completed.

1. The change will be available in version: 15.30

2. The following changes were made (Include Database object names, Program classes, and any other relevant information):

  1. Performance tuning on Pay Close process on module "Time"
  2. Added two new indexes:

    1. Time Module on TSID and PayrollFlag

    2. PAY Details on Company, PayRun, Employee and Source

  3. Added Pay Close logging to monitor performance

3. Affected Areas:

  1. Pay Close process

4. The issue was caused by:

  1. Performance Improvement

5. Other Relevant Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


15 Apr 202410:26AM Comment 2 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-04-2024 10:17 AM Time Taken: 2.00 Notes: ETC extended from: 12/04/2024 to 20/04/2024
The following tests were performed:

Test Setup Instructions:
  1. Create a pay for a large number of employees and close pay. This should not take too long. Currently, on the Client database, pay for 700 employees takes over 3 hours.

Table 1 - Test Results

NoTest CaseExpected ResultPass/FailComments
1Create a pay for 700 Employees and update the pay.
Pay should be updated in less than 10 Minutes
Pass
Event Log Payroll Processing - Pay Closed. Payrun: 3892, Company: 1001, Number of Employees: 699 Start: 10-04-24 01:09:10 PM Finish: 10-04-24 01:13:43 PM Duration: 4m 33s [Company: 1001]

Environment Details

  1. OS version: Win11
  2. Application version:
  3. Setup on:
    1. Server: LinkQA4
    2. Database: CLIENT-GFI-LINKSOFT
    3. LinkSOFT URL: http://10.0.0.18/GFI-LINKSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


16 Apr 202412:14PM Comment 3 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 26-04-2024 12:04 PM Time Taken: 2.00

Bula Sanjay

After reviewing the Pay Accruals we have noted that the accruals passed are more than expected. We updated PayRun 3894. Below is the summary of accruals passed with expected accruals that should have been passed.

Server: LinkQA4
Database: CLIENT-GFI-LINKSOFT
LinkSOFT URL: http://10.0.0.18/GFI-LINKSOFT
Login Details: Standard username and password for user "admin"

Figure 1.1 Table Showing the Calculated Accruals and System Accruals Passed for Payrun ID 3984

Employee ID

Leave Type

Entitlement

CalculatedAccruals

SystemAccruals

10499

CWAAL159.0

135

2.596153846

33.75000005

1073

CWAAL209.0

180

3.461538462

6.92307692

10855

CWAAL159.0

135

2.596153846

33.75000005

10908

CWAAL159.0

135

2.596153846

33.75000005

15287

CWAAL159.0

135

2.596153846

33.75000005

20167

CWAAL158.0

120

2.307692308

27.69230772

20652

CWAAL159.0

135

2.596153846

31.1538462

20698

CWAAL159.0

135

2.596153846

31.1538462

3103

CWAAL159.0

135

2.596153846

33.75000005

3170

TWAAL158.0

120

2.307692308

30.00000003

4015

CWAAL209.0

180

3.461538462

27.69230768

40314

CWAAL158.8

132

2.538461538

30.46153848

40341

CWAAL158.8

132

2.538461538

30.46153848

40343

CWAAL158.8

132

2.538461538

30.46153848

40347

CWAAL158.8

132

2.538461538

30.46153848

40350

CWAAL158.8

132

2.538461538

30.46153848

4074

CWAAL209.0

180

3.461538462

17.3076923

4076

CWAAL209.0

180

3.461538462

17.3076923

4093

CWAAL209.0

180

3.461538462

20.76923076

4094

CWAAL209.0

180

3.461538462

20.76923076

4100

CWAAL209.0

180

3.461538462

24.23076922

4113

CWAAL209.0

180

3.461538462

20.76923076

4114

CWAAL209.0

180

3.461538462

20.76923076

4115

CWAAL209.0

180

3.461538462

17.3076923

4122

CWAAL209.0

180

3.461538462

17.3076923

4123

CWAAL209.0

180

3.461538462

17.3076923

4126

CWAAL209.0

180

3.461538462

17.3076923

4131

CWAAL209.0

180

3.461538462

17.3076923

4135

CWAAL209.0

180

3.461538462

17.3076923

Thanks
Vineet Ram

 


16 Apr 202403:41PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 26-04-2024 02:11 PM Time Taken: 6.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 15.30 and 15.20 Patch

2. The following changes were made (Include Database object names, Program classes, and any other relevant information):

  1. Corrected Leave Accrual changes made in the previous patch

3. Affected Areas:

  1. Pay Close Process

4. The issue was caused by:

  1. Programming error - Leave accrual procedure was called multiple times (based on the number of years of service)

5. Other Relevant Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): Vineet, please verify GFI DB. I will complete testing tomorrow and release a patch by COB tomorrow.


17 Apr 202403:06PM Comment 5 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 26-04-2024 02:51 PM Time Taken: 2.00
The following tests were performed:

Test Setup Instructions:
  1. Created Pay for 699 Employees and reviewed leave accruals, leave taken, and pay update duration.
  2. Created a pay for 2 employees and tested the Leave Rollover Process.
Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Created Payrun 3893 and 3894 for 699 employees. Verified the Leave Accruals and Leave Transaction Taken figures after the update

Pay update should take less than 2 minutes

Leave Accruals should match the expected results

Pass

Pay was updated in less than 1 minute.

System Leave Accruals and Taken matched the Calculated Leave Accruals and Taken

2Created Payrun 3895 and 3896 for Leave Rollover Tests
Leave Rolled over over with correct BalancesPass
Leave Rolled over with correct balance 

Environment Details

  1. OS version: Win11
  2. Application version:
  3. Setup on:
    1. Server: LinkQA4
      Database: CLIENT-GFI-LINKSOFT
      LinkSOFT URL: http://10.0.0.18/GFI-LINKSOFT
      Login Details: Standard username and password for user "admin"

Next Step: Closure


19 Apr 202410:14AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 26-04-2024 10:13 AM Time Taken: 1.00
Thanks Vineet, Patch has been released.

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

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