Company: Link Technologies
Case No: L09257. Project: 09.40: LinkSOFT Version 9.4
Logged By: Karishma Kartika Devi (Link Fiji) on 18 Apr 2018 03:30PM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 8.50 (Weight: 8.50)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Karishma Kartika Devi, Rashna, Sanjay
Resolve By: Thursday, 19 April 2018 12:00 AM [2172 days since logged date]
Status: Closed
Subject: Incorrect hours are populated on the pay edit screen for AAL leave payout in employee's final pay
Summary:    
1. Problem Details

Upon creation of a special final pay for an employee, the hours populated on the pay edit screen for AAL leave payout are incorrect when compared to the hours in the Pay Settlement report.


2. Error Message (Include screenshot of error)

Figure 1: Pay Edit Screen - Pay Date is 13/04/2018

The hours populated is 17.00 whereas it should be 16.66 as per Pay Settlement report.


Figure 2: Pay Settlement Report - Generated as at 13/04/2018



Figure 3: Employee's Termination Date is 13/04/2018


Figure 4: Leave Allocation



3. Environment Details

Live Environment: Version 933 GA


4. Relevant History Information

The issue can be reproduced by performing the following:
  1. An employee should have the allocation and other balances as per Figure 4 
  2. Enter the termination date of the employee as at 13/04/2018
  3. Set the pay date for the Special pay team to 13/04/2018
  4. Create a normal pay for the employee
  5. Navigate to the Pay Edit screen and verify the hours with the Pay Settlement report
Audit Notes:
18 Apr 201803:47PM Comment 1 by Alvis (Link Technologies) Case 9257 added to project 09.4
19 Apr 201810:44AM Comment 2 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 19-04-2018 10:44 AM Time Taken: 2.00

Hi Karishma,

I have verified the values of the current pay and pay settlement report.

Current pay Annual leave payout of 17 hours is correct. Pay settlement report is missing the Sick leave entry which has resulted in the incorrect calculation of leave accrued.

We will correct the pay settlement report in version 9.4.

regards
Alvis


20 Apr 201809:17AM Comment 3 by Karishma Kartika Devi (Link Fiji) Assigned To: Alvis (Link Technologies) Followup Date: 20-04-2018 12:00 AM Time Taken: 0.50

Hi Alvis

As per Fariha's leave allocation table, the AAL leave balance is 13.33 hours.

The accrual for this month is calculated as follows: 

(80/12) x (80/160) = 3.33 hours

Note: Fariha has worked for 10 days in this month.

Therefore, the total annual leave payout total up to 16.66 and not 17 hours.

Please if you can advise how the system calculated 17 hours?


Regards
Karishma


20 Apr 201810:29AM Comment 4 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 20-04-2018 10:29 AM Time Taken: 1.00

Hi Karishma

The accrual for this month is calculated as follows: 

(Normal Hours 80 + Sick Leave 8/12) x (88/160) = 3.66 hours

Balance = 13.33

Total Leave Payout: 3.66 + 13.33 = 17 hours

regards
Alvis


23 Apr 201804:49PM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-04-2018 04:49 PM Time Taken: 1.00
Hi Karishma,

I had a look at the final pay issue and found that normal hours in the payroll should be 72 hours instead of 80 hours showing.
This is because there is a sick leave entry for 8 hours.

I have corrected this issue in version 9.4

regards
Alvis


02 May 201803:48PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 02-05-2018 03:48 PM Time Taken: 1.00

System test completed.

Verified the following:

  1. Setup a new employee with start date 01/01/2018
  2. Allocated Annual Leave and sick leave entitlements
  3. Created monthly pay for Jan 18
  4. Set the termination date for the employee created in 1. to 15/02/2018
  5. Created sick leave transaction for 08/02/2018 8hours
  6. Created final pay for employee
  7. Verified entries in current pay. - Failed. ANHRS hours was showing as 88 hours instead of 80 hours. Resolved issue in beta2.
Regards
Alvis

09 May 201811:45AM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 09-05-2018 11:45 AM Time Taken: 1.00

System test completed.

Verified the following:

  1. Setup a new employee with start date 01/01/2018
  2. Allocated Annual Leave and sick leave entitlements
  3. Created monthly pay for Jan 18
  4. Set the termination date for the employee created in 1. to 15/02/2018
  5. Created sick leave transaction for 08/02/2018 8hours
  6. Created final pay for employee
  7. Verified entries in current pay. - Pass
Regards
Alvis

16 May 201809:25AM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 17-05-2018 12:00 AM Time Taken: 1.00

Hi Alvis, 

I have tested the case. Review table below for details

Test Environment

  • Version 9400 Beta 2
  • Database -LINKSOFT9257 on QA1
  • Application on QA1
  • OS - Windows 7

Test Plan

  1. Create new employee E070. Start date 01/01/2016.Pay Team MTM.
  2. Allocate AAL - 160 hours , ASL and ABEAV.
  3. Create and update the first pay dated 31/01/2016. Accural should be 13.33 (160/120) - Pass.
  4. Set the Termination date as 17/02/2016.
  5. Generate the Pay Settlement Report. AAL should be 22.83. (13.33) + [(160/12/160)*(114)] - Pass
  6. Create a Sick Leave Entry for "10/02/2017" with 8 hours.
  7. Create pay for 17/02/2016.
  8. AAL of 22.83 should be in the Pay - Failed no entry for AAL is created.
  9. ASL have an entry of 8 hours.
  10. Normal Hours should be 106.  Failed,currently showing 152.
Thanks

Rashna


16 May 201803:40PM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-05-2018 03:40 PM

Hi Rashna,

Have you tested this with the flag "Include Final Pay entries. Creates leave balance payout, leave accrual payout and marks the employee as terminated after pay update." turned on?

regards
Alvis


17 May 201807:15AM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 18-05-2018 12:00 AM Time Taken: 1.00

Hi Sanjay, 

This case has been successfully tested. 

Documentation is not required in the case.

Test Environment

  • Version 9400 Beta 2
  • Database -LINKSOFT9257 on QA1
  • Application on QA1
  • OS - Windows 7

Test Plan

  1. Create new employee E070. Start date 01/01/2016.Pay Team MTM.
  2. Allocate AAL - 160 hours , ASL and ABEAV.
  3. Create and update the first pay dated 31/01/2016. Accural should be 13.33 (160/120) - Pass.
  4. Set the Termination date as 17/02/2016.
  5. Generate the Pay Settlement Report. AAL should be 22.83. (13.33) + [(160/12/160)*(114)] - Pass
  6. Create a Sick Leave Entry for "10/02/2017" with 8 hours.
  7. Create pay for 17/02/2016.
  8. AAL of 22.83 should be in the Pay - Failed no entry for AAL is created.
  9. ASL have an entry of 8 hours.
  10. Normal Hours should be 106.  Failed,currently showing 152.
  11. Hours on the Pay Settlement Report should tie with Pay Edit.

Figure 1: Payment Settlement and Pay Edit.


Thanks

Rashna


17 May 201808:57AM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 17-05-2018 08:57 AM
Thanks Rashna

09 Oct 201908:14AM Comment 12 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L09257 in the subject line of all emails regarding this issue.

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