How to Ignore the Price Code by Customer/Product Category for One Item
Version: 7.x & Up
Q - We have price codes set on the Customer / Product Category level by discount depending on the customer. We want to exclude one item that has the same product category from getting any discounts. How do we do it?
A - There are 8 different types of price codes:
1 = Customer/Item No
2 = Customer/Product Category
3 = Customer Type/Item Number
4 = Customer Type/Product Category
5 = Customer Number
6 = Item No
7 = Customer Type
8 = Product Category
The sequence to determine pricing by default is 1, 2, 3, 4, 5, 6, 7 and 8. If the higher priority pricing code match is not found, then the system goes to lower level pricing codes. This sequence, generally speaking, makes sense for everybody. But it can be altered in COP Setup. See sample screen below on field 5 in COP Setup:
In your case, it seems you want to make price code 6 (by item) to have a higher priority than price code 2 (by customer/product category). Then what you can do is to change the above sequence to:
1,6,2,3,4,5,7,8
But you need to be careful with this. If you only have this one or a few items defined in 6 to override price code 2 per your scenario, then you will be OK. On the other hand, if you already use price code 6 extensively as a default pricing to capture the scenarios that are not covered by price code 2, then this method won’t work. What is your scenario?
1,6,2,3,4,5,7,8
But you need to be careful with this. If you only have this one or a few items defined in 6 to override price code 2 per your scenario, then you will be OK. On the other hand, if you already use price code 6 extensively as a default pricing to capture the scenarios that are not covered by price code 2, then this method won’t work. What is your scenario?
EMK