Customer Price Group Pricing

Customer price group pricing allows you to price the items on an order based on the customer price group assigned to the sold to customer on the order. The system determines the initial price of the item based on the Price type assigned to the customer price group and applies any qualifying discounts to the order during line-level pricing and end-of-order pricing.

In this topic:

         Customer Price Group Pricing Setup

         Line Level Customer Price Group Pricing

         Examples: Line Level Customer Price Group Pricing

         Customer Price Group Price Code Pricing

         Examples: Customer Price Group Price Code Pricing

         Customer Price Group Best Price Comparison

         Examples: Customer Price Group Best Price Comparison

         Customer Price Group Pricing in Order Maintenance

Customer Price Group Pricing Setup

Before you can use the customer price group pricing method, you must complete the necessary setup.

         Menu Options for Customer Price Group Pricing

         System Control Values for Customer Price Group Pricing

Menu Options for Customer Price Group Pricing

Menu Option

Description

Working with Customer Price Groups (WCPG)

Create customer price groups to assign to sold to customers. For each customer price group:

         Use the Price Type field to define the price the system uses as the initial price of an item during customer price group line level pricing.

-      Original = Use the Orig retail $ (Original retail price) field in the SKU table as the initial price.

-      Regular = Use the List price field in the SKU table as the initial price.

         Optionally, use the Discount field at the customer price group level or customer price group detail level to define a percent discount to prorate across the items on an order for a sold to customer assigned to this customer price group.

         Optionally, select the Best Price Comparison field to have the system perform customer price group best price comparison logic for the customer price group during end-of-order pricing and repricing. Customer price group best price comparison determines if the price available for the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value is a better price than the price available for the customer price group assigned to the sold to customer. Whichever customer price group provides the best price, the system applies this price to the item on the order.

         Optionally, use the Work with Customer Price Group Exclusions Screen to define the items/SKUs that are not eligible for the customer price group discount applied to the order during customer price group pricing.

Creating and Updating Sold-to Customers (WCST)

Use the Price group field to assign sold to customers to a customer price group.

Note:  You can also pass the price group code in the Inbound Order XML Message (CWORDERIN) or the Inbound Customer Message (CWCustomerIn). When you assign the customer price group through the order API, the new order is eligible for any pricing or promotions associated with the price group. If you create an order for a customer that is not assigned to a customer price group, or is assigned to an invalid customer price group code, the system assigns the customer price group code defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value to the customer.

Creating and Working with Items (MITM)

For each item/SKU:

Define the Original price of the item.

         non-SKUed item: Use the Orig retail $ field on the Create Item (Base Information) Screen.

         SKUed item: Use the Orig retail $ field on the Create SKU 1 of 2 (With Overrides) Screen.

Define the Regular price of the item.

         non-SKUed item: Use the List price field on the Create Item (Base Information) Screen.

         SKUed item: Use the List price field on the Create SKU 1 of 2 (With Overrides) Screen.

         Select the Discountable field on the Create Item Screen if the item is eligible for customer price group discounts.

Assign the item/SKU to an offer in order to assign the item/SKU to a price code using the Assigning Price Codes (APCD) menu option.

Working with Price Codes (WPCD)

Create price codes to offer a special price or discount for an item or group of items.

Optionally, use the Work with Qualifying Customer/Price Groups Screen to define the sold to customers and customer price groups that qualify for the price code. Note: If you do not define any sold to customers or customer price groups for a price code, then ALL sold to customers and customer price groups qualify for the price code.

Note:  Order lines that are assigned to a price code do not qualify for the discount defined for the customer price group assigned to the sold to customer on the order. To apply the customer price group discount to order lines that are assigned to a price code, embed the customer price group discount in the price defined for the price code. Example: If the customer price group provides a 30% discount, create the price code discount so that it includes the 30% discount.

Assigning Price Codes (APCD)

Define which items are eligible for the special price or discount specified in a price code. You can assign the item to one or more price codes by offer or source code.

Establishing Price Override Reason Codes (WPOR)

Create the price override reason code to assign to order lines that are priced using a customer price group price and cannot be further discounted. However, you can still apply an order-level coupon to these order lines.

Working with Source Codes (WSRC)

To perform End of Order Customer Price Group Pricing during repricing, the Price method field for the source code on the order header must be set to Reg Plus Reprice.

Working with Promotions (WPRO)

Create promotions to apply a further discount to eligible order lines.

System Control Values for Customer Price Group Pricing

Entity level override: You can set up pricing value overrides for an entity that should use different pricing logic from your company-wide standard. In order entry, the system checks the entity associated with the source code on the order header to determine if entity-level pricing overrides are in effect. However, if you enter a customer price group in the Customer Price Group Code for CPG Pricing Only (L58) system control value, entity-level pricing overrides are NOT in effect. The system always uses the customer price group pricing method, regardless of the pricing values defined at the entity level.

System Control Value

Description

Customer Price Group Code for CPG Pricing Only (L58)

Enter a customer price group code if you wish to use customer price group pricing. The system uses this customer price group:

         As the default customer price group to apply to an order when the sold to customer on the order is not assigned to a customer price group.

         During customer price group best price comparison to determine if the price available for the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value is a better price than the price available for the customer price group assigned to the sold to customer. Whichever customer price group provides the best price, the system applies this price to the item on the order.

Note:  If you enter a customer price group code in this system control value:

         the system uses only customer price group pricing to perform line-level pricing. The system does NOT use the pricing hierarchy to search for a price for an item and does not perform best way pricing based on the setting of the Best Way Pricing (A78) system control value.

         you must select the Price Codes (D93) system control value to perform end-of-order pricing and you cannot select any other type of end-of-order pricing method.

Price Override Reason Code for CPG Pricing (L59)

Enter the price override reason code to assign to order lines that are priced using a customer price group price and cannot be further discounted. However, you can still apply an order-level coupon to these order lines.

Line Level Customer Price Group Pricing

The system uses the following steps when you add an item to an order and the system uses customer price group line-level pricing to calculate the price of the order line.

         Determine the Customer Price Group to Use

         Determine the Initial Price of the Item

         Determine the Customer Price Group Discount

         Compare List Price to Order Line Price

         Calculate Order Header Discounts

         Apply Final Customer Price Group Price to Order

Determine the Customer Price Group to Use

The system uses the customer price group assigned to the sold to customer on the order. If a customer price group code is not assigned to the sold to customer on the order, or if it is invalid, the system uses the customer price group code defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value.

Determine the Initial Price of the Item

If a price override reason code is defined for the order line, the system does not price the item using customer price group pricing, and instead, uses the price defined for the order line.

If a price override reason code is not defined for the order line, the system looks at the Price Type defined for the customer price group to determine the initial price of the item.

         Original = Original Price. The system uses the price defined in the Orig retail $ (Original Retail Price) field in the SKU table as the initial price of the item.

         Regular = Regular Price. The system uses the price defined in the List price field in the SKU table as the initial price of the item.

If an initial price is not found for the item: If the system cannot determine the initial price for the item (an Original retail price or List price was not defined for the item), the system displays an error message in interactive order entry: Price Not Found.

Determine the Customer Price Group Discount

Item eligible for discount? An item is NOT eligible for customer price group discounting if:

         The Discountable field for the item is unselected.

         The item/SKU is excluded from the customer price group discount. These items display on the Work with Customer Price Group Exclusions Screen and exist in the Customer Price Group SKU Exclusion table.

If the Discountable field for the item is selected and the item/SKU is not excluded from the customer price group discount, the system will apply qualifying discounts and promotions to the item.

Customer price group discount hierarchy: The system determines if a discount exists for the customer price group on the order. The system uses the following hierarchy to determine the customer price group discount.

1.      Use the discount defined in the Customer Price Group Detail table with an effective date that is equal to or earlier than the current date. If more than one Customer Price Group Detail record exists with a qualifying effective date, the system uses the discount with the most current effective date. You can review these discounts on the Work with Customer Price Group Details Screen.

2.      If a discount is not defined in the Customer Price Group Detail table with a qualifying effective date, use the discount defined in the Customer Price Group table. You can review this discount on the Work with Customer Price Groups Screen.

3.      If a discount is not defined in the Customer Price Group table, do not apply a customer price group discount to the order.

Customer price group discount calculation: Original or Regular Price - Customer Price Group Discount % = Updated Order Line Price 

