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 ...Feature - Create Price Code 1 from Item Minimum Price Utility
Release Date: 6/15/2016 This feature gives the user the ability to generate and update price code 1 based on the minimum price field in the Item Master file. The new utility is accessed thru I/M -> Maintenance -> Product Category File. The purpose ...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 ...IM1501 Inventory Management Product Category File Maintenance
Product Category File Maintenance Application Overview The Product Category File Maintenance application maintains a convenient table of inventory item product categories, i.e. grouping similar items together. The category is used on reports, or on ...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 ...