Company: Link Technologies
Case No: L11833. Project: 11.40: LinkSOFT Version 11.4
Logged By: Alvis (Link Technologies) on 18 Nov 2019 03:16PM
Priority: Medium
Product: Payroll & HR
Group: Software Defect
Time Taken: 6.00 (Weight: 6.00)
Version: 11.4.0302
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Sanjay
Resolve By: Wednesday, 20 November 2019 09:02 AM [1613 days since logged date]
Status: Closed
Subject: Need the system to display and calculate Time correctly for employees who start work on one date and end work on the next date
Summary:    
Customer name:
 New World
Project Title:
 TNA
Requested By and Contact Details:
 Avneet
Business Case:
 
Estimated Cost:
 
Cost covered by:
 
Alternatives:
 

Change Details:

New World has the following scenario:

  1. Employee have overlapping shifts where they start in the afternoon and end in the morning of the next day

  2. The following rules are enabled:
    • R003 – Change multiple IN (1) for a date to BREAK IN (2)
    • R005 – Create Normal Hours time entries as approved
    • R009 – Mark entries exceeding maximum hours configuration as invalid
    • R013 - System to automatically define time entry as IN or OUT for a day

  3. They have R013 running because in their business scenario, employees take multiple breaks within a day and New World wants to pay employees based on the actual hours worked, therefore, they are using this rule to achieve this.
The above scenario was tested based on the 4 rules currently active and below are the results:

Rules:

Scenarios:

System Results:

R003, R005, R009 & R013 with no Rostering

Employee 100006 starts & ends works as follows:
15/10/2019 – IN – 8PM
16/10/2019 – OUT – 8AM
16/10/2019 – IN – 8PM
17/10/2019 – OUT – 8AM
17/10/2019 – IN – 8PM
18/10/2019 – OUT – 8AM

For each day a separate entry is created, See figure 1. This is incorrect.

 

R003, R005, R009 & R013 with Rostering in shift: OVLAP

Employee 100002 starts & ends works as follows:
15/10/2019 – IN – 8PM
16/10/2019 – OUT – 8AM
16/10/2019 – IN – 8PM
17/10/2019 – OUT – 8AM
17/10/2019 – IN – 8PM
18/10/2019 – OUT – 8AM

For each day a separate entry is created, See figure 2. This is incorrect.

 


Figure 1:

Figure 2:

This has become an issue at NW, there have many employees who work in overlapping shifts and their shift starts at night and ends the next morningThe correct calculation should have been; the system should have calculated this one entry starting on the 15th and ending on the 16th and then starting on the 16th and ending on the 17th and then starting on the 17th and ending on the 18th.

New World needs a rule to have the above scenario catered without disabling any of the current rules (this are: R003, R005, R009 & R013).

Please advise.


Audit Notes:Edited by sanjay on 08/12/20 09:14. Edited by sanjay on 08/12/20 09:14. Edited by alvis on 19/11/19 09:30. Edited by alvis on 18/11/19 15:16. 
18 Nov 201903:14PM Comment 1 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 18-11-2019 02:55 PM Time Taken: 1.00
Hi Aarti, we will add this request to version 11.

18 Nov 201903:16PM Comment 2 by Alvis (Link Technologies) Case L11833 added to project 11.004
19 Nov 201909:28AM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 20-11-2019 09:02 AM Time Taken: 4.00

Development work for this case has been completed.

The change will be available in version:11.4.1119

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

  1. Changed TNA Rule R003 as follows:
    Change multiple clock type "IN" to clock type "BREAK-IN" for entries in a day. Shift start time and "Time Buffer" settings are used to determine a day.
    For Example:
    1. Shift A starts at 8 am and "Time Buffer" has 15 minutes before the start, then a day is from 7:45 am to 7:44 am (next day)
    2. Shift B starts at 8 pm and "Time Buffer" has 60 minutes before the start, then a day is from 7:00 pm to 6.59 pm (next day)

2. Affected Areas:

  1. TNA processing Rule R003

3. The issue was caused by:

  1. Improvement

4. Notes: Refer to the documentation for details
5. Next Step
: UAT


25 Nov 201910:53AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 26-11-2019 08:02 AM Time Taken: 1.00
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
1Employee E078 starts & ends works as follows:
15/11/2019 – IN – 8PM
16/11/2019 – OUT – 8AM
16/11/2019 – IN – 8PM
17/11/2019 – OUT – 8AM
17/11/2019 – IN – 8PM
18/11/2019 – OUT – 8AM

Pass



Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.0.0506
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-11-RASHNA

Next Step

  1. Closure.

Note: Do not use rule R013. The rule will contradict with rule R003 as rule R013 does not pay break hours.


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

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