Company: Link Technologies
Case No: L11671. Project: 11.40: LinkSOFT Version 11.4
Logged By: Alvis (Link Technologies) on 16 Aug 2019 11:27AM
Priority: Medium
Product: Payroll & HR
Group: Change Request
Time Taken: 23.50 (Weight: 26.50)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay, Vineet
Resolve By: Saturday, 17 August 2019 12:00 AM [1712 days since logged date]
Status: Closed
Subject: Auto Calculate Normal Hours and Overtime when ShiftID, Start Time and End Time details are filled
Summary:    
At this moment supervisors have to manually calculate if an entry is being edited due to no start time or missing end time. Have a look at the below screenshot as an example. User will have to use an excel or a calculator to calculate the hours. The minute this process is done manually, we have opened up room for errors in calculation and made the user reluctant to use the system, since one part is manual. You can allow them to override but the first instance system should calculate.

Calculation rule to look at Shifts Segment hours, as well as Time Control, Details sequencing order for calculation of normal hours, time and 1/2 and double time

Audit Notes:
16 Aug 201911:55AM Comment 1 by Alvis (Link Technologies) Case 11671 added to project 11.0
16 Aug 201912:02PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 16-08-2019 12:02 PM Time Taken: 3.50

Development work for this case has been completed.

The change will be available in version: 11.0.0816

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

  1. Removed "Normal", "Time (1/2), "Time (2x" and "Holiday" fields from the add/edit form
  2. When an entry is added or modified, the system computes the hours based on the start and end time.

2. The issue was caused by:

  1. Improvement

3. Next Step:

  1. UAT

4. Notes:


16 Aug 201903:14PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-08-2019 03:14 PM Time Taken: 1.50
For UAT 

20 Aug 201910:07AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-08-2019 10:07 AM Time Taken: 2.50
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

Set the shift to 'DS' for employee 'E029'.

Start Time - 8am
Break 1 - 10 to 10.30am
Lunch - 1pm to 2pm
Break 2 - 4pm to 4.15pm

Shift Segment

  1. Segment 1 (Normal) = 8
  2. Segment 2 (Time and 1/2) = 2
  3. Segment 3 (Double Time) = 8

Create a timesheet for the date 20/08/2019 with start time as 8am and finish as 5.00pm

The system create the entry with "Normal" hours as 7.25

 

Pass
2

Create a timesheet for the date 21/08/2019 with start time as 8am and finish as 7.30pm

The system create the entry with "Normal" hours as 8 and "Time and Half" as 1.75.


Pass
3

Create a timesheet for the date 22/08/2019 with start time as 8am and finish as10.0pm

The system create the entry with "Normal" hours as 8 and "Time and Half" as 2 and "Double Time" as 2.25


Pass

Environment Details

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

Next Step: 

  1. Closure

    20 Aug 201902:07PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-08-2019 02:07 PM Time Taken: 2.50

    Email sent from Vineet, Bula Rashna


    Could you also test the below shift setup where all hours needs to be paid as Normal for an employee inconsiderate to any hours they work. This is critical for Tappoo and New World.

    __________________________________________________________________________________________________________

    Test Results

    1. Configure the shift in such that all hours would be paid as "Normal".  Refer to Figure 1.
    2. Manually create a timesheet for employee E022 for 21/08/2019. 
      1. Start Time - 8am
      2. End Time - 5pm
      3. Break 1 - 10am to 10.30
      4. Lunch - 1pm to 2pm
      5. Break 2 - 4pm to 4.15pm.

      Total hours calculated should be 12.25. This should be updated as "Normal" hours - Pass. Refer to Figure 2.

    Note: This scenario will be further tested in case 11650.



    Figure 1: Shift Setup

    Figure 2: Timesheet Hours

    Next Step - Closure



    20 Aug 201904:09PM Comment 6 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 20-08-2019 04:09 PM Time Taken: 3.50

    Development work for this case has been completed.

    The change will be available in version:11.0.0820

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

    1. Changed "Timesheets Select" and "Timesheets Update" procedures to include "Calculate Hours" flag.
    2. Added "Normal, Time 1/2, Double, Holiday" hours to the editor

    2. Affected Areas:

    1. Time & Attendance ~> Timesheets

    3. The issue was caused by:

    1. Improvement

    4. Notes: 
    5. Next Step    : UAT


    21 Aug 201901:51PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 23-08-2019 12:00 AM Time Taken: 2.50

    Hi Alvis,

    The "Calculate Hours" checkbox is auto enabled at edit.

    Steps to Replicate

    1. Create a Timesheet for employee E022.
    1. Date - 21/08/2019
    2. Shift - DS
    3. Territory - 1001
    4. Branch - 1000
    5. Cost Centre - 10.20
    6. Start Time -  8:00 AM
    7. End Time - 5.30Pm
    8. Normal Hours - 9.5 (Assuming that the employe worked at lunch)
    9. Save
    Edit the record in 1 above. The "Calculate Hours" check box is enabled. 
    1. Enter Time(1/2) as 2 
    2. Save  - This recalculates the "Normal Hours" in 1 above.
    Thanks
    Rashna

    21 Aug 201902:32PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-08-2019 02:32 PM Time Taken: 2.50

    Development work for this case has been completed.

    The change will be available in version:

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

    1. Changed the "Timesheet Select" procedure to default the "Calculate Hours" checkbox to unticked

    2. Affected Areas:

    1. Timesheet ~> Edit entry

    3. The issue was caused by:

    1. Improvement

    4. Notes: 
    5. Next Step    : UAT


    23 Aug 201903:23PM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-08-2019 03:23 PM Time Taken: 1.50
    For UAT

    28 Aug 201902:38PM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 13-09-2019 12:00 AM Time Taken: 2.50
    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

    Add a timesheet for employee E003 with below details

    • Start Time - 8.00am
    • End Time - 2.30pm

    Save this record.

    1. Normal Hours, Time and Half, Double Time and Holiday hours should be 0
    		Pass
    2

    3

    Add a timesheet for employee E003 with below details

    • Start Time - 8.00am
    • End Time - 2.30pm
    • Tick "Calculate Hours"

    Shift - DS
    Start Time - 8am
    Break 1 - 10 to 10.30am
    Lunch - 1pm to 2pm
    Break 2 - 4pm to 4.15pm 

    Save this record.

    1. System should calculate hours for the employee as 
      1. Normal - 5
      2. Time and Half -0
      3. Double Time - 0
      4. Holiday - 0
    		Pass
    4

    Add a timesheet for employee E003 with below details

    • Start Time - 8.00am
    • End Time - 5.08pm
    • Tick "Calculate Hours"

    Shift - DS
    Start Time - 8am
    Break 1 - 10 to 10.30am
    Lunch - 1pm to 2pm
    Break 2 - 4pm to 4.15pm 

    Save this record.

    1. System should calculate hours for the employee as


      1. Normal - 7.38
      2. Time and Half -0
      3. Double Time - 0
      4. Holiday - 0

    2. Update hours as below and it should be saved without errors

      1. Normal - 8
      2. Time and Half -2.5
      3. Double Time - 1
      4. Holiday - 0


    3. Recalculate the hours and results in 1 above should be updated


    		Pass

    Environment Details

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

    Next Step: 

    1. Documentation

      03 Dec 201903:03PM Comment 11 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 04-12-2019 03:00 PM Time Taken: 1.00

      Hi Sanjay, 

      Documentation has been updated under LinkWebApplicationsPortal - Time & Attendance - Timesheets.

      Thanks
      Rashna


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

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