Clarity: Timesheet time entries that are financially enabled are not backed out when adjusting the timesheet

Document ID : KB000027076
Last Modified Date : 14/02/2018
Show Technical Document Details


Transactions are not created if we delete the time entries of a timesheet when we adjust it. After posting the adjustment timesheet, the timesheet status becomes "posted" but no transactions are created. The "Invalid transaction" page is empty (no new transaction, no invalid transaction). So nothing is posted to financial and only transactions of the original Timesheet are available in PPA_WIP.

If we zero out the unwanted hours when we adjust a timesheet, the problem doesn't occur, transactions are created to back out the original quantities.

Steps to Reproduce:

  1. Create a timesheet and enter time on a task
  2. Submit and approve the timesheet
  3. Post the Timesheet
  4. Post transaction to financial
  5. Post to WIP. Check that transactions exist in ppa_wip
  6. Adjust the timesheet and delete the time entry added for the task
  7. Submit and approve the timesheet
  8. Post the timesheet

Expected Result: To see transaction entries in the database with the financial entries backed out.
Actual Result: There are no new transaction in the "Invalid transaction" page and of course nothing is sent to financial. The status of the timesheet is "Posted"


When adjusting timesheet and removing the financial tasks, make sure to leave a direct task on the timesheet with zero time tracked towards that task and enter a note so that the task is not removed from the timesheet. This will cause the financial entries to be backed out.

Resolved in Clarity 12.1.3 Generic Patch. Reference TEC570813
Resolved in Clarity 13.1.0

This has been resolved by removing the Delete button on the adjustment timesheet. When user makes an adjustment to a posted timesheet, the UI will no longer have a delete button for existing time entries. User will need to replace any unwanted hours with a zero (0) quantity.