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: - An employee should have the allocation and other balances as per Figure 4
- Enter the termination date of the employee as at 13/04/2018
- Set the pay date for the Special pay team to 13/04/2018
- Create a normal pay for the employee
- Navigate to the Pay Edit screen and verify the hours with the Pay Settlement report
|
Audit Notes: | |
18 Apr 2018 | 03:47PM Comment 1 by Alvis (Link Technologies) Case 9257 added to project 09.4 |
19 Apr 2018 | 10: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 2018 | 09: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 2018 | 10: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 2018 | 04: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 2018 | 03: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: - Setup a new employee with start date 01/01/2018
- Allocated Annual Leave and sick leave entitlements
- Created monthly pay for Jan 18
- Set the termination date for the employee created in 1. to 15/02/2018
- Created sick leave transaction for 08/02/2018 8hours
- Created final pay for employee
- 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 2018 | 11: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: - Setup a new employee with start date 01/01/2018
- Allocated Annual Leave and sick leave entitlements
- Created monthly pay for Jan 18
- Set the termination date for the employee created in 1. to 15/02/2018
- Created sick leave transaction for 08/02/2018 8hours
- Created final pay for employee
- Verified entries in current pay. - Pass
Regards Alvis |
|
16 May 2018 | 09: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 - Create new employee E070. Start date 01/01/2016.Pay Team MTM.
- Allocate AAL - 160 hours , ASL and ABEAV.
- Create and update the first pay dated 31/01/2016. Accural should be 13.33 (160/120) - Pass.
- Set the Termination date as 17/02/2016.
- Generate the Pay Settlement Report. AAL should be 22.83. (13.33) + [(160/12/160)*(114)] - Pass
- Create a Sick Leave Entry for "10/02/2017" with 8 hours.
- Create pay for 17/02/2016.
- AAL of 22.83 should be in the Pay - Failed no entry for AAL is created.
- ASL have an entry of 8 hours.
- Normal Hours should be 106. Failed,currently showing 152.
Thanks Rashna |
|
16 May 2018 | 03: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 2018 | 07: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 - Create new employee E070. Start date 01/01/2016.Pay Team MTM.
- Allocate AAL - 160 hours , ASL and ABEAV.
- Create and update the first pay dated 31/01/2016. Accural should be 13.33 (160/120) - Pass.
- Set the Termination date as 17/02/2016.
- Generate the Pay Settlement Report. AAL should be 22.83. (13.33) + [(160/12/160)*(114)] - Pass
- Create a Sick Leave Entry for "10/02/2017" with 8 hours.
- Create pay for 17/02/2016.
- AAL of 22.83 should be in the Pay - Failed no entry for AAL is created.
- ASL have an entry of 8 hours.
- Normal Hours should be 106. Failed,currently showing 152.
- Hours on the Pay Settlement Report should tie with Pay Edit.
Figure 1: Payment Settlement and Pay Edit.
Thanks Rashna |
|
17 May 2018 | 08:57AM Comment 11 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 17-05-2018 08:57 AM |
| Thanks Rashna |
|
09 Oct 2019 | 08: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 |