Compare List Price to Order Line Price

The system compares the list price defined for the item to the order line price.

         If the list price is lower than the order line price, the system applies the list price to the order line.

         If the list price is equal to or greater than the order line price, the system retains the order line price.

Display Order Detail: If the list price was lower than the order line price, the system displays a message on the Display Order Detail Screen (Reviewing Order Line Detail) in Order Inquiry: LIST PRICE < ORIGINAL RETAIL $ PRICE.

Calculate Order Header Discounts

The system applies any qualifying order header discounts to the order, such as:

         The discount defined in the Disc % field on the Work with Order Screen.

         The discount defined for the source code on the Work with Order Screen. Use the Discount % field on the Create Source Code Screen (1 of 2) to define a source discount.

Discount calculation messages: If the calculated order line price is lower than the initial price of the item, the system displays Discount Calculation Messages when you add the item to the order, indicating the order line number of the discounted item, the offer price (this is initial price of the item), the actual price (this is the discounted price the customer is paying), the dollar amount of the discount, and the discount percentage. For example, if the initial price is $10.00 and the order line price is $5.00, the discount calculation message displays as: Line 1: Offer = 10.00 Actual = 5.00 Discount = 5.00: 50.00%.

Apply Final Customer Price Group Price to Order

After calculating any Order Header discounts for the order, the system applies the final customer price group price to the lines on the order.

The system updates the following fields in the Order Detail table during customer price group line level pricing.

Field

Order Detail Update

ODT Offer Price

The initial price of the item, based on the Price type defined for the customer price group.

         If Price type is Original, this is the Original Retail Price from the SKU table.

         If Price type is Regular, this is the List Price from the SKU table.

You can use this field to determine the initial price of the order line before the system applied any discounts or promotions to the order line.

ODT Original Price

The List price defined for the item/SKU in the SKU table.

ODT Pre-Discount Price

The price of the item after applying the customer price group discount and order header discount.

This is the initial price - the customer price group and order header discount; however, if the list price is lower than this price, this is the list price of the item.

ODT Price

The final calculated price of the item after applying the customer price group discount and order header discount.

This is the initial price - the customer price group and order header discount; however, if the list price is lower than this price, this is the list price of the item. Note: The final price of the order line may update during Customer Price Group Price Code Pricing.

Price Method

The method the system used to calculate the price of an item, but before applying an order-level discount, such as a source code discount percentage.

F Customer Price Group displays for lines priced using Customer Price Group Line Level pricing; see the Order Pricing Window for a complete list of price methods.

The system uses this value to display the Pricing method on the Work with Order Line Screen (Changing/Adding an Item).

Important:                          The system may reprice the order line during Customer Price Group Price Code Pricing and Customer Price Group Best Price Comparison. The system performs price code pricing and best price comparison during repricing and end-of-order pricing.

Examples: Line Level Customer Price Group Pricing

         Example: Original Customer Price Group Line Pricing

         Example: Regular Customer Price Group Line Pricing

         Example: Customer Price Group Line Pricing With Customer Price Group Discount

         Example: Customer Price Group Line Pricing with Order Header Discount

         Example: Customer Price Group Line Pricing with Customer Price Group and Order Header Discount

Example: Original Customer Price Group Line Pricing

1. Determine the Customer Price Group to Use. A customer assigned to customer price group CPGO places an order.

2. Determine the Initial Price of the Item. The Price type for customer price group CPGO is set to Original, indicating the system uses the Original retail price in the SKU table as the initial price of the item.

The customer adds item ITO to the order. Item ITO has the following prices defined:

         List price of $25.00

         Original retail price of $20.00

Since the Price type for customer price group CPGO is set to Original, the system uses 20.00 as the initial price of the item.

The customer adds item ITR to the order. Item ITR has the following prices defined:

         List price of $10.00

         Original retail price of $15.00

Since the Price type for customer price group CPGO is set to Original, the system uses 15.00 as the initial price of the item.

3. Determine the Customer Price Group Discount. The Discountable flag for items ITO and ITR is selected, indicating the items are eligible for customer price group discounting, however, a discount is not defined for customer price group CPGO, so a customer price group discount is not applied to the order.

4. Compare List Price to Order Line Price. The system compares the list price defined for the item to the order line price.

         The list price for item ITO is $25.00 and the order line price is $20.00. Since the order line price is lower than the list price, the system retains $20.00 as the order line price.

         The list price for item ITR is $10.00 and the order line price is $15.00. Since the order line price is greater than the list price, the system updates the order line price to $10.00.

5. Calculate Order Header Discounts. The order does not qualify for any Order Header discounts.

6. Apply Final Customer Price Group Price to Order. The system applies the final customer price group price to the lines on the order:

         The order line price for item ITO is $20.00

         The order line price for item ITR is $10.00.

Because the calculated order line price for item ITR is lower than the initial price of the item, the system displays Discount Calculation Messages when you add the item to the order: Line 2:Offer = 15.00 Actual = 10.00 Discount = 5.00 :33.33%

The system updates the Order Detail table with the customer price group line level price.

Field

Item ITO

Item ITR

ODT Offer Price

Initial price: 20.00

Initial price: 15.00

ODT Original Price

List price: 25.00

List price: 10.00

ODT Pre-Discount Price

Price after discounts: 20.00

Price after discounts: 10.00

ODT Price

Order line price: 20.00

Order line price: 10.00

Price Method

F = Customer Price Group.

F = Customer Price Group.

Example: Regular Customer Price Group Line Pricing

1. Determine the Customer Price Group to Use. A customer assigned to customer price group CPGR places an order.

2. Determine the Initial Price of the Item. The Price type for customer price group CPGR is set to Regular, indicating the system uses the List price in the SKU table as the initial price of the item.

The customer adds item ITO to the order. Item ITO has the following prices defined:

         List price of $25.00

         Original retail price of $20.00

Since the Price type for customer price group CPGR is set to Regular, the system uses 25.00 as the initial price of the item.

The customer adds item ITR to the order. Item ITR has the following prices defined:

         List price of $10.00

         Original retail price of $15.00

Since the Price type for customer price group CPGR is set to Regular, the system uses 10.00 as the initial price of the item.

3. Determine the Customer Price Group Discount. The Discountable flag for items ITO and ITR is selected, indicating the items are eligible for customer price group discounting, however, a discount is not defined for customer price group CPGO, so a customer price group discount is not applied to the order.

4. Compare List Price to Order Line Price. The system compares the list price defined for the item to the order line price.

         The list price for item ITO is $25.00 and the order line price is $25.00. Since the order line price is equal to the list price, the system retains $25.00 as the order line price.

         The list price for item ITR is $10.00 and the order line price is $10.00. Since the order line price is equal to the list price, the system retains $10.00 as the order line price.

5. Calculate Order Header Discounts. The order does not qualify for any Order Header discounts.

6. Apply Final Customer Price Group Price to Order. The system applies the final customer price group price to the lines on the order:

         The order line price for item ITO is $25.00

         The order line price for item ITR is $10.00.

The system updates the Order Detail table with the customer price group line level price.

Field

Item ITO

Item ITR

ODT Offer Price

Initial price: 25.00

Initial price: 10.00

ODT Original Price

List price: 25.00

List price: 10.00

ODT Pre-Discount Price

Price after discounts: 25.00

Price after discounts: 10.00

ODT Price

Order line price: 25.00

Order line price: 10.00

Price Method

F = Customer Price Group.

F = Customer Price Group.

Example: Customer Price Group Line Pricing With Customer Price Group Discount

1. Determine the Customer Price Group to Use. A customer assigned to customer price group CPGO places an order.

2. Determine the Initial Price of the Item. The Price type for customer price group CPGO is set to Original, indicating the system uses the Original retail price in the SKU table as the initial price of the item.

The customer adds item ITO to the order. Item ITO has the following prices defined:

         List price of $25.00

         Original retail price of $20.00

Since the Price type for customer price group CPGO is set to Original, the system uses 20.00 as the initial price of the item.

The customer adds item ITR to the order. Item ITR has the following prices defined:

         List price of $10.00

         Original retail price of $15.00

Since the Price type for customer price group CPGO is set to Original, the system uses 15.00 as the initial price of the item.

