Sales

Build price lists for multiple customer segments

Published Date : January 1, 2008

A common pricing strategy is maintaining separate price lists for each customer segment. In this article a fictitious company, Wingtip Toys, is used to illustrate an example of a multiple price-list scenario in Microsoft Dynamics CRM.

Price lists based on customer segments

Wingtip Toys is exploring the addition of two new customer segments: government agencies and not-for-profit organizations.

Government agencies purchase in greater volume. Not-for-profit organizations purchase less often, but in much greater quantity, although the quantities are typically less than government agencies.

To increase sales for its customer segments Wingtip Toys will maintain separate price lists:

Customer Segment Product Price Per Unit
Customer Segment and Pricing

Retail Toy Stores

Beach Ball

$1.00

Not-for-Profit Organizations

Beach Ball

$0.95

Government Agencies

Beach Ball

$0.90

Wingtip Toys has a price list for retail toy-store customers. Now, the company must create two additional price lists for the new customer segments. To create the price lists, follow these steps.

Note

These procedures assume that the products and units are established in the product catalog. For more information about how to create the product catalog and add items to it, such as products, units, discounts, and pricing methods, see the Microsoft Dynamics CRM Help.

Step 1: Create the government agency price list and add the price list Items

  1. In the Navigation Pane, click Settings, click Product Catalog, and then click Price Lists.

  2. On the Actions toolbar, click New.

  3. In the Price List form, enter the following information:

    • Name

      Enter a name with a length of 100 characters or less. The information should be meaningful and unique, such as Beach Ball Price List for Government Agencies.

    • Start Date

      Enter the beginning date for which this price list is valid. You must enter the date in the format your organization has set for dates.

    • End Date

      Enter the end date after which this price list will no longer be valid.

    • Currency

      Click the Lookup button and select the currency for this price list.

    • Description

      Add a description of the price list or notes, for example: This is our price list for government agencies that purchase beach balls.

  4. Click Save. Leave the Price List form open.

Next, the price list items are added to this price list.

  1. In the Price List form, under Details, click Price List Items, and then click Add Price List Item.

  2. On the General tab, enter the following information:

    • Price List

      Microsoft Dynamics CRM automatically selects the price list that you created in the previous steps.

    • Currency

      Microsoft Dynamics CRM automatically selects the currency that you selected for the price list in the previous steps.

    • Product

      Select a product. For this example, select the Wingtip Toys Beach Ball product.

    • Unit

      Click Lookup to search for and select the unit that you want. For the beach ball product, a unit is selected that represents a single item because the beach balls are most commonly sold individually.

    • Discount List

      If a discount list is available, you can select a discount list to apply to this price list. In this example we will not use a discount list.

    • Quantity Selling Option

      Select a quantity selling option. This defines the type of quantities in which the product is sold. Because Wingtip Toys does not sell portions or fractions of a beach ball, select Whole.

    • Pricing Method

      Because Wingtip Toys charges $.90 per unit to each government-agency customer, it uses the currency amount option for the pricing method. Therefore, in the Pricing Method list, select Currency Amount.

    • Amount

      Enter the base cost that the product will list. For the beach ball product, type .90.

    • Rounding Policy

      If Wingtip Toys used a more sophisticated pricing method, such as percent of list or percent of markup, rounding options would be available to determine a policy for price rounding. For this example, a rounding policy will not be used.

  3. Click Save and Close to close the Price List Item form.

  4. Click Save and Close to close the Price List form.

Step 2: Create the not-for-profit organization price list and add the price list items

  1. In the Navigation Pane, click Settings, click Product Catalog, and then click Price Lists.

  2. On the Actions toolbar, click New.

  3. In the Price List form, enter the following information:

    • Name

      Enter a name with a length of 100 characters or less. The information should be meaningful and unique, such as Beach Ball Price List for Not-for-Profit Organizations.

    • Start Date

      Enter the beginning date for which this price list is valid. You must enter the date in the format your organization has set for dates.

    • End Date

      Enter the end date after which this price list will no longer be valid.

    • Currency

      Click the Lookup button and select the currency for this price list.

    • Description

      Add a description of the price list or notes, for example: This is our price list for not-for-profit organizations that purchase beach balls.

  4. Click Save. Leave the Price List form open.

Next, the price-list items are added to this price list.

  1. In the Price List form, under Details, click Price List Items, and then click Add Price List Item.

  2. On the General tab, enter the following information:

    • Price List

      Microsoft Dynamics CRM automatically selects the price list that you created in the previous steps.

    • Currency

      Click the Lookup button and select the currency for the price list item.

    • Product

      Select a product. For this example, select the Wingtip Toys Beach Ball product.

    • Unit

      Click Lookup to search for and select the unit that you want. For the beach ball product, a unit is selected that represents a single item because the beach balls are most commonly sold individually.

    • Discount List

      If a discount list is available, you can select a discount list to apply to this price list. In this example we will not use a discount list.

    • Quantity Selling Option

      Select a quantity selling option. This defines the type of quantities in which the product is sold. Because Wingtip Toys does not sell portions or fractions of a beach ball, select Whole.

    • Pricing Method

      Because Wingtip Toys charges $.95 per unit to each not-for-profit organization customer, it uses the currency amount option for the pricing method. Therefore, in the Pricing Method list, select Currency Amount.

    • Amount

      Enter the base cost that the product will list. For the beach ball product, type .95.

    • Rounding Policy

      If Wingtip Toys used a more sophisticated pricing method, such as percent of list or percent of markup, rounding options would be available to determine a policy for price rounding.

  3. Click Save and Close to close the Price List Item form.

  4. Click Save and Close to close the Price List form.

The price lists are ready to use to generate quotes, orders, and invoices.

Related Links

Did you find the information that you need?
Yes     No 
If not, what information do you need? (optional)

© 2008 Microsoft Corporation. All rights reserved.