Issue with Actual Cost rollup at Project Level
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2024 08:14 AM - edited 09-11-2024 08:26 AM
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:
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.
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:
Table | Source Table / Breakdown Type | Capex | Opex | Comments |
Expense Line | pm_project | 1,341,720.21 | 398,900.22 | Capex variance of $405.98 on system generated cost plans (expense line amount vs cost plan actual). No idea how/why. |
Expense Line | pm_project_task | 373,667.53 | 13,596.60 | Only includes time cards processed since migration. |
Cost Plan | N/A | 1,342,126.21 | 398,900.22 | |
Cost Plan Breakdown | Requirement | 1,342,126.21 | 398,900.22 | |
Cost Plan Breakdown | Task | 1,485,491.77 | 167,174.75 | See 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.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2024 08:36 AM - edited 09-11-2024 11:43 AM
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.
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:
The mystery continues...