Restricting booking line modification if the Timesheet exists

Content was last updated in 06.01.15-00

Revision History

R2Labor restricts modification on booking lines if the valid timesheet (created/approved/rejected) exists.

Why are we not allowing you to modify/delete the booking lines having Timesheet?

From a business-logic perspective, an existing timesheet on a booking line indicates that the assigned crew has already started working on the task allotted, which means the labor hour billing has started. Thus, imperatively there is no business-case for the crew task details to be modified or deleted.

Also, the Planner might bulk select the booking lines having Timesheet/No Timesheet for planning. In such case, planning is allowed only for the lines without Timesheet and a on-screen message displays for the lines which has Timesheet.

These restrictions increase the data security and integrity, bringing it to near watertight level.

In addition to this, a specific Timesheet icon is introduced in the following places to indicate that the date is added to the Timesheet.

• Whiteboard window

  Figure 1.0: Timesheet icon in Whiteboard

  

• Planning Order/Whiteboard: Assign Dates

  Figure 3.0: Timesheet icon in Assign Dates window

  

   

Planning Order: If Timesheet exists, following actions/fields are restricted

1. Booking line grid: Resource, Company, Status, and Task fields are not editable.

2. Actions in Booking line

3. Confirmation Request, Clear Resource, Search Resource, Reset, and Reset Task/date actions are not allowed. Also, a message displays to indicate that the action could not be performed since the line had Timesheet.

4. More information: Resource, Company, Status, and Task fields are not editable.

5. Assign Dates: Below actions cannot be performed.

6. Regenerate: If any of the date is added to the Timesheet, then EWT cannot be re-generated. A message is displayed for the same.

   Figure 4.0: Message on re-generate action

   

    

7. Split: Irrespective of the single/ multiple dates selected, you cannot split if any one of the selected date has Timesheet. A message is displayed for the same.

   Figure 5.0: Message on split action

   

    

8. Modify: 'Day' and 'Date' fields are not editable to modify the EWT. Rest all the fields are editable as shown here.

   Figure 6.0: Message on EWT modification

   

    

9. Append lines: Creates new EWT entries for the dates for which EWT does not exists and stops updating EWT entries which are already present. This behavior remains same irrespective of whether the Timesheet exists or not.

10. Delete: Delete action cannot be performed for the lines having Timesheet. If you bulk select the lines to delete, then system deletes the lines which has no Timesheet. A message is displayed for the same.

    Figure 7.0: Message on delete action

    

     

3. Booking line tool bar

4. Reset

5. Single line selected: System does not reset the line data to unplanned line.

6. Multi-line selected: System resets the line data only for the lines not having Timesheet.

For both the above cases, the following message is displayed.

"Line(s) having Timesheet could not be reset".

• Reset Task/Dates

• Single line selected: System does not reset the task/dates to unplanned line.

• Multi-line selected: System resets the task/dates data only for the lines not having Timesheet.

For both the above cases, the following message is displayed.

 "Could not reset Task/Dates for line(s) having Timesheet".

• Assign Resource

• Single line selected: System does not assign the resource and throws a message.

• Multi-line selected: System prompts a message stating "Cannot assign Resource to some of the lines, since they have Timesheet. Do you want to continue?". Upon Yes, ‘the Assign Resource’ window opens. However, you can only see the Labor positions that doesn't have Timesheet.

• Send Confirmation request

• Single line selected: System does not send the request and the following message is displayed.

"Selected line is having timesheet already and hence will not send request".

• Multi-line selected: Confirmation request can be sent only for the lines without Timesheet. Also, the following message is displayed.

"Request cannot be sent for the lines having Time Sheet. For rest of the lines, e-mails are scheduled and will be delivered on Save".

• Additionally, you will see the Timesheet exists message in another possibility. Consider the following scenario for the feature explanation:

• When a Confirmation request is sent to two Resources [Resource#1 and Resource#2] and Resource#1 accepts the confirmation request first and the timesheet is created, then the Resource, Company, and Status fields will be disabled for that booking line.

• Now, even if Resource#2 accepts the request, these fields will not be changed. The Planner however, receives a message stating that the "Resource#2 has accepted the confirmation for the following Job but could not be confirmed on the Order because Timesheet already exist. Kindly take necessary action".

• Clear Resource

• Single line selected: System will not clear the resource and displays a message.

• Multi-line selected: Resource can be cleared only for the lines without Timesheet and displays a message.

In both the cases, the following message is displayed.

“Some of the line(s) could not be updated as they have Timesheet”.

• Update lines > Booking line details

• • Single line selected: The Resource, Status, and Union/Broker/Pay agent (company), Task fields are not editable.

  • Multi-line selected: Resource, Status, Union/Broker/Pay agent (company), and Task fields updates only for the lines without Timesheet. You will also see the following message.

"Some of the line(s) could not be updated as they have Timesheet".

• Assign Dates

1. 2. Single line selected: The behavior is same when performed from 'Actions' booking line.

   3. Multi-line selected: If any one of the selected line has Timesheet, then you can generate the EWT only for the lines without Timesheet. The following message is displayed.

"Some of the line(s) could not be updated as they have Timesheet".

4. Booking line > right click

5. Reset: The functionality is same as 'Reset' action in booking line tool bar.

6. Reset Task/Dates: The functionality is same as 'Reset Task/Dates' action in booking line tool bar.

7. Update lines: The functionality is same as 'Update lines' action in booking line tool bar.

8. Assign Dates: The behavior is same when performed from 'Actions' booking line.

5. Task tab: You cannot apply the task modified from the ‘Task’ tab to the lines having Timesheet. The following message is displayed.

“Could not apply the task to the line(s) having Timesheet”.

6. Additionally, following actions are also stopped if Timesheet exists:

• Deleting booking line having Timesheet

  Delete action cannot be performed for the line having Timesheet irrespective of the line is added from R2/R2Labor so that the Timesheet remains relevant. A message is displayed as "Line(s) having Timesheet could not be deleted".

  If Timesheet exists for a Booking line and the line is added in R2/R2labor, following are the behavior of the 'Delete' action.

  Table 1.0: Delete action behavior

  Line added in	Line deleted in	Color of the line strike in R2labor	Line deleted
  R2	R2	Red	No
  R2	R2labor	NA	No
  R2labor (line is not synced with R2)	R2labor	NA	No
  R2	R2 (line is deleted when planned/planning in R2labor)	Red	No

   

  Following are the access places to delete the booking lines.

  • Planning Order > Tool Bar > Delete line(s): Multi- line action

  • Planning Order > Right Click menu > Delete line(s): Multi-line action

   

• Booking line status remains unchanged when the dates are changed in R2

  • Whenever the dates are changed in R2, the status of the Booking lines remains unchanged.

  • While the changes done in R2 reflect in the conflict column.

Whiteboard: If Timesheet exists, following actions/fields are restricted

1. Booking line > Right click

2. Update lines: The functionality is same as 'Update lines' in Planning Order.

3. Assign Dates: The functionality is same as 'Assign Dates' in Planning Order.

4. Reset Task/Dates: The functionality is same as 'Reset Task/Dates' in Planning Order.

5. Split: Irrespective of the single/ multiple dates selected, you cannot split if any one of the selected date has Timesheet. A message is displayed for the same.

6. Change Date-Time

7. If all the fields are modified in 'Change Date and Time' dialog window: System updates data only to the dates having no Timesheet and restricts for the dates having Timesheet.

8. Apart from 'Date' field, if all the other fields are modified in 'Change Date and Time' dialog window: The data will be updated for the dates irrespective of whether the Timesheet exists or not.

2. Booking line > Reset Task/Dates for selected rows: The functionality is same as 'Reset Task/Dates'  in Planning Order.

Graphical Scheduling: If Timesheet exists, following actions are restricted

1. Confirmation request: The request cannot be sent and system displays a message for the same.

2. Assigning job to the crew: You cannot drag and drop the booking bar to the crew (lower) section/ within the crew section.

Communicate: If Timesheet exists, following actions/fields are restricted

1. Resource tab > Confirmation request: Behavior is same as Confirmation request in Planning Order.

2. UBA tab: U/B/A field is not editable for the lines.