Options to correct WIP Actuals and Costs after Rate matrix update
search cancel

Options to correct WIP Actuals and Costs after Rate matrix update

book

Article ID: 233615

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Users were unaware of the new rate change for the new year and have timesheets actuals that need to reflect this new rate.  As there is a large amount of WIP transactions or timesheet adjustments what is the best option available

Environment

Release : Any

Resolution

Timesheet adjustments are not recommended to correct rates.

Simply re-posting the timesheet (creating an adjustment timesheet with no real adjustments) does not create an adjustment to the financials for the new rates. Any new timesheets or adjusted timesheets (with real adjustments to quantity or charge code, etc) will pick up the current rates in the matrix.

Two possible options are:

  • Create a WIP Adjustment with Calculate New Rates on (will require opening manually of each WIP transaction)
  • WIP Transfer (can do up to 20 transactions at a time in bulk)

The best option is WIP transfer:

  1. Go to Create a WIP Adjustment
  2. Filter on Investment - Task 
  3. Select all transaction - Transfer 
  4. Select Calculate New Rates
  5. Submit
  6. Run Import Financial Actuals job and Update Earned Values job