Hack #20: Understanding PRICE LISTS in D365 Project Operations- Part Two

Applies To: Project Operations for resource/non-stocked based scenarios, and Lite deployment – deal to proforma invoicing

In the last blog post, here we talked about the concept of price lists.

Now let’s discuss Sales Price Lists in more detail. If you stop to consider, sales price lists are indispensable, since some organizations that use Dynamics 365 Project Operations may not use the cost function, sales normally is a must. The expection would be if you only use the tool for internal projects that are not billable and in that case you only wish to track your costs!

By visiting the Sales Price Lists, the interface presentes us with a few tabs.

The process makes users navigate from left to right by populating the necessary information as the situation requires:

Let’s look at the tabs and what they do!

In General you populate the basics of your price list, such as: name, is it sales or cost, currency, and time unit. You must consider if you will use the Start and End Dates and enable this in the ‘default’ parameters before you utilize them. The rest of the set up is fairly simple:

In Role Prices, this is where you set the Labour Rates for every Role involved in the organization. Important to double check before utilizing in real projects:

Microsoft documentation for more details: https://learn.microsoft.com/en-us/dynamics365/project-operations/pro/pricing-costing/set-up-labor-bill-rate-sales

For Category Prices (aka: Expense categories), you set how expenses are charged against projects by utilizing three methods, named: Price per unit, At cost, and Markup percentage:

Microsoft documentation for more details: https://learn.microsoft.com/en-us/dynamics365/project-operations/pricing-costing/set-up-cost-sales-rates-expenses

Here’s a nice breakdown 😊 of the pricing methods to help choose between them:

*Breakdown of Transaction Category Price setup*

For Price List Items (aka: Product Prices), you define what the prices (cost or sales) are for products you sell. These can be bottles of water or licenses:

Note: It is important to define the products first before setting the price lists with them.

Detailed use of each tab:

To help us navigate this more, I consolidated the tabs information below. Note that I did not cover ~~Role Price Markup~~ nor ~~Territory Relantionships~~. These are used in specific scenarios or with Dynamics 365 Field Service module.