3. Determine the Customer Price Group Discount. The Discountable flag for items ITO and ITR is selected, indicating the items are eligible for customer price group discounting. Customer price group CPGO has the following discounts defined:

         10.00% discount at the Customer Price Group Detail level with an effective date of 1/16/12.

         30.00% discount at the Customer Price Group Detail level with an effective date of 2/14/12.

         5.00% discount at the Customer Price Group level.

Because the current date is 2/15/12, the system applies the 30.00% discount to the order.

         Item ITO: initial price $20.00 - 30.00% = $14.00.

         Item ITR: initial price $15.00 - 30.00% = $10.50.

4. Compare List Price to Order Line Price. The system compares the list price defined for the item to the order line price.

         The list price for item ITO is $25.00 and the order line price is $14.00. Since the order line price is lower than the list price, the system retains $14.00 as the order line price.

         The list price for item ITR is $10.00 and the order line price is $10.50. Since the order line price is greater than the list price, the system updates the order line price to $10.00.

5. Calculate Order Header Discounts. The order does not qualify for any Order Header discounts.

6. Apply Final Customer Price Group Price to Order. The system applies the final customer price group price to the lines on the order:

Because the calculated order line price for item ITO is lower than the initial price of the item, the system displays Discount Calculation Messages when you add the item to the order: Line 2:Offer = 20.00 Actual = 14.00 Discount = 6.00 :30.00%

Because the calculated order line price for item ITR is lower than the initial price of the item, the system displays Discount Calculation Messages when you add the item to the order: Line 2:Offer = 15.00 Actual = 10.00 Discount = 5.00 :33.33%

The system updates the Order Detail table with the customer price group line level price.

Field

Item ITO

Item ITR

ODT Offer Price

Initial price: 20.00

Initial price: 15.00

ODT Original Price

List price: 25.00

List price: 10.00

ODT Pre-Discount Price

Price after discounts: 14.00

Price after discounts: 10.00

ODT Price

Order line price: 14.00

Order line price: 10.00

Price Method

F = Customer Price Group.

F = Customer Price Group.

Example: Customer Price Group Line Pricing with Order Header Discount

1. Determine the Customer Price Group to Use. A customer assigned to customer price group CPGO places an order.

2. Determine the Initial Price of the Item. The Price type for customer price group CPGO is set to Original, indicating the system uses the Original retail price in the SKU table as the initial price of the item.

The customer adds item ITO to the order. Item ITO has the following prices defined:

         List price of $25.00

         Original retail price of $20.00

Since the Price type for customer price group CPGO is set to Original, the system uses 20.00 as the initial price of the item.

The customer adds item ITR to the order. Item ITR has the following prices defined:

         List price of $10.00

         Original retail price of $15.00

Since the Price type for customer price group CPGO is set to Original, the system uses 15.00 as the initial price of the item.

3. Determine the Customer Price Group Discount. The Discountable flag for items ITO and ITR is selected, indicating the items are eligible for customer price group discounting, however, a discount is not defined for customer price group CPGO, so a customer price group discount is not applied to the order.

4. Compare List Price to Order Line Price. The system compares the list price defined for the item to the order line price.

         The list price for item ITO is $25.00 and the order line price is $20.00. Since the order line price is lower than the list price, the system retains $20.00 as the order line price.

         The list price for item ITR is $10.00 and the order line price is $15.00. Since the order line price is greater than the list price, the system updates the order line price to $10.00.

5. Calculate Order Header Discounts. The order qualifies for a 25% source discount.

The system applies the 25% source discount to the order.

         Item ITO: current order line price $20.00 - 25.00% = $15.00.

         Item ITR: current order line price $10.00 - 25.00% = $7.50.

6. Apply Final Customer Price Group Price to Order. The system applies the final customer price group price to the lines on the order:

Because the calculated order line price for item ITO is lower than the initial price of the item, the system displays Discount Calculation Messages when you add the item to the order: Line 2:Offer = 20.00 Actual = 15.00 Discount = 5.00 :25.00%

Because the calculated order line price for item ITR is lower than the initial price of the item, the system displays Discount Calculation Messages when you add the item to the order: Line 2:Offer = 15.00 Actual = 7.50 Discount = 7.50 :50.00%

The system updates the Order Detail table with the customer price group line level price.

Field

Item ITO

Item ITR

ODT Offer Price

Initial price: 20.00

Initial price: 15.00

ODT Original Price

List price: 25.00

List price: 10.00

ODT Pre-Discount Price

Price after discounts: 15.00

Price after discounts: 7.50

ODT Price

Order line price: 15.00

Order line price: 7.50

Price Method

F = Customer Price Group.

F = Customer Price Group.

Example: Customer Price Group Line Pricing with Customer Price Group and Order Header Discount

1. Determine the Customer Price Group to Use. A customer assigned to customer price group CPGO places an order.

2. Determine the Initial Price of the Item. The Price type for customer price group CPGO is set to Original, indicating the system uses the Original retail price in the SKU table as the initial price of the item.

The customer adds item ITO to the order. Item ITO has the following prices defined:

         List price of $25.00

         Original retail price of $20.00

Since the Price type for customer price group CPGO is set to Original, the system uses 20.00 as the initial price of the item.

The customer adds item ITR to the order. Item ITR has the following prices defined:

         List price of $10.00

         Original retail price of $15.00

Since the Price type for customer price group CPGO is set to Original, the system uses 15.00 as the initial price of the item.

3. Determine the Customer Price Group Discount. The Discountable flag for items ITO and ITR is selected, indicating the items are eligible for customer price group discounting. Customer price group CPGO has the following discounts defined:

         10.00% discount at the Customer Price Group Detail level with an effective date of 1/16/12.

         30.00% discount at the Customer Price Group Detail level with an effective date of 2/14/12.

         5.00% discount at the Customer Price Group level.

Because the current date is 2/15/12, the system applies the 30.00% discount to the order.

         Item ITO: initial price $20.00 - 30.00% = $14.00.

         Item ITR: initial price $15.00 - 30.00% = $10.50.

4. Compare List Price to Order Line Price. The system compares the list price defined for the item to the order line price.

         The list price for item ITO is $25.00 and the order line price is $14.00. Since the order line price is lower than the list price, the system retains $14.00 as the order line price.

         The list price for item ITR is $10.00 and the order line price is $10.50. Since the order line price is greater than the list price, the system updates the order line price to $10.00.

5. Calculate Order Header Discounts. The order qualifies for a 25% source discount.

The system applies the 25% source discount to the order.

         Item ITO: current order line price $14.00 - 25.00% = $10.50.

         Item ITR: current order line price $10.00 - 25.00% = $7.50.

6. Apply Final Customer Price Group Price to Order. The system applies the final customer price group price to the lines on the order:

Because the calculated order line price for item ITO is lower than the initial price of the item, the system displays Discount Calculation Messages when you add the item to the order: Line 2:Offer = 20.00 Actual = 10.50 Discount = 9.50 :47.50%

Because the calculated order line price for item ITR is lower than the initial price of the item, the system displays Discount Calculation Messages when you add the item to the order: Line 2:Offer = 15.00 Actual = 7.50 Discount = 7.50 :50.00%

The system updates the Order Detail table with the customer price group line level price.

Field

Item ITO

Item ITR

ODT Offer Price

Initial price: 20.00

Initial price: 15.00

ODT Original Price

List price: 25.00

List price: 10.00

ODT Pre-Discount Price

Price after discounts: 10.50

Price after discounts: 7.50

ODT Price

Order line price: 10.50

Order line price: 7.50

Price Method

F = Customer Price Group.

F = Customer Price Group.

Customer Price Group Price Code Pricing

If a customer price group is defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value and the Price Codes (D93) system control value is selected, the system reevaluates the entire order during repricing to find the best price code price to apply to each qualifying order line.

See When Repricing Occurs for more information on when repricing occurs during interactive order entry.

Source code setting: To do end of order customer price group pricing, the Price method field for the source code on the order header must be set to Reg Plus Reprice.

Note:            If the Customer Price Group Code for CPG Pricing Only (L58) system control value does not contain a customer price group code, the system performs Regular Price Code Pricing instead of Customer Price Group Price Code Pricing.

The system performs the following steps during customer price group price code pricing.

         Determine Whether the Order Qualifies for a Price Code

         Apply the Price Code to the Order

         Apply Discounts and Promotions to the Order

