Cost Break Down Calculation

sukran
Mega Sage

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 ?

find_real_file.png

1 ACCEPTED SOLUTION

@Sukran  - You fiscal period for above screenshot seems to be 20 months

 

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

 

If you found my response helpful or applicable, please consider marking it as correct or helpful to assist others who may be seeking the same information.

---------------
Regards,
Rajesh Singh

View solution in original post

8 REPLIES 8

@Rajesh Singh  Any Help would be appreciated

@Sukran  - You fiscal period for above screenshot seems to be 20 months

 

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

 

If you found my response helpful or applicable, please consider marking it as correct or helpful to assist others who may be seeking the same information.

---------------
Regards,
Rajesh Singh

@Rajesh Singh Great , Thank you for help

Its helps a lot

priyakadam
Tera Contributor

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!!