Issue with Actual Cost rollup at Project Level

DavidB-ADT
Tera Guru

We recently migrated to SPM from PlanView Portfolios. Having an issue with Project rollup actuals not matching the total of cost plan breakdown, or expense line actuals.

 

Here's a visual example about what I mean:

DavidBADT_0-1726063248699.png

It's even more screwed up on the New Experience, as all numbers don't match. Right now, I'm trying to solve Classic first before tackling New Experience.

DavidBADT_1-1726063455580.png

 

Having downloaded all the Expense Lines (project, and project task level), plus the Cost Plan and Cost Plan Breakdown records, I've done some analysis and here's what I see:

 

TableSource Table /
Breakdown Type
CapexOpexComments
Expense Linepm_project1,341,720.21398,900.22Capex variance of $405.98 on system generated cost plans (expense line amount vs cost plan actual). No idea how/why.
Expense Linepm_project_task373,667.5313,596.60Only includes time cards processed since migration.
Cost PlanN/A1,342,126.21398,900.22 
Cost Plan BreakdownRequirement1,342,126.21398,900.22 
Cost Plan BreakdownTask1,485,491.77167,174.75See below for variance details

 

When you compare the 'Task' and 'Requirement' totals by Fiscal Month, the 'Task' totals vary for M07. I know we had to recall and process a lot of time-sheets that month, due to some Rate Model gaps.

DavidBADT_0-1726068083725.png

 

Any one know how we can fix M07? Alternately, does anyone know the Business Rule creating the 'Task' breakdown line? I need to look at it and figure out a) when it's invoked, and b) how/where it's getting it's numbers from.

 

Any other ideas/solutions would be welcome! I haven't tried it, but maybe a Flow/Script to update the task entries might be possible, since you can't manually update these records.

Edit: realized I had a copy-paste error on my 'task' level fiscal periods

1 REPLY 1

DavidB-ADT
Tera Guru

Staring at that giant negative Opex number, I've just had an epiphany!

 

We recently realized that there's a weird gap in the Timecard Recall functionality of SPM, in that it doesn't look at either the Cost Plan or Cost Type associated with the original expense line it's reversing. So when we recalled a number of time cards to correct Rate Model gaps, the recall reversing expense lines didn't match i.e. A capex expense line was reversed with an opex expense line.

 

We made a flow to go and correct all those recall expense lines to match their original entry's cost type. But, my flow never 'reprocessed' the expense lines. Going to make a Flow to reprocess all recalled expense lines, and see what that does.

 

Edit: Reprocessing the recalled expense lines definitely helped, but I still have a capex variance. I think I'm just going to reprocess all expense lines for M07, and hopefully that'll get things back in sync.

DavidBADT_0-1726071330055.png

 

Edit 2: Reprocessed all expense line and have come to a new realization - my weird variance is on the 'Requirement' side, as my 'Task' amounts now match my expense lines:

DavidBADT_0-1726080201528.png

 

The mystery continues...