Important:                           Order lines that are assigned to a price code do not qualify for the discount defined for the customer price group assigned to the sold to customer on the order. To apply the customer price group discount to order lines that are assigned to a price code, embed the customer price group discount in the price defined for the price code. Example: If the customer price group provides a 30% discount, create the price code discount so that it includes the 30% discount.

Determine Whether the Order Qualifies for a Price Code

To qualify for a price code:

1.

The date on the Order Header must fall within the Start date and End date defined for the price code in the Price Code table. You can review the start and end dates for price codes on the Work with Price Codes Screen.

2.

The sold to customer on the order must be defined for the price code in the Price Code Customer table. You can review the customers and customer price groups that qualify for a price code on the Work with Qualifying Customer/Price Groups Screen.

Note:  If you do not define any sold to customers or customer price groups for a price code, then ALL sold to customers and customer price groups qualify for the price code.

3.

The items on the order must be assigned to the price code and meet the price code requirements.

Which items are assigned to the price code? The system looks at the Price Code Details table to determine which items on the order are assigned to the price code. When assigning an item to a price code, you assign the item to the price code by offer or source code. The system uses the source code on the order header to determine whether the item on the order qualifies for the price code.

         If the item contains SKUs and a SKU is not defined in the Price Code Details table, all SKUs for the item qualify for the price code.

         If the item contains SKUs and a SKU is defined in the Price Code Details table, only the specified SKUs qualify for the price code.

 

Price code requirements: The system looks at the Price Code table to determine if the items on the order that are assigned to the price code meet the price code requirements.

Quantity required: The total quantity the customer must order of all qualifying items to get the price break. Note: The system evaluates price code quantity by ship-to address.

Allow multiples? 

         Unselected = Once an order qualifies for the price code based on the price code quantity requirement, the system applies the price code discount to all qualifying items on the order that are not already assigned to a price code.

         Selected = Once an order qualifies for the price code based on the price code quantity requirement, the remaining items on the order that are not already assigned to a price code must meet the price code quantity requirement again in order to qualify for the price code. The Distinct By setting defines how the system determines whether the order meets the price code multiple requirement.

Distinct By:

         Blank = The order must meet the price code quantity requirement again in order to qualify. Example: If the Quantity required is 3, the order must contain three items/SKUs defined for the price code in order to qualify. If the order contains 7 items that qualify, the system applies the price code to 6 of the items.

         Item = The quantity requirement for the price code requires separate items in order to qualify. Example: If the Quantity required is 3, the order must contain three separate items defined for the price code in order to qualify.

         SKU = The quantity requirement for the price code requires separate SKUs in order to qualify. Example: If the Quantity required is 3, the order must contain three separate SKUs defined for the price code in order to qualify.

         Category = The quantity requirement for the price code requires separate item categories in order to qualify. Example: If the Quantity required is 3, the order must contain three separate item categories for the items defined for the price code in order to qualify.

See Examples: Customer Price Group Price Code Pricing for examples of how price codes are applied to an order based on the price code requirements.

Apply the Price Code to the Order

You can apply only one price code to an order line.

Best way price code hierarchy: If an order qualifies for more than one price code and you are using Customer Price Group Price Code Pricing, the system calculates the discount that each price code provides and:

1.      Applies the price code that provides the greatest discount to the qualifying items on the order.

2.      If more than one price code offers the same discount, the system uses the price code with the lowest Sequence number.

3.      If more than one price code has the same sequence number, the system uses the price code with the lowest numeric price code.

The system applies the price code to the lines on an order in ascending price, order line number sequence.

Once you apply a price code to an order line, it no longer qualifies for another price code.

Starting price: When calculating the price code discount, the system starts with the initial price defined for the order line. This is the price of the item determined during Line Level Customer Price Group Pricing and stored in the ODT Price field.

After the system applies the first price code to the order, the system reevaluates the order to determine if it qualifies for another price code. The system applies the next price code that provides the greatest discount to the order in ascending price, order line number sequence.

The system continues to apply price codes to the order, using the best way price code hierarchy, in ascending price, order line number sequence, until all of the eligible lines on the order are assigned to a price code.

Applying a price code to a portion of an order line: To easily determine the price code discount applied to the lines on an order, enter each order line for a quantity of 1. If an order line contains a quantity greater than 1 and only part of the quantity on the order line qualifies for the discount, the system applies the discount to the quantity that qualifies for the discount and leaves the remaining quantity on the order line at its initial price. The extended price of the order line represents the discounted quantity price + the non-discounted quantity price.

Partial price code line example: An order line qualifies for a price code discount: $3.00 off 2. The Multiples field is selected for the price code, indicating the order must meet the price code requirement again to apply the price code to the order multiple times. The order line quantity is 3 with a unit price of 10.00. The system applies the price code discount to 2 units of the item (10.00 - 3.00 = 7.00). The third unit remains priced at 10.00. The extended price for the order line is 24.00 (7.00 + 7.00 + 10.00) and the unit price for the order line is 8.00 (24.00 / 3).

Note:            There may be a rounding discrepancy if the extended price of an order line does not divide evenly by the order quantity. This discrepancy should be no more than a few pennies. Example: Change the discount in the example above from $3.00 off 2 to $2.00 off 2. The order line quantity is 3 with a unit price of 10.00. The system applies the price code discount to 2 units of the item (10.00 - 2.00 = 8.00). The third unit remains priced at 10.00. The extended price for the order line is 26.01 and the unit price is 8.67 (26.00 / 3 = 8.666, which rounds to 8.67; 8.67 + 8.67 + 8.67 = 26.01).

Price method: The system updates the Price method for any order line whose price was updated during customer price group price code pricing to E Price Code.

Order lines not eligible for price code discounts:

         Price code repricing does not apply to manually priced order lines associated with a price override reason code.

         Order lines that are assigned to the price override reason code defined in the Price Override Reason Code for CPG Pricing (L59) system control value cannot be further discounted except by order-level coupons or source% discounts. However, the system includes the dollar amount and quantity for order lines assigned to the Customer Price Group price override reason code in the eligibility calculations as qualifiers for promotions and price code pricing that may apply to other items on the order.

Apply Discounts and Promotions to the Order

Discounts and promotions: Once the system completes customer price group price code pricing, the system applies any non-freight discounts, detail-level coupon promotions, and any other promotions to the lines on the order.

Determining the best price: If the Best Price Comparison field for the customer price group assigned to the sold to customer is selected, the system performs Customer Price Group Best Price Comparison to determine if the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value provides a better price than the customer price group assigned to the sold to customer on the order.

Order-level coupon promotions: When using customer price group pricing, the system applies order-level coupon promotions, as defined in Working with Coupon Promotions (WCPR), as the last discount applied to the lines on the order. See Order-Level Coupon Promotions when using Customer Price Group Pricing for further details.

Examples: Customer Price Group Price Code Pricing

         Example: Price Code Special Price Discount

         Example: Price Code Dollar Off Discount

         Example: Price Code Percent Off Discount

         Example: Price Code Group Price Discount

         Example: Applying Multiple Price Codes to the Order

         Example: Item Qualifies for More than One Price Code

         Example: Price Code Multiples and Distinct By

Example: Price Code Special Price Discount

On 2/17/12, you take an order for sold to customer 10.

Source Code

Line#

Item

Quantity

Price

7

1

A1

1

$10.00

2

B1

2

$20.00

3

C1

3

$30.00

4

D1

4

$40.00

Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:

Price Code

Seq

Start

End

Qty

Type of Price Code Discount

101

4

2/1/12

4/1/12

1

Dollar off: $2 off 1

202

3

2/1/12

4/1/12

2

Percent off: 10% off 2

303

2

2/1/12

4/1/12

3

Special price: $20.00 each for 3

404

1

2/1/12

4/1/12

3

Group price: $60.00 total for 3

Determine price code customer assignment: The sold to customer on the order qualifies for the following price code in the Price Code Customer table:

Price Code

Customer#

Customer Price Group

303

10

 

Determine price code item assignment: The item on the order that qualifies for price code 303 in the Price Code Details table is:

Price Code

Item

SKU

Source Code

303

C1

 

7

Reprice the order: When you select Reprice at the Order Detail screen, the system reprices as follows:

Line#

Item

Initial Price

