web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Product Family & P...
Service | Customer Service, Contact Center, Fie...
Answered

Product Family & Price Lists - Determine sales price by product family

(0) ShareShare
ReportReport
Posted on by EmilFSM 5

HI All,

I'm fairly new to working with price lists and have a question regarding pricelist and product family.

We want the ability to sell a product to a price, which is specified on the parent product family.

So, as an example - we have two customers: Customer A, Customer B.

Both customers buy the product "Product A", which is part of "Family A" - but we want the ability to sell the product with two different prices (% of price).

Now, normally we would have to setup a Price List Item on Product A - but in the actual case we have 1000 different products in "Family A". We want to give the same agreed discount on all products in same family. Is this possible?

I have the same question (0)
  • Suggested answer
    Shawnsauve Profile Picture
    Shawnsauve 1,093 on at
    RE: Product Family & Price Lists - Determine sales price by product family

    It is definitely possible to sell a product at a specified price that is set at the parent product family level. One way to achieve this would be to set up a Price List that is specific to the product family (Family A in your example), and then create Price List Items for each product within that family.

    To simplify the process, you can use the "Apply Discount to Product Family" feature in Dynamics 365, which allows you to apply the same discount percentage to all products within a product family. This way, you won't need to create individual Price List Items for each product, which would be very time-consuming and inefficient.

    To set this up, you can navigate to the "Price Lists" section in Dynamics 365, and create a new Price List that is specific to Family A. Then, select the "Apply Discount to Product Family" option and specify the discount percentage that you want to offer. This will apply the same discount to all products within Family A.

    Keep in mind that this method will only work if you want to offer the same discount percentage to all products within a product family. If you need to offer different discounts for different products within the same family, you will need to create individual Price List Items for each product.

  • EmilFSM Profile Picture
    EmilFSM 5 on at
    RE: Product Family & Price Lists - Determine sales price by product family

    Hi Haig Liu,

    Thanks for your detailed response.

    As I understand, and what also makes sense is that this is more a BC feature rather than FSM.

    I will figure out a way to solve this for my customer request.

    Thanks!

  • Verified answer
    Haig Liu Profile Picture
    Haig Liu Microsoft Employee on at
    RE: Product Family & Price Lists - Determine sales price by product family

    Hi EmilFSM,

    1.Product families are used to categorize products and discounts cannot be applied to them.

    You can use percentage discounts when adding price list items or when creating an order.

    The difference is that the former can be used for different price lists for the same product, while the latter can only be used for all products in an entire order.

    In addition, Field Service does not currently support discount list price list items. You can configure discounts directly on work order products and services:

    https://learn.microsoft.com/en-us/dynamics365/field-service/create-price-list

    2.Discounts for customers are also available only with manual discounts (not percentages): 

    https://community.dynamics.com/365/sales/f/dynamics-365-for-sales-forum/391712/discounts-by-customer-in-dynamics-365-for-sales

    1000 products is not a problem, it is a process that can be done in bulk:

    https://learn.microsoft.com/en-us/dynamics365/sales/add-products-qoi-enhanced

    3.Finally, I think the features that best meet your requirements exist in Business Central:

    https://learn.microsoft.com/en-us/training/modules/customer-discounts-dynamics-365-business-central/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 72

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 28 Super User 2025 Season 2

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 17 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans