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.
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.
I think below query should doi.
UPDATE tm_time_sheetsSET status_code = 5WHERE 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.