Price Code

Reprice

1

A1

$10.00

none

Price remains $10.00

2

B1

$20.00

none

Price remains $20.00

3

C1

$30.00

303

Special price: $20.00 each for 3

Price changes from $30.00 to $20.00

4

D1

$40.00

none

Price remains $40.00

Because the calculated order line price for item C1 is lower than the initial price of the item, the system displays Discount Calculation Messages when you reprice the order: Line 3:Offer = 30.00 Actual = 20.00 Discount = 10.00 :33.33%

Example: Price Code Dollar Off Discount

On 2/17/12, you take an order for sold to customer 10.

Source Code

Line#

Item

Quantity

Price

7

1

A1

1

$10.00

2

B1

2

$20.00

3

C1

3

$30.00

4

D1

4

$40.00

Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:

Price Code

Seq

Start

End

Qty

Type of Price Code Discount

101

4

2/1/12

4/1/12

1

Dollar off: $2 off 1

202

3

2/1/12

4/1/12

2

Percent off: 10% off 2

303

2

2/1/12

4/1/12

3

Special price: $20.00 each for 3

404

1

2/1/12

4/1/12

3

Group price: $60.00 total for 3

Determine price code customer assignment: The sold to customer on the order qualifies for the following price code in the Price Code Customer table:

Price Code

Customer#

Customer Price Group

101

10

 

Determine price code item assignment: The item on the order that qualifies for price code 101 in the Price Code Details table is:

Price Code

Item

SKU

Source Code

101

A1

 

7

Reprice the order: When you select Reprice at the Order Detail screen, the system reprices as follows:

Line#

Item

Initial Price

Price Code

Reprice

1

A1

$10.00

101

Dollar off: $2.00 off 1

Price changes from $10.00 to $8.00

2

B1

$20.00

none

Price remains $20.00

3

C1

$30.00

none

Price remains $30.00

4

D1

$40.00

none

Price remains $40.00

Because the calculated order line price for item A1 is lower than the initial price of the item, the system displays Discount Calculation Messages when you reprice the order: Line 1:Offer = 10.00 Actual = 8.00 Discount = 2.00 :20.00%

Example: Price Code Percent Off Discount

On 2/17/12, you take an order for sold to customer 10.

Source Code

Line#

Item

Quantity

Price

7

1

A1

1

$10.00

2

B1

2

$20.00

3

C1

3

$30.00

4

D1

4

$40.00

Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:

Price Code

Seq

Start

End

Qty

Type of Price Code Discount

101

4

2/1/12

4/1/12

1

Dollar off: $2 off 1

202

3

2/1/12

4/1/12

2

Percent off: 10% off 2

303

2

2/1/12

4/1/12

3

Special price: $20.00 each for 3

404

1

2/1/12

4/1/12

3

Group price: $60.00 total for 3

Determine price code customer assignment: The sold to customer on the order qualifies for the following price code in the Price Code Customer table:

Price Code

Customer#

Customer Price Group

202

10

 

Determine price code item assignment: The item on the order that qualifies for price code 202 in the Price Code Details table is:

Price Code

Item

SKU

Source Code

202

B1

 

7

Reprice the order: When you select Reprice at the Order Detail screen, the system reprices as follows:

Line#

Item

Initial Price

Price Code

Reprice

1

A1

$10.00

none

Price remains $10.00

2

B1

$20.00

202

Percent off: 10% off 2

Price changes from $20.00 to 18.00

3

C1

$30.00

none

Price remains $30.00

4

D1

$40.00

none

Price remains $40.00

Because the calculated order line price for item A1 is lower than the initial price of the item, the system displays Discount Calculation Messages when you reprice the order: Line 2:Offer = 20.00 Actual = 18.00 Discount = 2.00 :10.00%

Example: Price Code Group Price Discount

On 2/17/12, you take an order for sold to customer 10.

Source Code

Line#

Item

SKU

Quantity

Price

7

1

SKA

RED

1

$40.00

2

SKB

BLUE

1

$20.00

3

SKC

GRN

1

$30.00

4

SKD

GREY

1

$40.00

Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:

Price Code

Seq

Start

End

Qty

Type of Price Code Discount

101

4

2/1/12

4/1/12

1

Dollar off: $2 off 1

202

3

2/1/12

4/1/12

2

Percent off: 10% off 2

303

2

2/1/12

4/1/12

3

Special price: $20.00 each for 3

404

1

2/1/12

4/1/12

3

Group price: $60.00 total for 3

Determine price code customer assignment: The sold to customer on the order qualifies for the following price code in the Price Code Customer table:

Price Code

Customer#

Customer Price Group

404

10

 

Determine price code item assignment: The items on the order that qualify for price code 404 in the Price Code Details table are:

Price Code

Item

SKU

Source Code

404

SKA

 

7

404

SKB

 

7

404

SKC

 

7

404

SKD

 

7

Note:            If an item contains SKUs and no SKUs are defined for the item in the Price Code Details table, all SKUs for the item qualify for the price code.

Reprice the order: When you select Reprice at the Order Detail screen, the system reprices in ascending price, order line number sequence

Line#

Item

SKU

Initial Price

Price Code

Reprice

2

SKB

BLUE

$20.00

404

Group price: $60.00 total for 3

Price changes from $20.00 to $13.33

3

SKC

GRN

$30.00

404

Group price: $60.00 total for 3

Price changes from $30.00 to $20.00

1

SKA

RED

$40.00

404

Group price: $60.00 total for 3

Price changes from $40.00 to $26.67

4

SKD

GREY

$40.00

none

Price remains $40.00

merchandise total for lines assigned to price code 404 = $90.00

$90.00 merchandise total - $60.00 group price = $30.00 discount amount to prorate

Note:            Order line 4 does not qualify for the price code 404 discount because you must order the qualifying items in groups of 3. If the customer ordered 2 more qualifying items, the order would qualify for the price code 404 discount two times because it would have two qualifying groups of 3 on the order.

Prorating the Group Price

The system applies the group price discount to each qualifying order line on a pro-rata basis.

Order line 2 calculations:

20.00 extended amount of the detail line before applying discounts / 90.00 discountable order merchandise total = .2222 discount percentage

 

20.00 pre-discount unit price of the detail line - [(30.00 total discount amount to prorate * .2222 discount percentage from above calculation) / 1 line unit quantity] = 13.33 unit selling price

Order line 3:

30.00 extended amount of the detail line before applying discounts / 90.00 discountable order merchandise total = .3333 discount percentage

 

30.00 pre-discount unit price of the detail line - [(30.00 total discount amount to prorate * .3333 discount percentage from above calculation) / 1 line unit quantity] = 20.00 unit selling price

Order line 1:

40.00 extended amount of the detail line before applying discounts / 90.00 discountable order merchandise total = .4444 discount percentage

 

40.00 pre-discount unit price of the detail line - [(30.00 total discount amount to prorate * .4444 discount percentage from above calculation) / 1 line unit quantity] = 26.67 unit selling price

Discount message: Because the calculated order line price for lines 1-3 is lower than the initial price of the item, the system displays Discount Calculation Messages when you reprice the order: Line 3:Offer = 30.00 Actual = 20.00 Discount = 10.00 :33.33%

Example: Applying Multiple Price Codes to the Order

On 2/17/12, you take an order for sold to customer 10.

Source Code

Line#

Item

Quantity

Price

7

1

A1

1

$10.00

2

B1

2

$20.00

3

C1

3

$30.00

4

D1

3

$40.00

Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:

Price Code

Seq

Start

End

Qty

Type of Price Code Discount

101

4

2/1/12

4/1/12

1

Dollar off: $2 off 1

202

3

2/1/12

4/1/12

2

Percent off: 10% off 2

303

2

2/1/12

4/1/12

3

Special price: $20.00 each for 3

404

1

2/1/12

4/1/12

3

Group price: $60.00 total for 3

Determine price code customer assignment: The sold to customer on the order qualifies for the following price codes in the Price Code Customer table:

Price Code

Customer#

Customer Price Group

101

10

 

202

10

 

303

10

 

404

10

 

Determine price code item assignment: The details in the Price Code Details table for the items on the order are:

Price Code

Item

SKU

Source Code

101

A1

 

7

202

B1

 

7

303

C1

 

7

404

D1

 

7

