How can we define billing rate of a resource in rate model in SPM ?

[Khushboo8]

We currently have field to define cost hourly rate of a resource in rate model. How can we define billing rate in rate model and use it for the calculations in Project and Project Task?

When we click on Rate lines in Rate model these are the fields we get ( shown in ss below)

How can we add and implement Billed cost of resource here?

[anand-bhosle]

Hi @Khushboo8 

You can extend your existing rate model by adding a “Billing” rate type (or a separate u_billing_rate field) to each rate line, putting it on the rate model form, and entering your customer-facing rate alongside the cost rate. Then add new “Planned Revenue” fields on Project and Project Task and update your Business Rules (or a Script Include) to pull the correct billing rate (just like you do for cost), multiply it by planned or actual hours, and write the results into those fields. Finally, roll those task-level revenues up to the parent Project, add the new fields to your forms and reports, and you’ll have real-time visibility into both your cost and what you bill.

Hope this helps. 

If my response helped, please mark it correct and close the thread so that it benefits future readers.

Thanks

Anand

[Khushboo8]

Thanks for answering this but we are not able  to find where exactly field needs to be added on Rate Lines in Rate Model.
When we click on View Rate Lines  on Rate Model in below screenshot  we get a UI page/UI macro

Ui Page screenshot on click of related link:

We are not able to find this UI page in servicenow OOB scripts

On Click of New Button in this UI page the following page opens:

Hence we are not sure how the billed rate will appear at all these places, Could you please help with the same?

[anand-bhosle]

• Extend the Rate Line table, field =Rate Type, Add New choice like Billing
• Separate field is optional. If you’d rather keep cost and billing in two fields instead of re-using Cost per Hour, then on "pm_rate_line" table create Billing Rate decimal field type.
• Add the field to Rate model form [From Project > Setup > Rate Models, open your Rate Model]
• By default ServiceNow only looks at Cost per Hour for its “planned cost” logic. You’ll need a small customization to also calculate a “planned revenue” (or “billed cost”) field on your projects/tasks
• On Project (pm_project) and Project Task (pm_project_task), add:
  

  • u_planned_revenue (Decimal)

  • u_revenue_to_date (Decimal)

• Try Before Business rule on "pm_project_task" [Sample code attached in the screen shot]

• Replace current.isBillingFieldDefined() with whatever check you need to pick u_billing_rate vs cost_per_hour.
  Hope this helps. 

Thanks

[Khushboo8]

We added Billing rate on Rate Model form but still we are not able to view  the field neither in the UI Page  which appears on click of Related link -- 'View rate lines'  on Rate Model, nor on clicking the New Button:

Hence, we are not able to input a value in this field