Menu 5 Price Maintenance/Price Books
Menu 5.33 – Customer Discounts and Pricing
Take this link for the most updated version of M-5.33 doc.
This menu will eventually replace menu 5.3 and will allow many, many, more options. Because of the wide variety of options it is difficult to explain without running some tests in your stores. We will first explain how the system currently works for customer discounts and pricing, and then explain how the new system works. After that we will list all of the options available when entering your information and follow that up with some examples.
Current system Hierarchy:
1. Individual contracts entered in 5.2 – if finds something uses this price, if not moves on to …
2. Program contracts entered in 5.2 – if finds something uses this price, if not moves on to …
3. Searches 5.3 in order by row and finds the first occurrence of the item and then uses that scenario. This price is then compared to the buckets shown in stock status and the lower of the two is displayed. **Note – it is possible to rearrange rows in 5.3 to alter which price is selected.
New system - Hierarchy for customer pricing Menu 5.33
1. Individual contracts entered in 5.2 – if finds something uses this price, if not moves on to …
2. Program contracts entered in 5.2 – if finds something uses this price, if not moves on to …
3. Searches all of 5.33 to find the absolute lowest price and uses that scenario. If nothing is entered in 5.33 then moves back to old menu 5.3 (as explained above). **Note – Future plans include discontinuing menu 5.3. (It will be replaced by 5.33)
When in OE the buckets that are displayed are based on the above sequence of events. On the OE screen on the lower left had side you may see a small bucket with a code in it such as C1, C2, P1, or P2. This code is for development use and tells the programmers where the bucket pricing came from. The following is for reference for the codes:
C1 – Customer, Product P1 – Program, Product
C2 – Customer, Category P2 – Program, Category
C3 – Customer, Class P3 – Program, Class
C4 – Customer, Type P4 – Program, Type
C5 – Customer, Vendor P5 – Program, Vendor
NOTE: Menu 5.33 will not search any further for other lower prices, when an individual customer price is found
To use Menu 5.33.
CPS - Enter a 'C' for customer, 'P' for *program or 'S' for customer class.
Option ‘C’ – After entering a ‘C’ you will be prompted for the customer number. Enter "L" for lookup, "ALL" for all customers or enter a valid customer number.
Option 'S' - After entering a 'S' you will be prompted for the customer class. Enter a valid customer class.
*The program name or number used in this menu must be entered in customer master contract field (12.2.2.2 screen 2, field 7) for program prices to be effective
PVCTG – Enter one of the following depending on what you are trying to do
P – Enter ‘P’ if you are setting pricing or discounts for a specific product. Then enter the specific product number you are setting up. (Use ‘L’ for lookup) For all products enter "ALL" which allows a Menu 5.33 matrix for all products for a customer.
V – Enter ‘V’ if you are setting pricing or discounts for a specific vendor. Then enter the specific vendor you are trying to set up. (Use ‘L’ for lookup)
C – Enter ‘C’ if you are setting pricing or discounts for a product class. Product classes can be found in Menu 12.3.24. Then enter the product class you are setting up.
T – Enter ‘T’ if you are setting pricing or discounts for a product type. A list of product types can be found in Menu 12.3.25. Then enter the product type you are setting up.
G – Enter ‘G’ if you are setting pricing or discounts for a product category. A list of product categories can be found in Menu 12.3.34. Then enter the product category you are setting up.
NOTE: On the "C"ustomer option, when selecting "ALL" customer numbers, stock status will display the calculated prices from this screen. Enter a "Y" in Menu-12.3.2.2 (Product Master Maintenance), field 21, if you want the Menu-5.33, customer "ALL" price to ALWAYS be used, even if it is higher than the price in field 14.EACH PRICE. Also, if you set this flag to "Y", you will NOT have to block the corp transmission update of this product's price (Menu-12.3.2.2.9, field 4).
Use this link for information on How to Setup New Product Types.
DPOINT - Points to a bucket: CPOINT - Points to a cost:
0 = Each Price 0 = Each Price
01 = First bucket -1 = Branch Cost
02 = Second bucket etc... -2 = Average Cost
06 = Last bucket -3 = Direct Cost
ABC – This is for future development hit <enter> and it will default to all
|