Reprice the order: When you select Reprice at the Order Detail screen, the system reprices as follows:

Line#

Item

Initial Price

Price Code

Reprice

1

A1

$10.00

101

Dollar off: $2 off 1

Price changes from $10.00 to $8.00

2

B1

$20.00

202

Percent off: 10% off 2

Price changes from $20.00 to 18.00

3

C1

$30.00

303

Special price: $20.00 each for 3

Price changes from $30.00 to $20.00

4

D1

$40.00

404

Group price: $60.00 total for 3

Price changes from $40.00 to $20.00

Example: Item Qualifies for More than One Price Code

On 2/17/12, you take an order for sold to customer 10.

Source Code

Line#

Item

SKU

Quantity

Price

7

1

SKA

RED

1

$40.00

2

SKA

BLUE

1

$40.00

3

SKB

GRN

1

$20.00

4

SKC

GREY

1

$30.00

5

SKD

BLCK

1

$40.00

Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:

Price Code

Seq

Start

End

Qty

Type of Price Code Discount

101

4

2/1/12

4/1/12

1

Dollar off: $2 off 1

202

3

2/1/12

4/1/12

2

Percent off: 10% off 2

404

1

2/1/12

4/1/12

3

Group price: $60.00 total for 3

Determine price code customer assignment: The sold to customer on the order qualifies for the following price codes in the Price Code Customer table:

Price Code

Customer#

Customer Price Group

101

10

 

202

10

 

404

10

 

Determine price code item assignment: The details in the Price Code Details table for the items on the order are:

Price Code

Item

SKU

Source Code

101

SKA

 

7

101

SKB

 

7

101

SKC

 

7

101

SKD

 

7

202

SKA

 

7

202

SKB

 

7

202

SKC

 

7

202

SKD

 

7

404

SKA

 

7

404

SKB

 

7

404

SKC

 

7

404

SKD

 

7

Note:            If an item contains SKUs and no SKUs are defined for the item in the Price Code Details table, all SKUs for the item qualify for the price code.

Important:                           You can apply only one price code to an order line. If an order line qualifies for more than one price code and you are using Customer Price Group Price Code Pricing, the system uses the price code that provides the greatest discount. If more than one price code offers the same discount, the system uses the price code with the lowest Sequence number. If more than one price code has the same sequence number, the system uses the price code with the lowest numeric price code.

Reprice the order: When you select Reprice at the Order Detail screen, the system reprices the lines on the order in ascending price, order line number sequence.

Of the price codes that were eligible to apply to the order, price code 404 provided the greatest discount. Because the Multiples field for price code 404 was selected, only the first 3 order lines in ascending price, order line number sequence were eligible for the price code; the remaining order lines did not meet the quantity requirement for price code 404. The system assigned the next price code with the greatest discount (price code 202) to the two remaining items on the order.

Line#

Item

SKU

Initial Price

Price Code

Reprice

The system applies price code 404 to order lines 3, 4 and 1. See Prorating the Group Price for the calculations the system uses to determine the price of each order line assigned to the group price.

3

SKB

GRN

$20.00

404

Group price: $60.00 total for 3

Price changes from $20.00 to $13.33

4

SKC

GREY

$30.00

404

Group price: $60.00 total for 3

Price changes from $30.00 to $20.00

1

SKA

RED

$40.00

404

Group price: $60.00 total for 3

Price changes from $40.00 to $26.67

The system applies price code 202 to order lines 2 and 5:

2

SKA

BLUE

$40.00

202

Percent off: 10% off 2

Price changes from $40.00 to 36.00

5

SKD

BLCK

$40.00

202

Percent off: 10% off 2

Price changes from $40.00 to 36.00

Discount message: Because the calculated order line price for the order lines is lower than the initial price of the item, the system displays Discount Calculation Messages when you reprice the order: Line 4:Offer = 30.00 Actual = 20.00 Discount = 10.00 :33.33%

Example: Price Code Multiples and Distinct By

On 2/17/12, you take an order for sold to customer 10.

Source Code

Line#

Item

SKU

Item Category

Qty

Price

7

1

SKA

SML

A

1

$10.00

2

SKA

SML

A

1

$10.00

3

SKB

SML

B

1

$10.00

4

SKC

SML

C

1

$10.00

5

SKD

SML

D

1

$10.00

6

SKD

MED

D

1

$10.00

7

SKD

LRG

D

1

$10.00

Determine eligible price codes: The order and customer qualify for price code 202 in the Price Code table:

Price Code

Seq

Start

End

Qty

Price Code Discount

202

3

2/1/12

4/1/12

2

Percent off: 10% off 2

Determine price code item assignment: The details in the Price Code Details table for the items on the order are:

Price Code

Item

SKU

Source Code

202

SKA

 

7

202

SKB

 

7

202

SKC

 

7

202

SKD

 

7

Reprice the order: When you select Reprice at the Order Detail screen, the system reprices the lines on the order in ascending price, order line number sequence.

         Multiples Unselected

         Multiples Selected, Distinct By Blank

         Multiples Selected, Distinct By Item

         Multiples Selected, Distinct By SKU

         Multiples Selected, Distinct By Item Category

Multiples Unselected

Because Multiples for price code 202 is unselected, once the order qualifies for the price code based on the price code quantity requirement, the system applies price code 202 to all qualifying items on the order that are not already assigned to a price code.

Line#

Item

SKU

Initial Price

Price Code

Reprice

The system applies price code 202 to order lines 1 and 2:

1

SA

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

2

SA

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

Now that the order qualifies for price code 202, the system applies price code 202 to all qualifying items on the order that are not already assigned to a price code:

3

SB

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

4

SC

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

5

SD

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

6

SD

MED

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

7

SD

LRG

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

Multiples Selected, Distinct By Blank

Because Multiples for price code 202 is selected and the Distinct By is blank, the order must meet the price code quantity requirement again in order to qualify.

Line#

Item

SKU

Initial Price

Price Code

Reprice

The system applies price code 202 to order lines 1 and 2:

1

SA

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

2

SA

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

The system then applies price code 202 to order lines 3 and 4:

3

SB

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

4

SC

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

The system then applies price code 202 to order lines 5 and 6:

5

SD

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

6

SD

MED

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

Order line 7 does not qualify since it does not meet the price code quantity requirement of 2.

7

SD

LRG

$10.00

none

Remains $10.00

Multiples Selected, Distinct By Item

Because Multiples for price code 202 is selected and the Distinct By is Item, the price code requires separate items in the required quantity in order to qualify.

Line#

Item

SKU

Initial Price

Price Code

Reprice

The system applies price code 202 to order lines 1 and 3:

1

SA

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

3

SB

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

The system then applies price code 202 to order lines 2 and 4:

2

SA

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

4

SC

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

Order lines 5, 6 and 7 do not qualify for price code 202 since they do not meet the price code quantity requirement of 2 by item.

5

SD

SML

$10.00

none

Remains $10.00

6

SD

MED

$10.00

none

Remains $10.00

7

SD

LRG

$10.00

none

Remains $10.00

Multiples Selected, Distinct By SKU

Because Multiples for price code 202 is selected and the Distinct By is SKU, the price code requires separate SKUs in the required quantity in order to qualify.

Line#

Item

SKU

Initial Price

Price Code

Reprice

The system applies price code 202 to order lines 1 and 3:

1

SA

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

3

SB

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

The system then applies price code 202 to order lines 2 and 4:

2

SA

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

4

SC

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

The system then applies price code 202 to order lines 5 and 6:

5

SD

SML

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

6

SD

MED

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

Order line 7 does not qualify since it does not meet the price code quantity requirement of 2 by SKU.

7

SD

LRG

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

Multiples Selected, Distinct By Item Category

Because Multiples for price code 202 is selected and the Distinct By is Item Category, the price code requires separate item categories in the required quantity in order to qualify.

Line

Item

SKU

Category

Initial Price

Price Code

Reprice

The system applies price code 202 to order lines 1 and 3:

1

SA

SML

A

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

3

SB

SML

B

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

The system then applies price code 202 to order lines 2 and 4:

2

SA

SML

A

$10.00

none

Percent off: 10% off 2

Price changes from $10.00 to $9.00

4

SC

SML

C

$10.00

202

Percent off: 10% off 2

Price changes from $10.00 to $9.00

