ACWP calculates at a $1 rate

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Every so often we find that the ACWP calculated for timesheets posted applies the rate of $1. It happens randomly for for some project task assignments.

A project might show the issue for a specific task assignment, but other assignments on the same project might be OK.

One timesheet might have 5 tasks posted and only 1 of them might show the issue. It looks pretty random.

Below can be found some STR to get this reproducible.

STEPS TO REPRODUCE:

Create a project with start and finish dates as of current date, let say 11/17/25
Financially enable the project
Add a financially enabled resource to the Staff tab
Create a task with current date as start and finish dates
Assign the team member to the task
Home > Reports and Jobs > Jobs
Run the Rate Matrix Extraction job with options 2 (Prepare Rate Matrix Data) and 3 (Update Rate Matrix Data) checked
Check at the DB side:
SELECT * FROM NBI_PROJ_RES_RATES_AND_COSTS WHERE project_id = <internal 5 million ID>
Notice the rate data is present and the From Date and To Date columns provide the range the rate is available at (current date)
Open a timesheet for the resource assigned for the current week.
Enter time against the task above, ensure time is entered against a date not covered on the assignment, let say the 11/20/25
Post time timesheet

Expected Results: ACWP at assignment level is calculated based on the rate available at matrix
Actual results: ACWP at assignment level is calculated at a rate of $1

Environment

Any supported Clarity release

Cause

the post timesheet job has modified the assignment dates due to the time posted at the timesheet and the NBI_PROJ_RES_RATES_AND_COSTS table does not contain a rate for the resulting whole assignment.

Resolution

In order to get around this:

Run the Rate Matrix Extraction job with options 2 (Prepare Rate Matrix Data) and 3 (Update Rate Matrix Data) checked to ensure the NBI_PROJ_RES_RATES_AND_COSTS table gets populated with the mew assignment date range
Run the Posting Repair and Actual Cost Curve Regeneration to rebuild the cost curve.

Please open a support ticket if you have never run the Posting Repair and Actual Cost Curve Regeneration job or you do not find it on the list of available jobs

Additional Information

The original assignment dates where for a single day and the NBI_PROJ_RES_RATES_AND_COSTS table has only got a rate for a single day

Notice that the post timesheet job modifies the assignment dates due to the time posted at the timesheet where the Start Date will be the first timesheet day where time is entered and the Finish Date will be the last timesheet cell where time is entered. The NBI_PROJ_RES_RATES_AND_COSTS table does not contain a rate for the resulting whole assignment and that is why the $1 rate is applied.

The RME job will update the NBI_PROJ_RES_RATES_AND_COSTS table so a rate exists for calculating the whole assignment.

The Posting Repair and Actual Cost Curve Regeneration job will be needed to rebuild the cost curve. This is hidden by default and is recommended to run it under Support supervision: