| Subject: | Incorrect Calculation of Normal Hours |
| Summary: | Hi Team, New World staff called and advised that there is an incorrect calculation of normal hours. Staff signed in at 8.00 and out on 1.06pm on a saturday. System should call calculate normal hours as 5, but it calculated hours as 4.90. Note: The following time sheet rules were enabled:- - Create all time entries as approved
- Deduct minimum 1 hour break within shift duration
Client DB with issue is in QA4 - CLIENT-NEWWRL-LINSOFT
Example - On 28th Oct,2017 Hardik signed in at 8am & signed out at 1.06pm but normal hours picked is 4.90hrs instead of 5hrs .
|
| Audit Notes: | |
| 14 Nov 2017 | 07:27AM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 17-11-2017 12:00 AM Time Taken: 1.00 |
| Hi Alvis,
I have replicated the case in QA1 with database LINKSOFT-CASE8909.
- Employee - E1001.
- Date - 11/11/2017.
- Login with username Alvis and password 12.
When the rule "Deduct minimum 1 hour break within shift duration" was enabled, system deducted 0.1 hours from normal hours. As per the client on employees work on saturdays from 8am and to 5pm where standard 5 hours will be the normal hours |
|
| 14 Nov 2017 | 08:31AM Comment 2 by Alvis (Link Technologies) Case 8909 added to project 8.19B |
| 14 Nov 2017 | 09:59AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 14-11-2017 09:59 AM Time Taken: 1.00 |
| Hi Rashna, in this example, the normal hours is 4.9 and time and half is 0.1 This is because the process deducts the hours in the order "Normal Hours" -> "Time Half" -> "Double" -> "Holiday" Can you discuss this with your team if you need to change the logic as you need to consider all possible scenarios? regards
Alvis
|
|
| 14 Nov 2017 | 09:59AM Comment 4 by Alvis (Link Technologies) Case 8909 removed from project 8.20 |
| 17 Nov 2017 | 10:50AM Comment 5 by Alvis (Link Technologies) Case 8909 added to project 8.19 |
| 17 Nov 2017 | 03:46PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 17-11-2017 03:46 PM Time Taken: 2.00 |
| We have added the following rule which should give you the results that you expect. Please discuss with the client and let us know. If BreakToDeduct > 0 and < 1 we deduct the break hours from double time, time half, normal, holiday otherwise, we deduct from normal, time half, double, holiday
|
|
| 18 Nov 2017 | 10:20AM Comment 7 by Sanjeet (Link Business Solutions) Case 8909 removed from project 8.19 |
| 22 Nov 2017 | 03:02PM Comment 8 by Alvis (Link Technologies) Case 8909 added to project 8.19 |
| 23 Nov 2017 | 11:04AM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 23-11-2017 11:04 AM Time Taken: 1.00 |
| Hi Alvis and Sanjay, As per the discussion with Sanjeet and Vinesh. Comment 6 is not a requirement from the client. Their requirements will be discussed in the development meeting tomorrow. Hence, there will be no changes in design with what we had in version 818. Regards
Rashna |
|
| 23 Nov 2017 | 01:56PM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 23-11-2017 01:56 PM Time Taken: 1.00 |
| Tested case in QA1 with database LINKSOFT. Tested version 816 Beta 5 Employee Shift - DS - 8am to 5p No Breaks - See Shift Configuration Table 1 - Summarised list of issues | No | Issue Description | Resolved? | | 1 | Employee works from 8am to 1pm on a Saturday. Normal hours should be 5 | Pass | | 2 | Employee works from 8am to 5.06pm on a Friday. Normal hours should be 8 and time and half as 0.1 | Failed- Normal hours was calculated as 7. See Date 03/11/2017 in Figure 1 | | 3 | Employee works from 8am to 5.06pm on a Saturday. Normal hours should be 5 and time and half as 3 | Failed- Normal hours was calculated as 4. See Date 03/11/2017 in Figure 1 |
Figure 1: 
|
|
| 24 Nov 2017 | 09:00AM Comment 11 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 24-11-2017 09:00 AM Time Taken: 2.00 |
| Hi Rashna, I have resolved this issue in beta6. regards
Alvis |
|
| 24 Nov 2017 | 09:35AM Comment 12 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 24-11-2017 09:35 AM |
| Break hours to deduct is calculated as follows: Scenario 1: Employee works from 8am to 5pm on Monday Break Taken = (Monday Segment 1 plus 1 hour) - Hours work between Shift start and end
= (8 + 1) - 9
= 0 Break to deduct = 1 - Break Taken (capped at maximum on 1 hour) = 1 hour Scenario 2: Employee works from 8am to 2pm on Saturday Break Taken = (Monday Segment 1 plus 1 hour) - Hours work between Shift start and end
= (5 + 1) - 6
= 0 Break to deduct = 1 - Break Taken (capped at maximum on 1 hour) = 1 hour Scenario 3: Employee works from 8am to 1:30pm on Saturday Break Taken = (Monday Segment 1 plus 1 hour) - Hours work between Shift start and end
= (5 + 1) - 5.5
= 0.5 Break to deduct = 1 - Break Taken (capped at maximum on 1 hour) = 0.5 hours Note: Break hours is always deducted from in order of "Double Time" then "Time Half" then "Normal" Figure 1: Shift Maintenance setup
|
|
| 24 Nov 2017 | 09:46AM Comment 13 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 24-11-2017 09:46 AM |
| Hi Rashna, BETA6 is available on FTP. Please proceed with UAT.
Regards
Sanjay |
|
| 24 Nov 2017 | 12:01PM Comment 14 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 24-11-2017 12:01 PM Time Taken: 1.00 |
| Tested case in QA1 with database LINKSOFT. Version 819 Beta 6 Table 1 - Summarised list of issues | No | Issue Description | Resolved? | | 1 | Employee works from 8am to 1pm on a Saturday. Normal hours should be 5 | Pass | | 2 | Employee works from 8am to 5.06pm on a Friday. Normal hours should be 8 and time and half as 0.1 | Pass | | 3 | Employee works from 8am to 5.06pm on a Saturday. Normal hours should be 5 and time and half as 2 and double time as 1.1 | Pass |
Figure 1: 
|
|
| 24 Nov 2017 | 12:16PM Comment 15 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 24-11-2017 12:16 PM Time Taken: 1.00 |
| Documentation completed on the case. Documentation updated under ESS --> Time sheet Import --> Time sheet Rules --> Deduct minimum 1hr break |
|
| 09 Oct 2019 | 08:14AM Comment 16 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 |