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:

General tab setup

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:

Role Prices set up

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:

The set up of category prices

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:

Products Price List

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.

Microsoft official documentation: https://learn.microsoft.com/en-us/dynamics365/project-operations/pricing-costing/price-list-setup

I hope you found this information helpfull and I’ll see you next time.

Thank you!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s