Issue regarding Budget cost not matching into the Project table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2022 01:48 PM
Hello ,
I am facing one issue into the project table where the "Budget Cost" in the financial tab is showing a value "XXXXXXXX" and in the related list "Project Budget" it's showing some other value "XXXXXXX".
Although both the values should have been same. Can someone help me into this why it is showing different values and how can both the values be matched.
Additional info: Project Budget values is coming from "project_funding" table by doing the summation of capital budget +operational budget.
And same should also reflect into the Project budget field but its showing different value.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2022 04:28 AM
Hey!
Go to cost_plan_breakdown table and check for "task" type breakdowns which belongs to that project.
And get sum up the budget value year wise. And compare it with Project funding record value. Please note that when project funding records are updated, the Operating budget and Capital budget will be captured in Cost plan breakdowns of type Task, across the fiscal months. And differentiated by expense types.
Also Check that there is no duplicate task type breakdown present with same expense type for a Month. If duplicate task type breakdowns are present for a month, budget will not be rolled up correctly. Duplicate breakdown need to be deleted.
Also check for any particular fiscal year cost plan amount is negative. Even if Capex or Opex cost plan sum is negative for an year, budget will not be rolled up correctly according to the expense type.
Support KA: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0951676
Hope it will help you.
Thanks
Nootan