Processing - Sales Price Updates - Update Prices from Template Journal
The Update Prices from Template Journal is used to update sales prices from the template journal. Select the current version of a Template to Update Resources Prices created with the previous version of the Template and add new information in the Template. The process allows users to change a template and then update all project price lists with that template.
To update sales prices for resources:
Navigate to the Role Center and select Processing > Sales Price Updates > Update Prices from Template Journal.
Select Load Price List Updates to load resource sales price records related to a template into the journal and loads them into the grid, based on the template.
Template Code: Specifies the sales price template code related to this line.
Tip
For more information on setting up a sales price template see: Sales Price Templates
Update Action: Specifies the action which will be taken during the apply updates process. Options include: Add or Delete.
- The process works as follows:
- For each line displayed in the price list that originated from the selected template:
- Delete will delete the templated lines within the date range.
- Add will add the new lines from the template within the date range.
- Price Lists are updated from template (all fields).
- Does not affect closed projects.
- If you add a line to the Sales Price Template, the Unit of Measure Code is required.
- For each line displayed in the price list that originated from the selected template:
- The process works as follows:
Start Date: Specifies the current effective date of this line.
Project No.: Specifies the project related to this line.
Task Code: Specifies the project task related to this line.
Work Type Code: Specifies the work type related to this line.
Currency Code: Specifies the currency related to this line.
Type: Specifies the type of code for this line. Default value: Resource
Code: Specifies the code related to this line.
Resource Group No.: Specifies the resource group related to this line.
Unit of Measure Code: Specifies the unit of measure related to this line (this field is required to be completed if you are adding a new line).
Profit Calculation: Specifies the profit calculation option.
Price: Specifies the fixed price.
Percentage: Specifies the profit percentage to use when calculating price.
Profit Amount: Specifies the profit amount to use when calculating price.
Chargeability: Specifies the chargeability option.
OT Factor: Specifies the factor to multiply price by to get the OT Price Rate.
OT2 Factor: Specifies the factor to multiply price by to get the OT2 Price Rate
Once the new sales prices are entered in the grid, use the following options to run the update:
Load Price List Updates: Run the Load Price List Updates process to load resource sales price records related to a template into the journal and update them based on the template.
Apply Price Updates: Apply price updates to the resource price list.
Important
Filters for the Sales Price Template must exactly match the filters for Resource Prices