Display Total Hours in Timesheet based on Booking line EWT
Content was last updated in 06.00.06-00
Revision History
Version No. | Reference No. | Changes |
06.00.06-00 | R2-9954 | Display Total Hours in Timesheet based on Booking line EWT |
The Time sheet is supported with display of Total Hours calculated based on RT/DT/OT Hours, and Break Hours defined in Booking line EWT. The Time sheet enables to modify Break Hours as per requirement.
The functionality is explained in below Sample Workflow:
For the functionality to work, the Timesheet option must be enabled in Web Labor Settings > Config. Prarameters > TimeSheet Disable (1- true/0 -false)
Prerequisites
Define RT/OT/DT Hours, and Break Hours in Booking line EWT
Sample workflow
Login to R2Labor application > open the Order in Planning Order screen.
Define EWT and Break Hours, as shown in Figure 1.0 > assign and confirm the Resources > save the changes, as shown in Figure 1.0.

Figure 1.0 Define EWT for the Booking line and Confirm Resource
Scenario: Create and Export Timesheet with Booking line EWT details
Select the Order from Order search screen > click the Timesheet button. The Timesheet for the select Order is displayed with RT/OT/DT Hours, Break Hours, and Total Hours defined in EWT of Booking line.
Select required booking lines > click Send for Approval > get the Timesheet approved.
Select Timesheet option from the Planning menu > search and select Timesheet for the Order > click the Export Timesheet button. The Timesheet exported in Excel format displays, In-Out Time, Total Hours, RT/OT/DT Hours, and Break Hours, as shown in Figure 1.1.
The Timesheet enables to modify Break Hours as per requirement before approval.
The Break Hour modification recalculates Total Hours based on newly defined Break Hours.
The RT/OT/DT Hours are enabled by selecting [In and Out Time] as Enter Time By option in Timesheet. Ref: Figure 1.1

Figure 1.1: Timesheet with Total Hours, Break Hours, and RT/OT/DT Hours
The Timesheet is applicable for Confirmed lines.
The In-Out Time, RT/DT/OT Hours and Break Hours set on the Booking Line EWT is displayed as Time Sheet entries.
The Break Hours are Enter Time by option is selected as In-Out Time, then In-Out Time along with Break Hours will be carried from EWT but RT/DT/OT Hours (not visible to users) will not be carried instead computed as per the Pay Policy/Unit applicable to display the Total Hours and Total Cost.
The RT/OT/DT Hours and In-Out Time can be modified, and the Total Cost is re-calculated as per Total Hours based on the modified RT/OT/DT Hours and In-Out Time.