Tuesday 13 January 2015

Pricing Method in Microsoft Dynamics CRM Product Catalog All in 1 Explanation

When we want to sell the Product in CRM, we offer the Product and the Salesperson will input their offers in the Opportunity Product Line or Quote Product Line before becoming Order and Invoice.

Of course every Product has its own Price, now, how to link it back to the Opportunity Product Line.

Let’s say Marketing or Product Team has defined the Prvaluoduct Pricing, is there any impact in the Sales Processing?

We are expecting that the Salesperson will not be confused and should sell the Product within the expected range analyzed before by the expert Product Catalog Team and Marketing.

The Product Catalog setting will affect the Opportunity Product default Selling Price Thus, we need to understand first, what is the expectations of the Price and Product Master in hoping their salesperson can sell within the amount with good and profitable selling Price. Price List will become the Guide for salesperson to explore and approach the customer and offer them with price that are mutualism, means that all sides are happy, the Product Team, Marketing Team, Sales Team, and also the Customers.

So, the Pricing is very important in the Sales Process Automation.

Mapping the Business Process Pricing to the CRM Pricing Method is not easy unless you understand how it works and how it will affect the CRM Sales Process.

Now, in this post will mainly explain about how the Pricing Method will affect the basic/default Selling Price in the Sales Process and how important to understand it. It would help the Organization to determine the price either by specific amount, expected margin, and suitable profit markup.

Let’s begin reading this post…

Basically, there are 6 methods of pricing in CRM:

image
  1. Currency Amount
  2. Percent of List
  3. Percent Markup – Current Cost
  4. Percent Margin – Current Cost
  5. Percent Markup – Standard Cost
  6. Percent Margin – Standard Cost
We will go through one by one, before that let’s we configure the Product Master record here:

Product Master List Price, Current Cost, and Standard Cost

image

The definition of Current Cost and Standard Cost are based on your own Organization Pricing and Costing.

So my pricing and costing:

Type         Value ($)
List Price899
Current Cost599
Standard Cost549

And then we define the Price List Item here, based on each criteria and let’s see how it works and affect the Opportunity Product (and also Quote Product).

There are two type of pricing, Default or User Provided. Here, we will focus on the Default, eventhough you can change the price later if you choose the “User Provided” type, but by default, CRM will give you a default Price per Unit.

Basically the default Price per Unit of each Opportunity Product will follow the rules:

1. Combination of the Price List (defined in the Opportunity header), the Product itself, and the Unit.
This combination will find the correct Price List Item and get the pricing.

2. If the product does not exist in the Price List defined in the Opportunity then CRM will give price per unit based on the Product default Price List. To know more about Default Price List, please check this link out.

http://missdynamicscrm.blogspot.com/2014/07/10-facts-about-default-price-list-in-CRM2011-2013-that-you-might-not-have-noticed.html

3. If the product does not exist in any price list and does not have the Default Price List, CRM will give 0 value and will cause warning and error, this is to let you know how important the Price List in the CRM Sales process if you want to implement the out of the box CRM sales pricing.

Currency Amount

I will give the $888 with Pricing Method = Currency Amount


image

As you can see the Price Per Unit is not other than $888.00.

We’ve learned how the Currency Amount as one of the CRM pricing method works.
Currency Amount will give exactly the same value from the Amount defined in the respective Product Price List Item

Percent of List

I will set the Pricing Method = Percent of List with Percentage 50 and the Rounding Policy set to None.

image

There will be no amount can be set after you change the Pricing Method to Percent of List, instead, you can only set the Percentage from the base you set as the Product List Price.

As we remember, we have defined the List Price before to $899 Value, it will be the base price.

See the result here:

image

So now it means that the price will be $449.50 was coming from 50% * 899 = 449.50

What if I want to sell higher?

Just put more than 100% like I did here..

image

Percent Markup vs. Percent Margin

What is the difference between Markup and Margin?

