Company: Link Technologies
Case No: L12282. Project: 12.43: LinkSOFT Version 12.43
Logged By: Rashna (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 16 Jun 2021 12:42PM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 24.00 (Weight: 24.00)
Version: 12.43.0706
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Wednesday, 23 June 2021 11:59 PM [1017 days since logged date]
Status: Closed
Subject: "Leave without pay" (LWOP) hours should be a negative amount in the "Pay Edit Report"
Summary:    
PART A - Issue Details
1. Details
  1. Employee A is paid normal hours with a quantity of 160.
  2. The employee also paid LWOP of 3 hours
  3. The total hours in the "Pay Edit" report show 163. This should be 157
    1. The 3 hours should be reflected as "-3" under "Others Column". 

Note:  The above was built and tested in case L08729

2. Error Message (Include screenshots of error)



3. Environment Details
Server Name: LinkQA4
Database name: Demo-LINKSOFT
Application Hosted on: http://linktechnologies.com.au/DEMO-LinkSOFT
Login User ID/Password: admin/admin
Client Operating System: 
Version: 12.42

4. Relevant History Information

5. The issue can be reproduced by performing the following:
  1. Create pay for employee LTE00001 with Normal Hours 160
  2. Create a Leave Transaction for LWOP with hours 3.
  3. Generate the "Pay Edit Report" to verify results
Setup in company EDGE in database DEMO-LINKSOFT
Audit Notes:Edited by sanjay on 25/06/21 10:02. Edited by sanjay on 18/06/21 17:32. Edited by sanjay on 18/06/21 14:04. Edited by sanjay on 18/06/21 14:04. Edited by rashna on 17/06/21 13:21. Edited by rashna on 17/06/21 13:18. Edited by rashna on 17/06/21 13:17. Edited by rashna on 16/06/21 12:42. Edited by rashna on 16/06/21 12:41. Edited by rashna on 16/06/21 12:39. Edited by rashna on 16/06/21 11:16. Edited by rashna on 16/06/21 11:14. Edited by rashna on 16/06/21 10:46. 
17 Jun 202101:17PM Comment 1 by Rashna (Edge Business Solutions) Case L12282 added to project 12.42
17 Jun 202101:18PM Comment 2 by Rashna (Edge Business Solutions) Case L12282 added to project 12.43
17 Jun 202101:21PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 17-06-2021 07:18 PM Time Taken: 1.00

Hi Sanjay, 

As per the development meeting with Sanjay, Alvis, Sitla, Vineshwar, and Rashna.

  1. Meeting Date: 17/06/2021.
  2. Meeting Time - 1 pm AEST

The following was agreed:

  1. Design a patch for version 12.42

Thanks
Rashna


18 Jun 202109:06AM Comment 4 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 18-06-2021 03:06 PM
Hi Alvis, proceed with the report change.

18 Jun 202103:13PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 18-06-2021 08:04 PM Time Taken: 6.00

This issue needs to be looked at in all reports.

We have reviewed all payroll reports and identified the following:

  1. Identify all reports showing "Leave without Pay (LWOP)" quantity.
    1. LWOP amounts should show as -ve when adding up hours in total columns so that the effective hours paid is correctly shown. 
    2. This needs to be done where the Rate is not shown next to the Quantity

The following reports need to be changed:

  1. Pay Edit Report - YTD
  2. Pay Edit Report
  3. Employee Pay Register
  4. Employee Hours Analysis - This report shows separately and is correct
  5. Employee Payment History
  6. Pay Summary Report - Quantity already shows as negative - This is correct

18 Jun 202103:27PM Comment 6 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 18-06-2021 09:13 PM Time Taken: 16.00
PART A - Development work for this case has been completed.

1. The change will be available in version:12.43.0618

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

  1. Pay Edit Report - YTD: Changed LWOP hours to Negative in the "Other" Column of the report
    1. Renamed "AAL" column to "Annual"
    2. Renamed "ASL" to "Sick"
    3. Renamed report to "Pay Edit Report - Year To Date" 
  2. Pay Edit Report: Changed LWOP hours to Negative in the "Other" Column of the report
    1. Renamed "AAL" column to "Annual"
    2. Renamed "ASL" to "Sick"
  3. Employee Pay Register
    1. All columns where Quantity is shown for LWOP is shown as negative so that the sum of Hours are correct

3. Affected Areas:

  1. Payroll reports

4. The issue was caused by:

  1. Leave Without Pay quantity was incorrectly handled in report displays

5. Notes: This is a significant change. There are several procedures and Reports in this change therefore we will not be able to issue a Patch.
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


18 Jun 202105:32PM Comment 7 by Sanjay (Link Technologies) ETC was changed from 17/06/2021 to 17/06/2021
22 Jun 202111:54AM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 23-06-2021 05:02 PM Time Taken: 1.00 Notes: ETC extended from: 17/06/2021 to 23/06/2021
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1

Setup Pay as below

  1. Employee A is paid normal hours with a quantity of 160.
  2. The employee also paid LWOP of 3 hours
  3. The total hours in the "Pay Edit" report show 163. This should be 157
    1. The 3 hours should be reflected as "-3" under "Others Column". 
Pass
2

Generate the "Pay Edit Report - Year To Date" report. Validate

  1. The column AAL has been renamed to "Annual".
  2. The column ASL has been renamed to "Sick".
  3. LWOPamount of 3 is shown in the other section with a negative value
Pass
3

Generate the "Pay Edit Report" report. Validate

  1. The column AAL has been renamed to "Annual".
  2. ?The column ASL has been renamed to "Sick".
  3. LWOPamount of 3 is shown in the other section with a negative value

Pass
4Generate the "Pay Register" report to verify that the LWOP quantity is -3
Pass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.42.0621 RC1
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-124

Next Step

  1. For Closure

    23 Jun 202104:48PM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 23-06-2021 10:48 PM
    Thanks Rashna

    25 Jun 202110:02AM Comment 10 by Sanjay (Link Technologies) ETC was changed from 23/06/2021 to 23/06/2021
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12282 in the subject line of all emails regarding this issue.

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