Cost Plan's field "Total actual cost" doesnt update

Dario_C
Mega Sage

Hi everyone!

I have a problem with a field on the Cost Plan. The field 'Total Actual Cost (actual_cost_default_currency)' doesn't update with the total amount of the related Expense Line. The value remains at 0. I don't understand why. How does this field work?"

Dario_C_0-1699978054693.png

Thank you in advance

 
11 REPLIES 11

yogesh41
ServiceNow Employee
ServiceNow Employee

Hi Dario,

 

Have you imported the expense lines with state as "Processed" ? In such scenario Expense Line Processing won't get triggered so Total Actuals Cost doesn't get updated. 

For quick test, please create new Expense Lines for respective Cost Plan in "Pending" state, then update state to Processed. The Total Actuals Cost on Cost Plan is expected to get updated Expense Lines amount. 

 

Yogesh

 

Dear @yogesh41 ,

thank your for your answer ! 

I have done this test as you instructed, and yes, if I create a new Expense Line in the pending state and then update the state to processed, the total actual cost will be updated !" (so it worked)

So, if I create an Expense Line in the Processed State, will that one not update the total actual cost field? Is this the problem?"

yogesh41
ServiceNow Employee
ServiceNow Employee

Hey Dario,

 

The Business Rule of aggregating Expense Lines amount only get triggered when the state of Expense Line changes to "Processed". 

 

Yogesh

The Business Rule is on Cost Plan [cost_plan] trable or Expense Line [fm_expense_line] ?

 

Thanks in advance.

yogesh41
ServiceNow Employee
ServiceNow Employee

The Business Rule is on Expense Line table.

 

Yogesh