Subject: | Enhance Payroll Timesheet Report so that it shows the total Allowances Created/Submitted/Approved in ESS Ready to Flow to Payroll |
Summary: | Justification
Currently the Timesheet Payroll Report in ESS only shows the separation between Normal Hours, Time and Half and Double time hours submitted or approved. Any other activities approved is accumulated in the Other section. There is not breakdown of individual allowance that would be paid to an employee. This is problematic for the Payroll personnel as they are unable to reconcile what exactly has been approved and needs to be paid. Hence we need to modify our Time sheet payroll report so that the breakdown of allowance could be seen similar to the way Normal hours, Time and Half and Double time are shown in that report. See figure 1.1 below for current design. Figure 1.2 on the other hand shows the new proposed design. Further discussion in the development meeting. Figure 1.1 Current Design - Removed for security reasons
Figure 1.2. New Proposed Design.- Removed for security reasons In Figure 1.1 above if you look at employee 40309, it has a quantity of 89 in Other Section. Now we do not know what that other is from Figure 1.1. If you look at Figure 1.2, You can clearly see that 89 is sum of 44 Hours of BOPEARTOR, 44 hours of BSHIFT and 1 EMEAL allowance. This report has a similar design to Employee Hours Analysis report that we created in ESS. No change to the filters of the report. Only change to the layout of pay codes. Vineet
|
Audit Notes: | Edited by sanjay on 05/03/19 09:39. Edited by sanjay on 05/03/19 09:23. Edited by sanjay on 05/03/19 09:03. |
02 May 2017 | 03:05PM Comment 1 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 02-05-2017 03:05 PM |
| Hi Vineet, Can you provide screenshots on what change is exactly required? |
|
16 May 2017 | 09:46AM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 17-05-2017 12:00 AM Time Taken: 1.00 |
| Hi Team, As per discussion with Sanjeet, we can have new report for Allowances in ESS. This will allow users to verify if the calculated allowance before pay is created. The following data filters can be part of the report. - Date From
- Date To
- Employee From
- Employee To
- Allowance From
- Allowance To
- Union
- Shift
|
|
16 May 2017 | 10:28AM Comment 3 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 16-05-2017 10:28 AM |
| Hi Vineeet, can you get a design for this report. |
|
02 Jan 2018 | 12:47PM Comment 4 by Vineet (Link Business Solutions) Assigned To: AwaitingApproval Followup Date: 02-01-2018 12:47 PM Time Taken: 1.00 |
| Hi Team The case header has been updated with the design. Please review Figure 1.2 of the case header for the design. Vineet Ram
|
|
11 Jan 2018 | 03:01PM Comment 5 by Alvis (Link Technologies) Case 8400 added to project 900 |
11 Jan 2018 | 03:03PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Development Followup Date: 11-01-2018 03:03 PM Time Taken: 1.00 |
| Development meeting January 2018 Sanjay, Alvis, Sanjeet and Vineet. Approved for development The following will be done - Add a parameter show "Other" details
- Add a sub report to list the break down of "Other" amounts.
|
|
26 Jul 2018 | 08:34AM Comment 7 by Rashna (Edge Business Solutions) Case 8400 removed from project 999 |
30 Aug 2018 | 09:29AM Comment 8 by Alvis (Link Technologies) Case 8400 added to project 09.5 |
04 Sep 2018 | 08:17AM Comment 9 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 04-09-2018 08:17 AM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version: 9.5 beta 3 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - The "Show Details" parameter has been extended to show details of the pay code. This includes the breakdown of "Other" column.
2. The issue was caused by: - N/A
3. Next Step - UAT
|
|
10 Sep 2018 | 10:49AM Comment 10 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 10-09-2018 10:49 AM Time Taken: 1.00 |
| System test completed. proceed with UAT. |
|
27 Sep 2018 | 09:10AM Comment 11 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 27-09-2018 09:10 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 No | Test Description | Pass/Fail | 1 | Timesheet payroll report (show details) is showing the breakdown of "Other" column | Pass |
Environment Details - OS version: Windows 7
- Application version: 10 Beta 4
- Setup: Demo
- Server : 10.0.0.10
- Database: UAT-LINKSOFT-DemoData
Next Step: update documentation
|
|
01 Oct 2018 | 09:13AM Comment 12 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 01-10-2018 09:13 AM Time Taken: 1.00 |
| Hi Sanjay, Documentation has been completed on the case. Documentation updated under Link Web Applications Portal -- Reports -- ESS Reports -- Timesheet Payroll Report. Thanks Rashna |
|
02 Oct 2018 | 04:45PM Comment 13 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-10-2018 04:45 PM |
| Thanks Rashna |
|
09 Oct 2019 | 08:14AM Comment 14 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 |