Order lines 5, 6 and 7 do not qualify for price code 202 since they do not meet the price code quantity requirement of 2 by item category.

5

SD

SML

D

$10.00

none

Remains $10.00

6

SD

MED

D

$10.00

none

Remains $10.00

7

SD

LRG

D

$10.00

none

Remains $10.00

Customer Price Group Best Price Comparison

After performing Customer Price Group Price Code Pricing and applying any non-freight discounts and promotions (and before applying any freight promotions and order-level coupon promotions), the system looks at the Best Price Comparison field for the customer price group assigned to the sold to customer to determine whether to perform customer price group best price comparison processing.

Customer Price Group Best Price Comparison determines if the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value provides a better price than the customer price group assigned to the sold to customer on the order.

         If the Best Price Comparison field for the customer price group assigned to the sold to customer is unselected, the system does not perform customer price group best price comparison.

         If the Best Price Comparison field for the customer price group assigned to the sold to customer is selected, the system performs customer price group best price comparison.

During customer price group best price comparison, the system:

1.      Performs Line Level Customer Price Group Pricing for the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value.

2.      Performs Customer Price Group Price Code Pricing for the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value.

3.      Calculates the non-freight discounts, line-level coupon promotions, and any other promotions that are eligible for the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value.

4.      Compares the price available for the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value to the price available for the customer price group assigned to the sold to customer on the order.

         If the calculated price for the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value is lower than the calculated price for the customer price group assigned to the sold to customer on the order, the system updates the order line to this lower price.

         If the calculated price for the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value is greater than the calculated price for the customer price group assigned to the sold to customer on the order, the system does not update the price on the order line.

5.      After applying the best price to each order line, the system applies any freight discounts and order-level coupon promotions to the order; see Order-Level Coupon Promotions when using Customer Price Group Pricing.

Manually entered promotions: If the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value is eligible for a promotion that requires manual entry to be applied to the order, the system includes this promotion in the best price comparison only if the promotion code is manually entered on the order.

Free gifts:

         If the sold to customer or order qualifies for a free gift, and after performing best price comparison, the dollar total no longer makes the order qualify, the system will not remove the free gift from the order.

         If the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value qualifies for a free gift, the system will NOT add the item to the order during customer price group best price comparison.

Price method: The system updates the Price method for any order line whose price was updated during customer price group best price comparison to J Repriced Customer Price Group Best Price.

Order transaction history: The system writes an order transaction history message indicating the order line was repriced during customer price group best price comparison; for example:.

Type

Transaction Note

Amount

User

UPSELL PROMO

Best Price price override - Line 2

24.99

TBROWN

Order Detail table: The system stores the calculated price for the default customer price group in the following fields in the Order Detail table.

         Basic customer price 

         Basic customer prediscount price 

         Basic customer original price: The final calculated price of the order line for the customer price group code defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value.

         Customer price group original price: The final calculated price of the order line for the customer price group code assigned to the sold to customer on the order.

         Basic customer price method 

The system compares the Basic customer original price to the Customer price group original price to determine whether the default customer price group provides a better price than the customer price group assigned to the sold to customer on the order.

Order-Level Coupon Promotions when using Customer Price Group Pricing

When using customer price group pricing, the system applies order-level coupon promotions, as defined in Working with Coupon Promotions (WCPR), as the last discount applied to the lines on the order.

         The system applies order-level coupon promotions after applying all other discounts and promotions to the lines on the order, and after performing Customer Price Group Best Price Comparison.

         When applying order-level coupon promotions to the lines on the order, the system applies the coupons to the order as a pro-rated merchandise discount during repricing.

         The system applies the coupon promotion to all lines eligible for the coupon promotion, including non-discountable items.

Customer price group order-level coupon discount calculations: The system uses the following calculations to determine the discount amount to apply to each order line.

The system calculates the Discount Percentage for each order line:

order line extended amount after applying all other discounts and promotions and best price / order merchandise total = discount percentage

The system calculates the Unit Selling Price for each order line:

order line post-discount unit price - [(total order-level coupon amount X discount % from above calculation) / line unit quantity] = unit selling price

For more information: See:

         How Coupons Work for more information on coupon promotions.

         Example: Line Level Best Price Comparison and Example: Price Code Best Price Comparison for examples that apply order-level coupons to an order.

Examples: Customer Price Group Best Price Comparison

         Example: Line Level Best Price Comparison

         Example: Price Code Best Price Comparison

Example: Line Level Best Price Comparison

1. Determine the Customer Price Group to Use. A customer assigned to customer price group CPGO places an order. The Best Price Comparison field for customer price group CPGO is selected, indicating the system uses the best price offered between customer price group CPGO and the default customer price group, CPG, defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value.

2. Determine the Initial Price of the Item.

         The Price type for customer price group CPGO is set to Original, indicating the system uses the Original retail price in the SKU table as the initial price of the item.

         The Price type for customer price group CPG is set to Regular, indicating the system uses the List price in the SKU table as the initial price of the item.

The customer adds item ITO to the order. Item ITO has the following prices defined:

         List price of $25.00

         Original retail price of $20.00

CPGO customer price group

CPG customer price group

Since the Price type for customer price group CPGO is set to Original, the system uses 20.00 as the initial price of the item.

Since the Price type for customer price group CPG is set to Regular, the system uses $25.00 as the initial price of the item.

The customer adds item ITR to the order. Item ITR has the following prices defined:

         List price of $10.00

         Original retail price of $15.00

CPGO customer price group

CPG customer price group

Since the Price type for customer price group CPGO is set to Original, the system uses 15.00 as the initial price of the item.

Since the Price type for customer price group CPG is set to Regular, the system uses $10.00 as the initial price of the item.

3. Determine the Customer Price Group Discount. The Discountable flag for items ITO and ITR is selected, indicating the items are eligible for customer price group discounting.

CPGO customer price group

CPG customer price group

Customer price group CPGO provides a 30.00% discount.

Item ITO: initial price $20.00 - 30.00% = $14.00.

Item ITR: initial price $15.00 - 30.00% = $10.50.

Customer price group CPG provides a 25.00% discount.

Item ITO: initial price $25.00 - 25.00% = $18.75.

Item ITR: initial price $10.00 - 25.00% = $7.50.

 

4. Compare List Price to Order Line Price. The system compares the list price defined for the item to the order line price.

CPGO customer price group

CPG customer price group

The list price for item ITO is $25.00 and the order line price is $14.00. Since the order line price is lower than the list price, the system retains $14.00 as the order line price.

The list price for item ITR is $10.00 and the order line price is $10.50. Since the order line price is greater than the list price, the system updates the order line price to $10.00.

The list price for item ITO is $25.00 and the order line price is $18.75. Since the order line price is lower than the list price, the system retains $18.75 as the order line price.

The list price for item ITR is $10.00 and the order line price is $7.50. Since the order line price is lower than the list price, the system retains $7.50 as the order line price.

5. Calculate Order Header Discounts. The order qualifies for a 25% source discount.

The system applies the 25% source discount to the order.

CPGO customer price group

CPG customer price group

Item ITO: current order line price $14.00 - 25.00% = $10.50.

Item ITR: current order line price $10.00 - 25.00% = $7.50.

Item ITO: current order line price $18.75 - 25.00% = $14.06.

Item ITR: current order line price $7.50 - 25.00% = $5.62.

6. Apply Final Customer Price Group Price to Order. The system applies the final customer price group price for the customer price group CPGO assigned to the sold to customer to the lines on the order:

Note:            Before you reprice the order, the final calculated line level price for the customer price group assigned to the sold to customer on the order displays for each order line. The system does not apply the best price to the each order line until you reprice the order.

Because the calculated order line price for item ITO is lower than the initial price of the item, the system displays Discount Calculation Messages when you add the item to the order: Line 2:Offer = 20.00 Actual = 10.50 Discount = 9.50 :47.50%

Because the calculated order line price for item ITR is lower than the initial price of the item, the system displays Discount Calculation Messages when you add the item to the order: Line 2:Offer = 15.00 Actual = 7.50 Discount = 7.50 :50.00%

The system updates the Order Detail table with the customer price group line level price.

Field

Item ITO

Item ITR

ODT Offer Price

Initial price: 20.00

Initial price: 15.00

ODT Original Price

List price: 25.00

List price: 10.00

