Understanding Microsoft Dynamics PSA Data: Blog 5: Price List

Microsoft Dynamics CRM PSA Price Lists are used for both products and projects in Dynamics 365. Price List define charges for a product or service. Multiple price lists can exist so that you can maintain separate price structures for different regions you sell your products or services in, or for different sales channels.

Example PSA Price Lists

Price Lists are created for Sale and Cost price.

The importance of Price Lists in PSA

• • Cost and Sales Price Lists are required in PSA to calculate Project estimations for the cost of a Project to an Organisation and calculating the expected revenue of a Project and any Products sold.
  • Cost price lists define the costs of resources based on their role and their organizational unit.
  • A Sales Price List is used to hold the prices that will be charged to customers for all project related activity plus any of the ‘tangible’ products that can be purchased e.g. Dynamics 365 Enterprise License.
  • Therefore, your Cost Price List will calculate the ‘Estimates’ section below and the ‘Estimated Cost’ of the project. Your Sales Price List will calculate ‘Actuals’ when Resources submit time to the project and the customer is invoiced.
  • A customer could have a specific Sales Price List which you can assign exclusively to projects where they are the customer. PSA will then calculate the Sales Price of the Project in relation to the specific prices that customer receives i.e. if you have a Price List for Active Transport whereby a Project Manager is charged out a £100 an hour but your generic UK Sales Price List has a Project Manager charged out at £120, you would assign the Active Transport Sales Price List to their project and if a Project Manager is used on the project, Active Transport would be charged £100.

Technical Details

• Microsoft recommend setting up price lists for each organisational unit
• Schema name – bookableresourcecategory
• For example, for eBECS UK there would be:
  • eBECS UK Cost Rates
  • eBECS UK Bill Rates
• Price lists are used as headers for the price list items (explained below) where you will define the daily bill rate of a role
• Currency, Module and especially Time Unit fields are of importance here
• Important: if you are already using CRM/Dynamics 365 without PSA and are utilising the Product Catalogue, it is important to be aware that when PSA is installed and the Price List form changes over to the PSA form, the Currency and Unit fields will be locked on your existing Price Lists. This may mean existing Price Lists may need to be deactivated and new ones, which will in turn impact any open opportunities/quotes in the system.