Use Empty Values as Filters
Use an empty value in your pricing setup as a way to filter the pricing segments that Pricing considers when it prices an item.
Assume you set up pricing segments.
Revenue Potential |
Customer Rating |
Pricing Segment |
Precedence |
---|---|---|---|
Low |
- |
Corporate Segment |
98 |
Low |
- |
International Segment |
100 |
Low |
Low |
Domestic Segment |
100 |
You create a sales order, and Pricing uses the pricing strategy you assigned to Corporate Segment, but you want it to use the pricing strategy you assigned to Domestic Segment.
Pricing uses Corporate Segment because its precedence is 98, and Pricing uses the segment with the lowest precedence.
Next, assume you have three customers.
Customer |
Revenue Potential |
Customer Rating |
---|---|---|
A |
Low |
- |
B |
Low |
- |
C |
Low |
Low |
Note
-
You create a sales order for customer C and find that Pricing uses Corporate Segment but you want to use Domestic Segment, so you adjust precedence for Corporate Segment from 98 to 110.
-
You create another sales order for customer C and find that Pricing now uses International Segment.
-
If you enable Null Is Wildcard for Customer Rating, then Pricing considers all three matrix rows. So, Pricing will pick International Segment or Domestic Segment, depending on which row the query returns first.
-
You want to use Domestic Segment but you don't want to adjust precedence because you have 20 other segments and you don't want a precedence adjustment to impact them.
If you already set up a customer pricing profile for each customer, then do this.
-
In the Pricing Administration work area, click Tasks > Manage Matrix Classes.
-
On the Manage Matrix Classes page, click the value.
Attribute
Value
Name
Pricing Segment
-
On the Edit Matrix Class page, disable null for the customer rating.
Name
Null Is Wildcard
Customer Rating
Doesn't contain a check mark.
Now, Pricing won't consider Corporate Segment or International Segment because their Customer Rating on the pricing segment doesn't contain a value. Instead, it will use Domestic because its Customer Rating does contain a value. Its value is Low.