There is a setting in Inspire Planner that will automatically populate Cost for all Project Tasks based on Effort and the Resource's Rate.
When this setting is enabled, then Inspire Planner populates the following:
The Hourly Rate used to calculated Budgeted and Actual Cost is the Hourly Rate on the Salesforce Task. The Hourly Rate on the Salesforce Task is populated with the Hourly Rate from the Resource when the task is assigned. If you populate the Resource's Hourly Rate after the Task has already been assigned, then the Hourly Rate on the Salesforce Task would be blank. You will then need to perform a data update on Salesforce Tasks to populate the Hourly Rate. Do this first before you perform the steps outlined below.
Helpful Tip: To mass update Salesforce Tasks, you can create a report that pulls Salesforce Tasks where the Inspire Task field is not blank and where Hourly Rate is blank. Export the report as a .CSV file. Then you can edit the file in Excel to contain the missing Hourly Rates. You can then perform a data update with the modified .CSV file using Data Loader.
This help article will walk you through how to enable the "Use Effort to Calculate Cost" setting.Please note: The following instructions need to be performed by a Salesforce System Administrator.
This section will walk you through how to enable the setting to use effort to calculate cost.
Once the setting is enabled, it will start to populate your Cost fields based on Effort and Hourly Rate for new entries. In order for the Cost fields to recalculate and populate for existing data, you will need to reconcile data.