Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Set up: Volume based p...
Microsoft Dynamics CRM (Archived)

Set up: Volume based pricing for products

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Good morning,

I am working with a client who needs to set up volume based pricing for products on quantity with a graduated price per unit. For example:

A 11-25 MFE Complete EP Threat Protect P:1BZ[P+] 139.86
B 26-50 MFE Complete EP Threat Protect P:1BZ[P+] 113.28
C 51-100 MFE Complete EP Threat Protect P:1BZ[P+] 111.90
D 101-250 MFE Complete EP Threat Protect P:1BZ[P+] 97.90
E 251-500 MFE Complete EP Threat Protect P:1BZ[P+] 95.11
F 501-1000 MFE Complete EP Threat Protect P:1BZ[P+] 86.71
G 1001-2000 MFE Complete EP Threat Protect P:1BZ[P+] 81.12
H 2001-5000 MFE Complete EP Threat Protect P:1BZ[P+] 57.34
I 5001-10000 MFE Complete EP Threat Protect P:1BZ[P+] 50.36
J 10001-+ MFE Complete EP Threat Protect P:1BZ[P+] 46.15

OOB it looks like I have to create each product by quantity with its corresponding unit cost. Ideally we would want to pick the product, enter the quantity, and have the system determine the price per unit. 

Have you seen this before and what was your solution?

Drew

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Set up: Volume based pricing for products

    Ah, ok.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Set up: Volume based pricing for products

    I'm not doing bulk or lot products ergo discount list won't work. For example. I need to order 90 widgets. I have a graduated pricing model that says for quantity between 80 to 100 the price per unit should be $100. 101-120 the price should be $90 per unit. The quantity of the product determines the price per unit.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Set up: Volume based pricing for products

    Why don‘t you use standard functionality called Discount List?

    Settings -> Product Catalog -> Discount Lists

    [View:https://www.microsoft.com/en-us/dynamics/crm-customer-center/set-up-a-discount-list.aspx]

  • Suggested answer
    Jeevarajan Kumar Profile Picture
    Jeevarajan Kumar 747 Most Valuable Professional on at
    RE: Set up: Volume based pricing for products

    Hi Drew,

    I have been checking out if I can achieve this in Workflow to trigger on change of the 'Quantity' field. Was trying to achieve it using the 'Workflow Elements' developed by Aiden.

    Tried with 'Sales-Add Line Item'  but it isn't working, I guess I'm missing something, let's just ask Aiden's help on this. He should be able to guide us better.

    Aiden Kaskela: Any help on this would be much appreciated.

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Set up: Volume based pricing for products

    Thanks for your reply. You confirmed my assumption. I just need to check that there isn't an ISV solution before we bring the dev in-house

  • Suggested answer
    Jeevarajan Kumar Profile Picture
    Jeevarajan Kumar 747 Most Valuable Professional on at
    RE: Set up: Volume based pricing for products

    Hi Drew Climer,

    This functionality can be achieved only by developing a plug-in. 

    You need to write a Plugin on QuoteLineDetail/OrderLine/InvoiceLineDetail on post create/update, you can read the product, quantity and other required values and update the amount in the code. It looks something like this,

    By design, the line item entities are not available in Workflow, so it is not the option here.

    If you don't' want to change the qty, you can have multiple PriceListItems like the below and handle it.

    2017_2D00_10_2D00_12-20_5F00_55_5F00_48_2D00_Order_5F00_-Order-for-Customer-A.png

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans