- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2022 12:39 AM
How Cost plan related Cost break downs are calculated ?
One user reported that , Cost plan of FY22 all months break down "Entered cost and functional cost" updated automatically
Where its get updated ? where calculates the value ?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2022 01:08 AM
Calculation logic of Total planned cost
Now you manually enter Unit cost and quanitty
Servicenow will automatically calculate Total planned cost as Unit cost*quanitity = 25000*1 = 25000
Calculation logic of Entered cost
Now the on cost plan breakdown's entered cost is calculated as Total Planned cost/Fiscal period (in months)
= 25000/20 = 1250
ts gets updated at at : cost_plan_breakdown table.
Functional cost uses Exchange rate is used to convert entered cost into functional cost. It is obtained from the itfm_fx_rate [budget_reference_rates] table.
Please let me know if this clarifies.
Thank you!
Rajesh
---------------
Regards,
Rajesh Singh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2022 12:43 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2022 01:08 AM
Calculation logic of Total planned cost
Now you manually enter Unit cost and quanitty
Servicenow will automatically calculate Total planned cost as Unit cost*quanitity = 25000*1 = 25000
Calculation logic of Entered cost
Now the on cost plan breakdown's entered cost is calculated as Total Planned cost/Fiscal period (in months)
= 25000/20 = 1250
ts gets updated at at : cost_plan_breakdown table.
Functional cost uses Exchange rate is used to convert entered cost into functional cost. It is obtained from the itfm_fx_rate [budget_reference_rates] table.
Please let me know if this clarifies.
Thank you!
Rajesh
---------------
Regards,
Rajesh Singh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2022 08:20 AM
Its helps a lot
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2024 04:16 AM
Hello @Rajesh_Singh ,
Even i am facing similar issue.
We have requirement to create Expense line in Project with some conditions. I have implemented same with transform script onStart and it’s working fine.
There is 1 more requirement that End Fiscal period of cost plan should be same as start Fiscal period of that project.
Issue is when Expense line is created with script the End Fiscal period of cost plan is getting updated with current fiscal period.
For example, if start Fiscal period and end Fiscal period of cost plan is “FY23: M01-Jan” before expense line is created with script , it gets update with current fiscal period i.e. “FY24: M03-Mar” after script is completed.
So, when I am trying to update End Fiscal period of cost plan after script is completed it’s not getting updated and not sure why cost plan breakdown is getting break in months till current fiscal period.
Thanks in advance!!