How to Ignore the Price Code by Customer/Product Category for One Item
Release Date: 10/31/2024
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?
EMK
Related Articles
CP0901 Customer Order Processing Price Code File Maintenance
Price Code File Maintenance Application Overview The pricing system is based on price break tables. For example, you could set up a table such that when over 100 of an item are ordered, there is a 5% discount, when over 200 are ordered, there is a ...CP1200 Customer Order Processing Mass Price Change
Mass Price Change Application Overview The Mass Price Change application allows you to modify the prices for a range of items. The program will request a range of item numbers, a specific product category, the percentage of increase or decrease and ...CP1400 Customer Order Processing Price List Report
Price List Report Application Overview The Price List Report application enables you to print out the base price and pertinent discount price information for each item within a selected range of items, product categories, and price code types. (Refer ...CP1101 Customer Order Processing Product Cat/Loc Acct File Maintenance
Product Cat/Loc Acct File Maintenance Application Overview This application allows you to assign sales and cost of goods sold account numbers to product categories by location. In Customer Order Processing, sales account numbers and cost of goods ...CPFUTMNU Customer Order Processing Future Price File Maintenance
Future Price File Maintenance Application Overview Future Price function is used to update the price, standard cost and user-amount fields in the item master file. By using this function, the user can enter a date when the item price, cost, and ...