ODT Pre-Discount Price

Price after discounts: 10.50

Price after discounts: 7.50

ODT Price

Order line price: 10.50

Order line price: 7.50

Price Method

F = Customer Price Group

F = Customer Price Group

Basic Customer Price

default customer price group price after discounts: 14.06

default customer price group price after discounts: 5.62

Basic Customer Prediscount Price

14.06

5.62

Basic Customer Original Price

final default customer price group price: 14.06

final default customer price group price: 5.62

Customer Price Group Original Price

final sold to customer price group discount: 10.50

final sold to customer price group discount: 7.50

When you select Reprice, the system:

         applies any non-freight discounts, detail-level coupon promotions, and any other promotions to the lines on the order. The offer associated with the order has a free gift defined for a merchandise total of $18.00. Because the merchandise total for the order before performing best price comparison is $18.00 ($10.50 + $7.50), the system adds the free gift to the order.

         compares the prices offered by the customer price group assigned to the sold to customer on the order to the prices offered by the default customer price group and updates the lines on the order to the lowest price offered.

CPGO customer price group

CPG customer price group

Item ITO: final calculated price is $10.50.

Item ITR: final calculated price is $7.50.

Item ITO: final calculated price is $14.06.

Item ITR: final calculated price is $5.62.

Results: 

         Item ITO: The final price for sold to customer price group CPGO $10.50 is lower than the final price for the default customer price group CPG $14.06. The system retains $10.50 as the final price.

         Item ITR: The final price for sold to customer price group CPGO $7.50 is greater than the final price for the default customer price group CPG $5.62. The system updates this order line to $5.62.

8. Apply Order-Level Coupon Promotions to the Order. The order qualifies for an order-level coupon that provides $5.00 off the order.

The system applies the $5.00 order-level coupon discount to each order line on a pro-rata basis. The merchandise total after applying all other discounts and promotions and determining the best price is $16.12 (10.50 + 5.62).

The system uses the following calculations to determine the discount amount to apply to each order line.

The system calculates the Discount Percentage for each order line:

order line extended amount after applying all other discounts and promotions and best price / order merchandise total = discount percentage

Line 1: 10.50 / 16.12 = .65136

Line 2: 5.62 / 16.12 = .3486

The system calculates the Unit Selling Price for each order line:

order line post-discount unit price - [(total order-level coupon amount X discount % from above calculation) / line unit quantity] = unit selling price

Line 1: 10.50 - [(5.00 X .65136) / 1] = $7.24 

Line 2: 5.62 - [(5.00 X .3486) / 1] = $3.88 

Note:            Even though the merchandise total after performing best price comparison and applying any order-level coupons to the order is now $11.12 (while the offer free gift required a merchandise total of $18.00), the system retains the offer free gift that was added to the order.

Order Detail table updates: The system updates the Order Detail table after repricing the order.

Field

Item ITO

Item ITR

ODT Offer Price

Initial price: 20.00

Initial price: 15.00

ODT Original Price

List price: 25.00

List price: 10.00

ODT Pre-Discount Price

Price before reprice: 10.50

Price before reprice: 7.50

ODT Price

Order line price: 7.24

Order line price: 3.88

Price Method

F = Customer Price Group

J = Repriced CPG Best Price

Basic Customer Price

default customer price group price after discounts: 10.49

default customer price group price after discounts: 4.19

Basic Customer Prediscount Price

14.06

5.62

Basic Customer Original Price

default customer price group price before applying order-level coupon: 14.06

default customer price group price before applying order-level coupon: 5.62

Customer Price Group Original Price

sold to customer price group discount before applying order-level coupon: 10.50

sold to customer price group discount before applying order-level coupon: 7.50

Basic Customer Price Method

A = Repriced-prorated discount

F = Customer Price Group

Example: Price Code Best Price Comparison

Determine customer price group: You take an order for sold to customer 10. Sold to customer 10 is assigned to customer price group CPGO. The Best Price Comparison field for customer price group CPGO is selected.

Source Code

Line#

Item

SKU

Quantity

Price

7

1

SKA

RED

1

$40.00

2

SKC

BLCK

1

$30.00

Determine eligible price codes: The date on the Order Header falls within the date range for the following price codes in the Price Code table:

Price Code

Seq

Start

End

Qty

Type of Price Code Discount

101

4

2/1/12

4/1/12

1

Dollar off: $2 off 1

202

3

2/1/12

4/1/12

2

Percent off: 10% off 2

Determine price code customer assignment: The sold to customer on the order and the CPG customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value qualify for the following price codes in the Price Code Customer table:

Price Code

Customer#

Customer Price Group

101

10

 

202

 

CPG

Determine price code item assignment: The details in the Price Code Details table for the items on the order are:

Price Code

Item

SKU

Source Code

101

SKA

 

7

101

SKC

 

7

202

SKA

 

7

202

SKC

 

7

Note:            If an item contains SKUs and no SKUs are defined for the item in the Price Code Details table, all SKUs for the item qualify for the price code.

Reprice the order: When you select Reprice at the Order Detail screen, the system:

         applies any non-freight discounts, detail-level coupon promotions, and any other promotions to the lines on the order. The sold to customer qualifies for a free gift with a merchandise total of $65.00. Because the merchandise total for the order before performing best price comparison is $66.00 ($38.00 + $38.00), the system adds the free gift to the order.

         determines whether the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value provides a greater discount than the customer price group assigned to the sold to customer on the order:

Line#

Item

Initial Price

Price Code

Default Customer Price Group Price

Sold To Customer Price Group Price

1

SKA

$40.00

101

Percent off: 10% off 2

Price changes from $40.00 to 36.00

Dollar off: $2 off 2

Price changes from $40.00 to $38.00

2

SKC

$40.00

202

Percent off: 10% off 2

Price changes from $40.00 to 27.00

Dollar off: $2 off 2

Price changes from $40.00 to $28.00

Results: The price for the customer price group defined in the Customer Price Group Code for CPG Pricing Only (L58) system control value is lower than the price for the customer price group assigned to the sold to customer on the order. Because the price is lower, the system updates the order lines to use the price offered by the default customer price group.

Apply order-level coupons: The order qualifies for an order-level coupon that provides $5.00 off the order.

The system applies the $5.00 order-level coupon discount to each order line on a pro-rata basis. The merchandise total after applying all other discounts and promotions and determining the best price is $63.00 (36.00 + 27.00).

The system uses the following calculations to determine the discount amount to apply to each order line.

The system calculates the Discount Percentage for each order line:

order line extended amount after applying all other discounts and promotions and best price / order merchandise total = discount percentage

order line 1: 36.00 / 63.00 = .5714

order line 2: 27.00 / 63.00 = .4286

The system calculates the Unit Selling Price for each order line:

order line post-discount unit price - [(total order-level coupon amount X discount % from above calculation) / line unit quantity] = unit selling price

line 1: 36.00 - [(5.00 X .5714) / 1] = $33.14

line 2: 27.00 - [(5.00 X .4286) / 1] = $24.86

Note:            Even though the merchandise total after performing best price comparison and applying any order-level coupons to the order is now $58.00 (while the free gift for the sold to customer required a merchandise total of $60.00), the system retains the free gift that was added to the order.

Order Detail table updates: The system updates the Order Detail table after repricing the order.

Field

Item SKA

Item SKC

ODT Offer Price

Initial price: 40.00

Initial price: 30.00

ODT Original Price

List price: 40.00

List price: 30.00

ODT Pre-Discount Price

Price before reprice: 38.00

Price before reprice: 28.00

ODT Price

Order line price: 33.14

Order line price: 24.86

Price Method

J = Repriced CPG Best Price

J = Repriced CPG Best Price

Basic Customer Price

33.14

24.86

Basic Customer Pre-Discount Price

36.00

27.00

Basic Customer Original Price

36.00

27.00

Customer Price Group Original Price

38.00

28.00

Basic Customer Price Method

E = Price code

E = Price code

Customer Price Group Pricing in Order Maintenance

During order maintenance, the system performs Line Level Customer Price Group Pricing when you add, change, or delete the lines on an order.

The system does NOT perform Customer Price Group Price Code Pricing or Customer Price Group Best Price Comparison during order maintenance. The system displays an error message when you select Reprice: Selected function is not valid for current processing mode (Maintain).

 

________________________________