Markup and Margin have different calculation, based on this reference, here is the understanding between those two terms:
Margin
The percentage margin is the percentage of the final selling price that is profit.
Markup
A markup is what percentage of the cost price do you add on to get the selling price.
These are different, a selling price with a margin of 25% results in more profit than a selling price with a markup of 25%.

In a merchant situation it is probably better to work with margins. This means you can know what percentage of our total income is profit.

How to Calculate Selling Price based on Markup?
Selling Price = (Cost X Markup /100) + Cost
How to Calculate Selling Price based on Margin?
Selling Price = Cost/((100-Margin)/100)
Thankfully there is a quicker way to work it out.
For a five percent margin, divide the cost price by 0.95.
For a ten percent margin, divide the cost price by 0.9.
For a fifteen percent margin, divide the cost price by 0.85.
For a twenty percent margin, divide the cost price by 0.8.
For a twenty-five percent margin, divide the cost price by 0.75.
For a thirty percent margin, divide the cost price by 0.7.
..and so on…
For a fifty percent margin, divide the cost price by 0.5.

Percent Markup – Current Cost

Now, how about Percent Markup based on Current Cost? Remember the above formula, you will get the Selling Price.

I will set the Pricing Method = Percent Markup – Current Cost with Percentage 50 and the Rounding Policy set to None.

image

Same as the previous one, Percent List, you can only set based on percentage, the amount will be calculated automatically based on the Current Cost.

As we remember, we have defined the Current Cost before to $599 Value, it will be the base price.

See the result here:

image
Selling Price = (Cost X Markup /100)+ Cost

Percent Margin – Current Cost

Now, we are still using the Current Cost, but we want to sell based on Margin.

I will set the Pricing Method = Percent Margin – Current Cost with Percentage 50 and the Rounding Policy set to None.

SNAGHTMLd5389f1

Same as the previous one, Percent List, you can only set based on percentage, the amount will be calculated automatically based on the Current Cost.

As we remember, we have defined the Current Cost before to $599 Value, it will be the base price.

See the result here:

image
Selling Price = Cost/((100-Margin)/100)
For a fifty percent margin, divide the cost price by 0.5.

Percent Markup – Standard Cost

Same as the previous example for the Current Cost, but now, the base is the Standard Cost.

I will set the Pricing Method = Percent Markup – Standard Cost with Percentage 25 and the Rounding Policy set to None.

image

Same as the previous one, Percent List, you can only set based on percentage, the amount will be calculated automatically based on the Standard Cost.

As we remember, we have defined the Standard Cost before to $549 Value, it will be the base price.

See the result here:

image
Selling Price = (Cost X Markup /100)+ Cost

Percent Margin – Standard Cost

Same as the previous example for the Current Cost, but now, the base is the Standard Cost.

Now, we are still using the Standard Cost, but we want to sell based on Margin.

I will set the Pricing Method = Percent Margin – Standard Cost with Percentage 25 and the Rounding Policy set to None.

image

Same as the previous one, Percent List, you can only set based on percentage, the amount will be calculated automatically based on the Current Cost.

As we remember, we have defined the Current Cost before to $599 Value, it will be the base price.

See the result here:

image
Selling Price = Cost/((100-Margin)/100)
For a twenty-five percent margin, divide the cost price by 0.75
I hope you enjoy this post and make it as reference in the future!

Thank you…Enjoy..

