Actual Cost > 0 when Quantity/Hours = 0 on Transactions and Assignments

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Reviewing some assignments, the hours show as 0 but there is a cost.  How can this happen?

 

Environment

Release : 16.0.0

Component :

Cause

This can happen under this scenario

• Timesheet posts at one rate and the transactions posts to WIP
• Rate is updated
• Timesheet is adjusted and hours are removed from the task. 
  •  
• Post the adjusted timesheet to WIP
  • If all hours are remove from the task, the quantity = 0 but the cost will be the delta between the original rate and the new rate.

 

Example 1:

2 hours post at a rate of $50/hr for a cost of $100

Rate is changed to $25/hr

Adjust a timesheet and remove the 2 hours

The new rate is 25/hr or 50 and this is what is credited from the transaction.  (100-50) instead of (100-100)

Therefore now the Quantity = 0 but Cost = $50

 

Example 2:

2 hours post at a rate of $50/hr for a cost of $100

Rate is changed to $25/hr

Adjust a timesheet and remove 1 hour

The new rate is 25/hr and since only one hour now this is what is credited from the transaction.  (100-25) instead of (100-50)

Therefore now the Quantity = 1 but Cost = $75

 

Note this happens on timesheets as well as transactions.

Resolution

This is the current design for adjusting timesheets when the rate has been changed and is currently under review.