Incorrect entries in "Resource Aggregates Monthly" table?

[oleg7]

We run reports on Resource Aggregates Monthly table and I noticed that some of "non-project time"-entries don't have any task specified.

How is that possible and what can those be? Task-field is always mandatory when creating new resource plans:

Having those "empty" entries we can't perform proper planning as resource allocation does not reflect real situation.

[Ian Mildon]

Check that the table has a "top_task" field and value.

[oleg7]

What table? resource_aggregate_monthly doesn't have such field

[Ian Mildon]

The table(s) that the data is referencing, such as Project or Demand. 

I ran into similar issues a while back on resource_allocation_daily table whereby there was similar empty task values. A part of HI's response was:

That is correct, the (top_task) field on the Allocation Daily is not populated because there is no (top_task) field on the (dmn_demand) table. However, there is a (top_task) field on the Project & Project Task table. This is why we need (Top Task) to be populated on the Allocation Daily table for any Project Related tasks.

I'm thinking you may have something similar 'downstream' that is not feeding up to the monthly table values.

[Chad B]

I'm seeing the same thing.  It's happening when we remove resource plan allocations from a resource plan.  I haven't nailed down the exact steps that are being used, but if I create a resource plan (in error as example) and really don't need it, we then remove that resource plan or allocation.  At this point, you can no longer see it when looking at the project resource plans, but the records are still in the resource allocation daily table as evident by either reports that I create, or looking at the out of the box "resource reports".  I'm trying to figure out if we're doing something wrong, process wise, or if this is a system issue.