58 comments:

  1. Great! Very informative! Thanks a lot.

    ReplyDelete
  2. Are these formulas or Markup and Margin universal ???

    ReplyDelete
  3. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Microsoft CRM, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Microsoft CRM. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    MaxMunus
    E-mail: nitesh@maxmunus.com
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023
    http://www.maxmunus.com/



    ReplyDelete
  4. Hello Aileen,

    Great article there. I am trying to add a custom field called Margin % which gets calculated and added to the total amount at the Opportunity, Quote or Order level.

    ReplyDelete
    Replies
    1. I have just done this for a client, overall it was straight forward to complete

      Delete
  5. Hi! Great article, I had no idea it worked this way, so thank you for explaining it so well. I can't wait for my dynamics 365 implementation to happen very soon, I'm way too excited ;)
    Cheers!

    ReplyDelete
  6. Hi,
    Let say I have a product A with default price list P and current cost 100$, having pricing method "percent margin of current cost" .When I choose this existing product A in opportunity product the price per unit comes equal to zero and when I open opportunity product record I get a notification showing "Following error has occured: "?

    ReplyDelete
  7. Has anyone ever found a way to do 'Waterfall' price lists in Dynamics?

    ReplyDelete
  8. If you are searching Magento Product Data Entry Services Provider Company. Now Your Search end Here 123eData.com Providing this service. Amazom is one of the few big fishes that continue to rule the online retail world despite the huge ups and down in the market. They are one success story that is worth investing. Today Amazon has gone global and if you wish your Ecommerce Product Data Entry Services

    ReplyDelete
  9. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in MICROSOFT DYNAMICS CRM kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on MICROSOFT DYNAMICS CRM We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Saurabh Srivastava
    MaxMunus
    E-mail: saurabh@maxmunus.com
    Skype id: saurabhmaxmunus
    Ph:+91 8553576305 / 080 - 41103383
    http://www.maxmunus.com/

    ReplyDelete
  10. If anyone looking technical support for HP Customer Service
    Canon Printer Support
    AOL Customer Service
    Outlook Support
    Microsoft Technical Support
    Quickbooks Customer Serviceetc Just dial our toll free Support Number 1866-376-9956 and get instant solutions.

    ReplyDelete
  11. Wow! Great post! The content is very rich, and I really like it. It help me very much to solve some problems. It is very helpful for all the people on the web. Thanks a lot. MS Dynamics Ax Solution

    ReplyDelete
  12. India eData Solutions provides Ecommerce Image Processing Services, Ecommerce Products Updating Services, 3Ecommerce Image Processing Services for E-commerce Industry at lowest rates in all over world. we have expert team for Outsource 3dCart product listing Project.

    ReplyDelete
  13. Magento is one of the most popular eCommerce platform, customizable shopping cart platforms available. If you have chosen Magento as your eCommerce platform (WebSite), Acelerar can offer you end-to-end support with our efficient and streamlined Magento Product Data Entry Services at the most economical rates and 24x7 Support. Our Experts have a wealth of experience working on Magento Product Upload Services on eCommerce platform.

    ReplyDelete
  14. Thank You so much for sharing this with us, this blog is really helpful for Microsoft CRM developer.. Please keep sharing your blogs for us.

    ReplyDelete
  15. If you are looking for a best customer relation management software than look no further because Microsoft dynamic CRM is best in all of them

    ReplyDelete
  16. Hi...
    Thanks for Nice post!! ANy Problem With Microsoft Outlook Issues PLease Reach us at.
    Microsoft Outlook Support UK , Microsoft Phone Number

    ReplyDelete
  17. Intelepos offering business solution.
    EPOS system for your shop
    EPOS system for your Restaurants
    EPOS system for your Bakery
    EPOS system for your Takeaway
    EPOS system for your retail store
    intelepos.com
    Website: https://intelepos.com/takeaways
    Email: info@intelepos.com
    Contact No: 0330 1134 157

    ReplyDelete
  18. Online Catalog Software or Flipbook software in 2019 is now playing an important role behind the popularity of the digital publications, be it digital magazines or digital newspapers.

    ReplyDelete
  19. Catalog Printingcatalogue printing in gurgaon at Abhiprint- We offer Catalogue Design & printing services. Our catalogue designer in Delhi provides creative Product catalogue design.Catalog Printing Services, Catalog Printing Providers in India.Online catalogue printing services in India.

    ReplyDelete
  20. Catalog Printingprodut catalogue at Abhiprint- We offer Catalogue Design & printing services. Our catalogue designer in Delhi provides creative Product catalogue design.Catalog Printing Services, Catalog Printing Providers in India.Online catalogue printing services in India.

    ReplyDelete
  21. Our Catalogcatalogue printing in Delhi Designing in Delhi provides creative Online Product Catalog design Printing with guaranteed quality and on-time delivery at low prices with expert support.

    ReplyDelete
  22. Get best quality catalogues with leading catalogue designer in Delhi. Abhi Print has a team of expert and experienced designers having apt knowledge of catalogue designing. Our Catalog Designing in delhi provides creative Online Product Catalog design Printing with guaranteed quality and on-time delivery at low prices with expert support.

    ReplyDelete
  23. Catalogues We provide all printing service like catalogue Printing look good and attract the viewer easily. Usually the pictures are presented in such a manner that it grabs all the attention and people forget to read the text. Catalogues feature large images that capture the viewer's eye and hold it for a longer interval. They solve the purpose in a better way as they are more compact and can easily be taken to a prospective client or distributed among the interested buyers. They can also be kept at the sales counter to be shown to the buyers, that is how they get to select a product suiting their taste from a range of other products.

    ReplyDelete

  24. Every detail wrote is of pure experience and class. I am very surprised by the third paragraph you have used very catchy lines and effective measures to solve the problems.
    Roku Com Link
    Roku.Com/Link
    Activate Roku.com/link


    ReplyDelete
  25. Professional Product Photography In Gurgaon | ANTS Digital

    Looking for professional photography ? ANTS Digital provides the best professional photography services in Gurgaon .
    For more info: https://antsdigital.in/
    Contact Number:09643133067, 01244012620.
    Email : hi@antsdigital.in

    ReplyDelete
  26. At AbhiPrint we assure you to provide some great paintings to create a uniquely compact catalog. We provide all printing service like catalogue Printing.The elegant product is just a small with a bare minimum copy of the text. With our minimalist design, your list will look attractive, informative and vague which will help attract the attention of potential customers. Image size. And background color as well as counts to achieve the desired result.Catalogs are a great resource to take any business to success. However, it is necessary that your catalog contains valuable information about the products and services you are offering. We know the importance of your catalog and therefore make sure to include complete information about your products including product pictures, charts, or pictures to complete your sales marketing materials.

    ReplyDelete
  27. At AbhiPrint we assure you to provide some great paintings to create a uniquely compact catalog. The elegant product is just a small with a bare minimum copy of the text. With our minimalist design, your list will look attractive, informative and vague which will help attract the attention of potential customers. catalog design and printing size. Best Catalog Printing Services In Delhi NCR, Catalog Printing In Rohini, Catalog Printing In Gurgaon Best Catalog Printing Services In All Over IndiaOur Catalog Designing in Delhi provides creative Online Product Catalog design Printing with guaranteed quality and on-time delivery at low prices with expert support.And background color as well as counts to achieve the desired result.

    ReplyDelete


  28. Even in this era, there are digital selling techniques trends are famous but the brochure printing brochure printing in Delhi services is a famous tool for selling yet. Brochures printing services atWhat

    makes a decent brochure? We know there is a cut-throat competition in the market. In this market, your brochure printing should be unique with content and attractive in designs.

    Printing Press in Delhi NCR abhiprint printing press Best Printing Press in Delhi, Gurgaon, Noida for quality and service. We assuring you for lowest price in industry. We are

    famous for quality and quantity at cheapest price abhiprint printing press A superbly designed brochure means there must be the best quality paper and a high-resolution printing

    technique. LPI should be minimum If there is dark colour background warnish or lamination must be done.

    ReplyDelete
  29. Our goal is to go far beyond simple data entry service to provide a complete X-Cart product data management solution tailored to your business needs.

    ReplyDelete
  30. I have read a few of the articles on your website now, and I really like your style of blogging. I added it to my favorites blog site list and will be checking back soon. Please check out my site as well and let me know what you think.
    Detailed research and study on each products from Amazon

    ReplyDelete
  31. At AbhiPrint we assure you to provide some great paintings to create a uniquely compact catalog. The elegant product is just a small with a bare minimum copy of the text. With our minimalist design, your list will look attractive, informative and vague which will help attract the attention of potential customers. Catalog printing services in Delhi.size. Best Catalog Printing Services In Delhi NCR, Catalog Printing In Rohini, Catalog Printing In Gurgaon Best Catalog Printing Services In All Over IndiaOur Catalog Designing in Delhi provides creative Online Product Catalog design Printing with guaranteed quality and on-time delivery at low prices with expert support.And background color as well as counts to achieve the desired result.Our Catalog Designing in Delhi provides creative Online Product Catalog design Printing with guaranteed quality and on-time delivery at low prices with expert support.

    ReplyDelete
  32. The printing press allows us to share large amounts of information quickly and in huge numbers. In fact, the printing press is so significant that it has come to be known as one of the most important inventions of our time. It drastically changed the way society evolved. Digital Printing Services, Catalog Printing Services, Magazines Publishing, Books Printing, Web Offset Printing, Print Media, Typesetting Services, Color Printing, Books Binding, Printing Press, Best Printing Press Company in Delhi Catalog Printing, Sticker Printing, Brochure Printing, Pamphlet Printing, Booklet Printing, Printing Services Abhi print printing Press has enjoyed the reputation of being one of the frontline names in the Indian printing industry. We are providing all types of printing services.Offset Printing Service We can print and paper products which are up to 6 colors at one time using the latest color and pressing software and for the solid color using the LAB value for the consistency in color and avoid any shade variation.

    ReplyDelete
  33. The Abhi Print offers the most comprehensive printing solutions in a range of services

    include eco solvent printing
    service, eco solvent printing, digital eco solvent

    printing, solvent vinyl printing, eco solvent print services and eco solvent vinyl

    printing"

    ReplyDelete
  34. Even in this era, there are digital selling techniques trends are famous but the brochure printing services is a famous tool for selling yet. Brochures printing services that make a decent brochure? Brochure printing company in Delhi.We know there is a cut-throat competition in the market. In this market, your brochure printing should be unique with content and attractive in designs. Printing Press in Delhi NCR printing press Best Printing Press in Delhi, Gurgaon, Noida for quality and service. We assuring you for lowest price in industry. Brochure printing, Cheap Brochure Printing, Online Brochure printing, BrochurWe are famous for quality and quantity at cheapest price abhiprint printing press A superbly designed brochure means there must be the best quality paper and a high-resolution printing technique. LPI should be minimum If there is dark color background varnish or lamination must be done. Heavy discounts on Best Brochure Printing Services offered. Fast production for Full -Color Brochure printing in Delhi, Gurgaon, and India.

    ReplyDelete
  35. Stickers use a substance called an adhesive—a kind of glue or paste that makes them stick to a surface. ... In adhesives, the molecular ropes are arranged so that their little sticky parts are all lined up. With all those sticky parts working together, the molecules stick very tightly to one another and to many surfacesThe Abhi Print offers the most comprehensive sticker printing solutions in offset printing of stickers online label printer car stickers sticker labels sticker printing near me photo stickerssticker custom stickers vinyl sticker printing sticker maker stickers online sticker design label printer car stickers sticker labels sticker printing.Sticker printing company in RohiniSerial No Sticker Wholesaler in Delhi Delhi India - Abhiprint is well established Wholesale Supplier of Serial No Sticker in Delhi. car sticker design laptop stickers personal sticker maker

    ReplyDelete
  36. At AbhiPrint we assure you to provide some great paintings to create a uniquely compact catalog. We provide all printing service like catalogue Printing We provide all printing service like catalogue PrintingThe elegant product is just a small with a bare minimum copy of the text. With our minimalist design, your list will look attractive, informative and vague which will help attract the attention of potential customers. size. Best Catalog Printing Services In Delhi NCR, Catalog Printing In Rohini, Catalog Printing In Gurgaon Best Catalog Printing Services In All Over IndiaOur Catalog Designing in Delhi provides creative Online Product Catalog design Printing with guaranteed quality and on-time delivery at low prices with expert support.And background color as well as counts to achieve the desired result.Our Catalog Designing in Delhi provides creative Online Product Catalog design Printing with guaranteed quality and on-time delivery at low prices with expert support.

    ReplyDelete
  37. Nice information on here, I would like to share with you all my experience trying to get a loan to expand my Clothing Business here in Malaysia. It was really hard on my business going down due to my little short time illness then when I got heal I needed a fund to set it up again for me to begin so I came across Mr Benjamin a loan consultant officer at Le_Meridian Funding Service He asked me of my business project and I told him i already owned One and i just needed loan of 200,000.00 USD he gave me form to fill and I did also he asked me of my Valid ID in few days They did the transfer and my loan was granted. I really want to appreciate there effort also try to get this to anyone looking for business loan or other financial issues to Contact Le_Meridian Funding Service On Email: lfdsloans@lemeridianfds.com / lfdsloans@outlook.com He also available on WhatsApp Contact:+1-9893943740.

    ReplyDelete
  38. A catalog can be any compilation of items organized in a systematic manner. That's why the list of books available at

    your library might be organized in a digital catalog.
    It can also be used as a verb meaning

    to make a catalog of items or to add an item to a catalog. You can catalog anything!

    ReplyDelete
  39. Loan Opportunity Offered By Mr, Benjamin That Save My Family From Financial Bondage {  247officedept@gmail.com  }

    Hello Everyone, I am Putri Adiratnaa single mom from Jakarta, I would like to share this great testimony on how I got a loan from Mr, Benjamin, when we were driven out of our home when I couldn't pay my bills anymore, After being scammed by various companies online and denied a loan from my bank and some other credit union I visited. My children were taken by the foster care, I was all alone in the street. The day i shamefully walked into an old school mate who introduced me to Daisy Maureen. At first I told her that I am not ready to take any risk of requesting a loan online anymore, but she assured me that I will receive my loan from them. On a second thought, due to my homelessness I had to take a trial and applied for the loan, luckily for me I received a loan of $80,000.00 from Mr, Benjamin. I'm happy I took the risk and applied for the loan. My kids have been given back to me and now I own a home and a business of my own. All thanks and gratitude goes to  the help of Mr, Benjamin for giving me a meaning to life when i had lost all hope. If you currently seeking for a loan assistance, you can contact them via: {247officedept@gmail.com    WhatsApp +1-989-394-3740.

    ReplyDelete
  40. Thanks for sharing this informative blog about adult products. Keep up the good work.

    ReplyDelete
  41. Looking Men's Sex Toys Store, For male enhancement, try a penis ring or pump to increase. Visit male xxx sex toys store online www.adultsproduct.com

    ReplyDelete
  42. pricing management software for banking
    Personalize products, offers, pricing and loyalty programs; prevent revenue leakage and ensure regulatory compliance with a billing solution.

    ReplyDelete
  43. really sharing a good article as our perception Launching an eCommerce store is quite easy. The hardest part is the scaling of the store. Having an effective discount / pricing strategy can help grow your store. Because, dynamic pricing and discounts can

    Increase your Customer acquisition rate
    Scale your online revenue
    More: https://www.flycart.org/products/wordpress/woocommerce-discount-rules

    ReplyDelete
  44. Thanks for providing such a valuable Knowledge on Quick Books CRM . I have learned many things with this blog. Keep sharing. Very knowledgeable Blog. If you want Quick Books CRM.. Than visit my website QuickBooks Online CRM

    ReplyDelete
  45. Nice Post, Thanks for sharing this wonderful information. Hope to see more like this from you
    AutoCAD Course In Pune

    ReplyDelete
  46. As a business owner in the UAE, I can vouch for the immense value of having a trusted Microsoft Dynamics partner UAE by your side. The right partner can truly transform your business operations and drive growth like never before.

    ReplyDelete

My Name is..