Project and Portfolio Management Practitioners Forum
cancel

Cancel Unsubmitted and Pending Approval timesheet

Highlighted
shijub
Respected Contributor.

Cancel Unsubmitted and Pending Approval timesheet

Hi ,

 

How can we cancel the timesheet for the past period which are in Unsubmmited and Pending approval status, since we are in process to have these cleared and have them in Cancelled status.

 

Is there any ways we can have this cancelled.

 

Thanks in Advance.

 

2 REPLIES
PPrasoon
Regular Contributor.

Re: Cancel Unsubmitted and Pending Approval timesheet

Yes, you can update the selected time sheets and lines in tm_time_sheets and tm_time_sheet_lines, columns  status_code and state in rwespective tables to 5. It would do.

 

-Parijat

Mohit_Agrawal
Outstanding Contributor.

Re: Cancel Unsubmitted and Pending Approval timesheet

I think below query should doi.

 

UPDATE tm_time_sheets
SET status_code      = 5
WHERE time_sheet_id IN
  (SELECT time_sheet_id
  FROM KTMG_TIME_SHEETS
  WHERE status_code IN ('ACTIVE','RELEASED')
  );

 

 

Please try this on DEV/QA first. It would cancel all lines which are unsubmitted or pending approval.

 

Thanks

Mohit