Customize UI Page $pmview by replacing Expense Type column with a custom field created in cost plan

avohra68
Tera Contributor

 

I have created a custom field on cost_plan and wanted to modify the UI page $pmview to replace Expense Type with this new field. I am not sure if this is doable and where it needs to be modified.

 

And when comparing to baseline

find_real_file.png

 

Any help would be appreciated.

1 ACCEPTED SOLUTION

Miguel Donayre
ServiceNow Employee
ServiceNow Employee

Hello @avohra68,

Follow these steps - 

Go to Project--> Settings--> Planning Console

On the Planning Console list view go to the "Context: Project/Demand Financials"

Click on Project

find_real_file.png

On the new form that it opens up, click on the new button" Here you will need to add the new custom column you created. In the JSON field, it has to match exactly to what the column name is.  For this example, I create a custom field called Test Planned console - u_test_plannng_console. Save it.

find_real_file.png

 

find_real_file.png

 

Let's go back to the Planning console Project form(where you clicked the new button)

This is where you can hide fields and change the order it appears in the Planning console. 

find_real_file.png

 

find_real_file.png

View solution in original post

8 REPLIES 8

Miguel Donayre
ServiceNow Employee
ServiceNow Employee

Hello @avohra68,

Follow these steps - 

Go to Project--> Settings--> Planning Console

On the Planning Console list view go to the "Context: Project/Demand Financials"

Click on Project

find_real_file.png

On the new form that it opens up, click on the new button" Here you will need to add the new custom column you created. In the JSON field, it has to match exactly to what the column name is.  For this example, I create a custom field called Test Planned console - u_test_plannng_console. Save it.

find_real_file.png

 

find_real_file.png

 

Let's go back to the Planning console Project form(where you clicked the new button)

This is where you can hide fields and change the order it appears in the Planning console. 

find_real_file.png

 

find_real_file.png

avohra68
Tera Contributor

Thanks Miguel - I was able to add the custom column Charge Code but was not able to hide Expense Type

find_real_file.png

 

Also when I do a compare with baseline the custom column does not show up. Is there another configuration to be done somewhere.

find_real_file.png

 

For the Expense Type - Have you tried removing it from the Configuration option?

find_real_file.png

 

For the baseline value. Is your custom value being capture when the baseline is created? Check to see if it is being captured with the baseline is taken. 

avohra68
Tera Contributor

So I was able to hide Expense Type - Thanks.

With regards to custom value - that field is blank in cost_plan_baseline table if I use ui action 'Create Baseline' 

But would that stop it from showing the column (not just the value) in the compare?