Chapter 21: Working with Price Tables (WPTB)
Purpose: Use the Work with Price Tables function to define a pricing structure based on unit quantity or total dollars ordered. You can create price breaks for individual items on an order, or for the total order of a group of items. You can also select items to offer as free or reduced-price premiums on qualifying orders.
Unlike other pricing methods, price tables control pricing in both Order Entry and Order Maintenance (other methods apply in Order Entry only). No repricing takes place, however, once you have printed a pick slip for any items on the order.
You can build a table to price most or all of the items and groups of items that you normally offer. By keeping the bulk of your pricing information in the price table, you can reduce the amount of effort required to maintain pricing information.
Download to web storefront: You can use the Downloading B2B E-Commerce Static Files (BBED) menu option to extract price table information for download to the web storefront.
In this chapter:
• Examples of Price Table Pricing
• Example One: Group Quantity Pricing
• Example Two: Group Quantity with Separate Item Pricing
• Example Three: Discount by Group Dollars
• How the System Selects a Price Table Price for an Item
• Work with Price Table Screen
• First Work with Price Table Item Screen
• Create Price Table Item Screen
• Second Work with Price Table Item Screen
• Quantity Pricing Level Information by Item
• Dollar Pricing Level Information by Item
• Copy Price Table Item Window
• First Work with Price Table Group Screen
• Create Price Table Group Screen
• Second Work with Price Table Group Screen
• Quantity Pricing Level Information by Group
• Dollar Pricing Level Information by Group
• Third Work with Price Table Group Screen
• Copy Price Table Group Window
Examples of Price Table Pricing
Purpose: Price tables provide considerable flexibility in creating pricing structures for your company. The following examples illustrate some of the ways you can use this function.
Example One: Group Quantity Pricing
You sell several similar items on the same page in your catalog. Each item is offered at the same price breaks; the customer qualifies for the price breaks by ordering any combination of these items. Additionally, you plan to offer these items at the same price breaks in several catalogs. Rather than defining price breaks individually for each item/offer combination, you can create a group within a price table to define the price breaks, then assign each item to that price table and group. The price table will always provide the same pricing information for each item within the group.
For example, your items are:
• AA100
• AB200
• AC300
• AD400
• AE500
The price breaks for this group of items are:
Quantity |
Price Per Unit |
1 |
$12.99 |
2-5 |
$11.99 |
6-11 |
$10.99 |
12+ |
$9.99 |
A customer places an order for:
Item |
Quantity |
AA100 |
1 |
AB200 |
4 |
AC300 |
5 |
The total unit quantity ordered for this group is 10, which falls within the 6-11 range. The customer pays $10.99 per item.
Example Two: Group Quantity with Separate Item Pricing
This example is similar to example one, in that the total unit quantity for the group determines the price break. In this example, however, you can define a separate pricing structure for each item within the group.
For example, page 10 of your catalog includes the following items, and their associated price breaks:
Item |
Price for 1-5 |
Price for 6-11 |
Price for 12-24 |
Price for 25+ |
BA100 |
$55.99 |
$53.99 |
$51.99 |
$49.99 |
BB200 |
$53.99 |
$51.99 |
$49.99 |
$47.99 |
BC300 |
$27.99 |
$25.99 |
$23.99 |
$21.99 |
BD400 |
$42.99 |
$39.99 |
$36.99 |
$34.99 |
The customer earns the quantity price break for any combination of these items. For example, an order contains:
Item |
Quantity |
BA100 |
2 |
BB200 |
2 |
BC300 |
2 |
The total quantity for the group is 6. The customer pays for each item:
Item |
Quantity |
BA100 |
$53.99 each |
BB200 |
$51.99 each |
BC300 |
$25.99 each |
You can mix and match the pricing structures presented in examples one and two. For example, you can create a group in which some of the items take their prices from the group level (as in example one), while other items have unique pricing (as in example two); yet each item earns its price breaks based on the entire group quantity.
Example Three: Discount by Group Dollars
In this example, you base a discount percentage on the total dollar amount of the group on the order rather than the unit quantity. A pricing structure like this may work best when you sell a group of items with a broad range of prices together.
Your group includes the following items:
Item |
Price |
CA100 |
$50.00 |
CB200 |
$25.00 |
CC300 |
$125.00 |
CD400 |
$5.00 |
You offer a discount based on group dollars as follows:
Total Group Dollars |
Discount Percentage |
$125-$249 |
20% |
$250-$449 |
25% |
$450-$649 |
35% |
$650-$999 |
40% |
$1000+ |
50% |
If the customer's total order from this group comes to less than $125, you charge the full item price. If the customer's total order from the group comes to $125 or more, however, you subtract the percentage indicated from each item on the order. In the case of CD400, the item unit price would be $4.00 ($5.00 - 20%).
Premiums: You can define a premium item to offer based on item quantity or dollars, group quantity or dollars, or both. A premium can be either a free gift or an item you offer at a reduced price. The system offers the premium item in order entry only if the price of the ordered item is derived from the price table.
Maximum levels for items: You can specify a maximum price level to use for an item, yet define price breaks that exceed that maximum. A maximum price level might be useful if you want to give your Order Entry operators the discretion to exceed that maximum when they feel it is appropriate. For example, you can define a maximum price level for item DD500 as $5.00 apiece for a quantity of 500. If a customer orders 10,000, the Order Entry operator can override the maximum price break and offer the item at $3.50 apiece.
Order Entry and Order Maintenance: When you add each item to an order in Order Entry or Order Maintenance, the price that appears may not indicate the final price break. This is because the system cannot know each price break that may apply to the items until you are through entering them.
Depending on your normal procedure in Order Entry, final price breaks will apply after you press F9 or F19; or, you can display repriced lines by pressing F21.
• If the Apply End of Order Discounts during Repricing (J37) system control value is set to Y, and the order is eligible for a premium item, the system will advance you to the Display Premiums Screen (Price Table Premiums) during repricing (F21), initial order accept (F9), and the final order accept (F9 or F19). At this screen, you can elect to add the premium to the order, or delete it if desired. If you select to add the premium to the order, the system immediately adds the premium item to the order.
• If the Apply End of Order Discounts during Repricing (J37) system control value is set to N, and the order is eligible for a premium item, the system will advance you to the Display Premiums Screen (Price Table Premiums) during repricing (F21) and the final order accept (F9 or F19). You can then elect to add the premiums to the order, or delete them if desired. If you select to add the premium to the order, the system actually does not add the premium item to the order until after you accept the order.
To get an accurate picture of pricing and premiums for on order, you should press F21 when you add or remove items from the order. Additionally, you should reprice in Order Maintenance by pressing F21 before you accept the order by pressing F9, to make sure that you have an opportunity to adjust premiums or review pricing with the customer if needed.
How the System Selects a Price Table Price for an Item
There are two places on the system where you can define a price table that may apply to an order:
• in the Price table field in the Source Code file
• in the Default Price Table (E04) field in the System Control file.
The table below indicates how the system searches for an item price in different scenarios.
In the situations of: |
When you enter the item on the order, the system: |
When you accept the order or press F21, the system: |
A Default Price Table (E04) is defined in the System Control file and a different price table is defined for the source code |
Assigns a price from the source code table if it exists; otherwise, goes through the regular pricing routine for the item |
Reprices based on the source code price table, or the default price table if the item record exists there and not in the source code table; otherwise, does not reprice based on price table |
A Default Price Table (E04) is defined in the System Control file and no price table is defined for the source code |
Assigns a price from the default table if you have defined pricing at the item rather than the group level; otherwise, goes through the regular pricing routine for the item |
Reprices based on the default price table if the item record exists there; otherwise, does not reprice based on price table |
A price table is defined for the source code but no Default Price Table (E04) is defined in the System Control file |
Assigns a price from the source code table if it exists; otherwise, goes through the regular pricing routine for the item |
Reprices based on the source code price table if the item record exists there; otherwise, does not reprice based on price table |
Setting up price tables: You might follow the steps below to set up price tables on your system:
1. Create the price table (code and description).
2. Create each price table group within the price table.
3. Create each price table item, and associate each item with a group as desired (you must have first created the price table groups).
4. Create a price override reason code (see Establishing Price Override Reason Codes (WPOR)) for exceeding the maximum price break for an item.
5. Specify the Price table for each desired source code (the pricing method for the source code should be set to D).
6. Specify the system control values related to price tables, described below.
Related system control values: The following system control values affect how the system uses price table information in your company:
• Default Price Table (E04): the price table to use if the Price table field for the Source code is blank, or if the item is not found in the price table defined for the Source code.
• Price Table Level Override Code (E05): the Price Override Reason to use when you give a customer a price break that exceeds the maximum specified for the item in the price table.
• Price Method Sequence/Price Table: the order in which to apply price table pricing relative to other pricing options.
• End of Order Pricing -- Use Price Table Pricing? indicates whether to check a price table for pricing information in Order Entry or Order Maintenance.
• Apply End of Order Discounts during Repricing (J37): if set to Y, the system allows you to immediately add any premium items to the order during repricing (F21), initial order accept (F9), and the final order accept (F9 or F19); otherwise, the system does not add any premium items to the order until after you accept the order.
For more information:
• system control values: Installation Chapter 13: Setting Up Order Entry Values
• price table repricing and adding premiums: Order Entry Chapter 4: Entering Orders Using Header Format
• establishing price override reason codes: Customer Service Chapter 2: Establishing Price Override Reason Codes (WPOR)
• repricing and adding premiums in Order Maintenance: Customer Service Chapter 65: Changing Item Detail Line Information
• specifying a price table for a source code: Chapter 6: Working with Source Codes (WSRC)
Sample screen: Use this screen to review and work with existing price tables in your company, or to advance to the Create Price Table Screen.
How to display this screen: Enter WPTB in the Fast path field at the top of any menu, or select Work with Price Tables from a menu.
PRR0019 DISPLAY Work with Price Table 5/14/97 14:58:37 Mail Order Opt Table Description
Type options, press Enter. 2=Change 3=Copy 4=Delete 5=Display 7=Work w/Items 8=Work w/Groups
123 GROUP QUANTITY PRICING 456 GROUP DOLLAR PRICING
F3=Exit F6=Create F12=Cancel F21=Print list F24=Select Company |
Field |
Description |
Table |
A code representing a price table. A price table can include one or many item groups and many individual items; you use it to define how you will reprice items based on the customer's total order. Alphanumeric, 5 positions; optional. |
Description |
The description associated with the price table. Alphanumeric, 30 positions; optional. |
Screen Option |
Procedure |
Create a new price table |
Press F6 to advance to the Create Price Table Screen. |
Change a price table |
Enter 2 next to a table to advance to the Change Price Table Screen. |
Copy a price table |
Enter 3 next to a table to advance to the Change Price Table Screen. |
Delete a price table |
Enter 4 next to a table. If price table details exist, the following pop-up window appears: Confirm Delete
WARNING - DEPENDENT RECORDS EXIST Press ENTER to confirm delete of all records.
F12=Cancel |
Display a price table |
Enter 5 next to a table to advance to the Change Price Table Screen |
Work with price table items |
Enter 7 next to a table to advance to the First Work with Price Table Item Screen. |
Work with price table groups |
Enter 8 next to a table to advance to the First Work with Price Table Group Screen. |
Purpose: Use this screen to add a new price table to your company. You must create the price table here before you define the pricing structure for items and groups.
How to display this screen: Press F6 at the Work with Price Table Screen.
PRR0021 ENTER Create Price Table 5/14/97 18:09:43 Mail Order
Price Table . Description .
F3=Exit F12=Cancel |
Field |
Description |
Price table |
A code representing a price table you are building to control price breaks for items and groups of items. Alphanumeric, 5 positions. Create screen: required. Change screen: display-only. |
Description |
The description of the price table. Alphanumeric, 30 positions; required. |
To change: Enter 2 next to a price table at the Work with Price Table Screen to advance to the Change Price Table screen. At this screen, you can change only the description. See Create Price Table Screen for field descriptions.
To copy: Enter 3 next to a price table at the Work with Price Table Screen to copy all pricing detail to a new price table.
Copy Price Table Mail Order
From Price Table . : 789 To Price Table . . . To Description . . .
F12=Cancel |
Enter the code and description of the new price table in the To price table and To description fields. See Create Price Table Screen for details.
If you enter the code of an existing price table, the system displays a message such as the following:
Price Table 123 Already Exists. |
In order to copy all price table information to the destination table, you need to delete the table first and then copy.
To display: Enter 5 next to a price table at the Work with Price Table Screen to advance to the Display Price Table screen. This screen displays only the price table code and description. See Create Price Table Screen for details.
First Work with Price Table Item Screen
Purpose: Use this screen to work with each item that takes its pricing from the price table.
How to display this screen: Enter 7 next to a price table at the Work with Price Table Screen.
PRR0046 DISPLAY Work with Price Table Item 5/15/97 12:08:12 Mail Order
Price table : 123 GROUP QUANTITY PRICING
Opt Item SKU Group
Type options, press Enter. 2=Change 3=Copy 4=Delete 5=Display
AA123 AB456 LRGE 11ABC AB456 MEDM 11ABC AB456 SMLL 11ABC GG554 33XYZ GR222 33XYZ HL123 33XYZ JK555 11ABC LJ248 11ABC +
F3=Exit F6=Create F12=Cancel F21=Print list F24=Select Company |
I
Field |
Description |
Item |
A code representing a unit of inventory that you price with this price table. Item codes are defined in and validated against the Item file. Alphanumeric, 12 positions; optional. |
SKU |
Codes representing the item's unique characteristics, such as its color or size. Alphanumeric, 3 4-position fields (split SKU) or 1 14-position field (full SKU); optional. |
Group |
This code represents the price table group that the item belongs to. Alphanumeric, 5 positions; optional. |
Screen Option |
Procedure |
Assign a new item to the price table |
Press F6 to advance to the Create Price Table Item Screen. |
Change price table item information |
Enter 2 next to an item to to advance to the Second Work with Price Table Item Screen. |
Copy price table item information |
Enter 3 next to an item to advance to the Copy Price Table Item Window. |
Delete price table item information |
Enter 4 next to an item to delete it from the price table. |
Display price table item information |
Enter 5 next to an item to advance to the Second Work with Price Table Item Screen; each field will be display-only. |
Create Price Table Item Screen
Purpose: Use this screen to specify the item/SKU to include in a price table before you specify the pricing details for the item.
Note: If you are going to define a pricing structure for the item based on the total dollars or quantity ordered from a group, you need to define the group before entering all pricing details for the item. See First Work with Price Table Group Screen.
How to display this screen: Press F6 at the First Work with Price Table Item Screen.
PRR0044 ENTER Create Price Table Item 5/15/97 14:06:03 Mail Order
Price table . . . : 789 GROUP DISCOUNT ITEM PRICES
Item . . . . . . . 279-PNG SKU Code . . . . .
F3=Exit F12=Cancel |
Field |
Description |
Item |
A code representing a unit of inventory that you price with this price table. Item codes are defined in and validated against the Item file. Alphanumeric, 12 positions; required |
SKU |
Codes representing the item's unique characteristics, such as its color or size. To set up price table pricing for: • All SKUs of a SKUed item: Enter the base item code only. • Individual overrides for selected SKUs of a SKUed item: Create price table pricing for individual SKUs in addition to the base item pricing; the individual records act as overrides for these SKUs only. • Selected SKUs of a SKUed item: Create price table pricing for the selected SKUs only. Alphanumeric, three 4-position fields (split SKU) or one 14-position field (full SKU); optional. |
Completing this screen:
1. Complete the Item field and, optionally, the SKU field(s).
2. You advance to the Second Work with Price Table Item Screen.
Note: If you exit the Second Work with Price Table Item Screen without entering pricing information for the item, you return to the First Work with Price Table Item Screen. Your cursor will be positioned at the item code you have just entered. You can enter 2 next to the item to return to the Second Work with Price Table Item Screen and complete the pricing information, or you can delete the item from the price table by entering 4 next to the item.
Second Work with Price Table Item Screen
Purpose: Use this screen to define the price structure and premiums for an item.
How to display this screen: Complete the Create Price Table Item Screen or enter 2 next to an item at the First Work with Price Table Item Screen.
Note: The detail lines at the bottom of the screen display differently depending on whether the pricing type is based on quantity or dollars. The screen below displays the quantity pricing format; the dollars format is presented in Dollar Pricing Level Information by Group.
PRR0061 CHANGE Work with Price Table Item 4/30/98 8:48:42 EZK Mail Order Price table . : 123 GROUP QUANTITY PRICING Item . : BU001 SKU : Group . Pricing Type . . 2 (1=Item Quantity, 2=Group Quantity, 3=Group Dollars) Maximum Level Item Premium . . N (Y,N) Item SKU Qty Req. $ Req. Qty To Add . Multiple Y Free Gift N Price
Level Qty Price Disc $ Disc % N/C
1 1 5.00 2 5 4.50 3 10 4.00
+
F3=Exit F6=Change F7=Clear F12=Cancel |
Field |
Description |
Price table |
The price table containing the item. Alphanumeric, 5 positions; display-only. |
Price table description (Unlabeled field to the right of the price table) |
The description associated with the price table. Alphanumeric, 30 positions; display-only |
Item |
A code representing a unit of inventory that you price with this price table. Item codes are defined in and validated against the Item file. Alphanumeric, 12 positions; display-only |
SKU |
Codes representing the item's unique characteristics, such as its color or size. The SKU displays only if the item has SKUs and if you set up the pricing information for this particular SKU only, rather than all SKUs of the item. Alphanumeric, 3 4-position fields (split SKU) or 1 14-position field (full SKU); display-only. |
Group |
The price table group that controls pricing for this item. In order to define a pricing structure whose type is either Group Quantity (type 2) or Group Dollars (type 3), you must first create the price table group. See First Work with Price Table Group Screen. If the Pricing type field is set to 1 for Item Quantity yet you enter a price table group code in this field, the system resets the pricing type to 3 for Group Dollars or 2 for Group Quantity, depending on which is the group's pricing type. Alphanumeric, 5 positions; required if the pricing type field is set to either 2 or 3. |
This field indicates how the system should evaluate when the item qualifies for a price break. If you associate the item with a group by entering a value in the Group field, the system will not allow you to select a pricing type that is not consistent with the group's pricing type. Valid values are: 1 = Item Quantity: The item qualifies for price breaks based on the total quantity the customer orders of this particular item/SKU. In Order Entry and Order Maintenance, the system will check the pricing detail information you enter at the bottom of this screen to determine how to reprice the item. The system selects the highest pricing level whose quantity is less than or equal to the quantity of the item on the order. Note: You cannot associate the item with a group if this field is set to 1. |
|
|
2 = Group Quantity (default): The item qualifies for price breaks based on the total quantity the customer orders of all items associated with the same group. In Order Entry and Order Maintenance, the system checks the pricing detail information you enter at the bottom of this screen, if any, to determine how to reprice the item; if there are no pricing levels defined for the item, the system checks the pricing levels defined for the group. The system selects the highest pricing level whose quantity is less than or equal to the quantity of all items from the group on the order. You cannot select Group Quantity as the pricing type unless the group also uses this pricing type. |
|
3 = Group Dollars: The item qualifies for price breaks based on the total dollar value of all items on the order associated with the same group. In Order Entry and Order Maintenance, the system checks the pricing detail information you enter at the bottom of this screen, if any, to determine how to reprice the item; if there are no pricing levels defined for the item, the system checks the pricing levels defined for the group. The system selects the highest pricing level whose dollar value is less than or equal to the total value of all items from the group on the order. (For this purpose, the system uses the total value of items using the level 1, or highest, price.) You cannot select Group Dollars as the pricing type unless the group also uses this pricing type. If you select Group Dollars as the pricing type, the system revises the pricing level fields at the bottom of the screen so you can enter dollar level rather than quantity pricing information. See Dollar Pricing Level Information by Group. Alphanumeric, 1 position; required. |
Maximum level |
This field indicates the maximum pricing level to apply to the item in Order Entry or Order Maintenance without a price override. You can define a maximum level if you want to provide your operators the discretion to offer a special price break for certain customers who place larger orders. The operator must use the price override code defined in the Price Table Level Override Code (E05) field in the System Control file to override the maximum defined here and still apply price table pricing. Numeric, 3 positions; optional. |
Item premium |
This field indicates whether to offer a premium to customers who order a sufficient quantity or dollar total of the item. You can also define premiums at the group level. If you define both, the customer can earn both item premiums and group premiums on the same order. Note: The system offers the premium item in order entry only if the price of the ordered item is derived from the price table. When an order qualifies for one or more premiums, you advance to the Display Premiums Screen (Price Table Premiums) in Order Entry. At this screen, you can indicate whether to add or remove the premium(s) from the order. The customer may not want the premium item, particularly if it is offered at an additional cost. If the Apply End of Order Discounts during Repricing (J37) system control value is set to Y, the system allows you to immediately add any premium items to the order during repricing (F21), initial order accept (F9), and the final order accept (F9 or F19); otherwise, the system does not add any premium items to the order until after you accept the order. In Order Maintenance, you should press F21 to display this screen so that you will be able to change the premium or order information before accepting the order. |
|
Valid values are: Y = The customer can earn a premium by ordering this item. N (default) = The customer cannot earn a premium by ordering this item, although the total of this item may count toward a group premium. Alphanumeric, 1 position; required. |
Item |
The item to offer as a premium on qualifying orders. Alphanumeric, 12 positions; required if the Item premium field is set to Y. |
SKU |
The SKU information that defines the premium item further. Alphanumeric, 3 4-position fields (split SKU) or 1 14-position field (full SKU); required if the Item premium field is set to Y and the premium item has SKUs. |
Qty Reqd (Quantity required) |
The total quantity of the item that the customer must order to qualify for the premium item. Numeric, 5 positions; required if the Item premium field is set to Y and you do not specify a dollar requirement. |
$ Reqd (Dollars required) |
The total dollar amount the customer must order of the price table item to qualify for the premium item. This is the net dollar amount; that is, it is calculated after applying price breaks through the price table. Numeric, 11 positions with a 2-position decimal; required if the Item premium field is set to Y and you do not specify a quantity requirement. |
Qty to add (Quantity to add) |
The quantity of the premium item to add to a qualifying order. Numeric, 5 positions; required if the Item premium field is set to Y. |
Multiple |
This field indicates whether to multiply the quantity of premium items earned by the number of times the order meets the quantity or dollar requirement. For example, if the quantity requirement is 5 and the customer orders 10, this field indicates whether the customer earns 2 premium items or 1. Valid values are: Y (default) = Multiply the premium items earned. N = Offer just one premium item for each qualifying order. Alphanumeric, 1 position; required if the Item premium field is set to Y. |
Free gift |
This field indicates whether the premium item is a free gift. Valid values are: Y = The premium item is free on qualifying orders. N (default) = There is a charge for the premium item on qualifying orders. You will need to enter a premium price, below. Alphanumeric, 1 position; required if the Item premium field is set to Y |
Price (Premium price) |
The dollar amount to charge for the premium item on qualifying orders. Numeric, 7 positions with a 2-place decimal; required if the Item premium field is set to Y and the Free gift field is set to N. |
Tax price (Tax-inclusive premium price) |
The dollar amount to charge for the premium item on qualifying orders that are subject to VAT. This field displays only if the Tax Included in Price (E70) field in the System Control file is set to Y. Numeric, 7 positions with a 2-place decimal; optional. |
Quantity Pricing Level Information by Item
The system displays the pricing level fields differently on the Second Work with Price Table Item Screen depending on whether you define a pricing type based on quantity or dollar value. A sample of the quantity pricing level field layout is presented below.
In Change mode, you can correct or delete existing pricing information. In Add mode, the pricing information fields are blank and enterable, so you can add new pricing information for the item. Press F6 to switch between Add and Change modes.
Note: Do not complete the pricing level fields if you want the item to take pricing level information from the group.
PRR0061 CHANGE Work with Price Table Item 4/30/98 8:48:42 EZK Mail Order Price table . : 123 GROUP QUANTITY PRICING Item . : BU001 SKU : Group . Pricing Type . . 2 (1=Item Quantity, 2=Group Quantity, 3=Group Dollars) Maximum Level Item Premium . . N (Y,N) Item SKU Qty Req. $ Req. Qty To Add . Multiple Y Free Gift N Price
Level Qty Price Disc $ Disc % N/C Tax Price
1 1 5.00 2 5 4.50 3 10 4.00
+
F3=Exit F6=Change F7=Clear F12=Cancel |
Field |
Description |
Level |
The number of the pricing level. Numeric, 3 positions; display-only, assigned by the system. |
Qty (Quantity) |
The quantity of the item that the customer must order to qualify for the pricing level. Numeric, 5 positions; required. |
Price |
The unit price that the customer pays for items that qualify for the pricing level, before calculating any additional discount specified in the price table. Numeric, 7 positions with a 2-place decimal; required. |
Disc $ (Discount dollar amount) |
The amount to subtract from the unit price of items that qualify for the pricing level. For example, if the price is $10.00, and the discount is $1.00, the actual unit price the customer pays for items that qualify for the pricing level is $9.00. Numeric, 7 positions with a 2-place decimal; optional. |
Disc % (Discount percentage) |
The percentage to subtract from the unit price of items that qualify for the pricing level. For example, if the price is $10.00, and the discount is 15, the actual unit price the customer pays for items that qualify for the pricing level is $8.50. Numeric, 5 positions with a 2-place decimal; optional. |
N/C (No charge) |
This field indicates whether the item is offered at no charge at this pricing level. You cannot enter a price, discount dollar amount, or discount percentage if the item is no charge. Valid values are: Y = The item is no charge at this pricing level. N (or blank) = This item has a price. Alphanumeric, 1 position; optional. |
Tax price (Tax-inclusive price) |
The unit price that the customer pays for items that qualify for the pricing level, before calculating any additional discount specified in the price table, on orders subject to VAT. This field displays only if the Tax Included in Price (E70) field in the System Control file is set to Y. If the item is subject to VAT, the system applies any discounts as it normally would if using the regular (tax-inclusive) price. Numeric, 7 positions with a 2-place decimal; required. |
Quantity pricing level example:
Level |
Qty |
Price |
Disc |
$ |
Disc % |
N/C |
1 |
1 |
10.00 |
|
|
|
|
2 |
5 |
9.00 |
|
|
|
|
3 |
10 |
8.50 |
|
|
|
|
4 |
15 |
8.00 |
|
|
|
|
If the customer orders: |
the price is: |
1-4 |
$10.00 apiece |
5-9 |
$9.00 apiece |
10-14 |
$8.50 apiece |
15 or more |
$8.00 apiece |
Even though you have defined a pricing level for the item, it is still subject to any discounts or premiums defined at the group level if the item is part of a price table group.
Dollar Pricing Level Information by Item
Note: Do not complete the pricing level fields if you want the item to take pricing level information from the group.
PRR0048 CHANGE Work with Price Table Item 5/15/97 15:08:58 Mail Order
Price table . : 789 GROUP DISCOUNT ITEM PRICES Item . : 279-PNG SKU : Group . 12ABC Pricing Type . . 3 (1=Item Quantity, 2=Group Quantity, 3=Group Dollars) Maximum Level Item Premium . . N (Y=Yes, N=No) Item SKU Qty Reqd. $ Reqd. Qty To Add 1 Multiple Y Free Gift N Price Tax Price
Level Dollars Price Disc $ Disc % N/C Tax Price
1 .01 .75 .85 2 1.00 .72 .80 3 5.00 .60 .70
F3=Exit F6=Add F7=Clear F12=Cancel |
Field |
Description |
Dollars |
The total dollar amount of the item the customer must order to qualify for the pricing level. The system evaluates the total dollars using the first (highest) pricing level. For example, if the first pricing level is $10.00 for total dollars of $50.00, and the next pricing level is $9.00 for total dollars of $100.00, the system multiplies the unit quantity of the item by $10.00 to determine if the item qualifies for the pricing level. Numeric, 11 positions with a 2-place decimal; required. |
Dollar pricing level example:
Level |
Dollars |
Price |
Disc |
$ |
Disc % |
N/C |
1 |
1.00 |
10.00 |
|
|
|
|
2 |
25.00 |
9.00 |
|
|
|
|
3 |
50.00 |
8.50 |
|
|
|
|
4 |
100.00 |
8.00 |
|
|
|
|
If the customer's total order from the group comes to: |
the price is: |
$1.00 - $24.99 |
$10.00 apiece |
$25.00 - $49.99 |
$9.00 apiece |
$50.00 - $99.99 |
$8.50 apiece |
$100.00+ |
$8.00 apiece |
Note: The total order from the group is calculated using the highest (level one) price.
Even though you have defined a pricing level for the item, it is still subject to any discounts or premiums defined at the group level.
Note: Complete the pricing level fields only if you want the item to use different pricing level information than the group (if any) it belongs to. If you are changing between a quantity and a dollar pricing type and pricing level information exists for the item, you can use F7 to clear the fields so that you can then display the desired field format; however, this will clear all but the default fields (Pricing type, Item premium, Multiple, and Free gift) as well.
Screen Option |
Procedure |
Switch between Add and Change mode |
Press F6. If you are currently in Add mode (in which there are blank pricing fields for you to enter) you will switch to Change mode (in which the existing pricing information displays for you to correct or delete it). If you are currently in Change mode, you will switch to Add mode. |
Clear all but the default fields |
Press F7. Note: This function key is not available in Add mode. |
To copy: Enter 3 next to an item at the First Work with Price Table Item Screen to display the Copy Price Table Item pop-up window.
Copy Price Table Item Mail Order
Price Table . . . : 456 Item Number . . . : BALL SKU Code . . . . : LRGE To Price Table . . To Item Number . . To SKU . . . . . .
F12=Exit |
You can copy the information to the same item code in a different price table, a different item code in the same price table, or a different item code in a different price table. Each field on this screen is described under Create Price Table Screen and Second Work with Price Table Item Screen.
First Work with Price Table Group Screen
Purpose: Use this screen to create, change, copy, delete, or review pricing information for a group of items within a price table.
How to display this screen: Enter 8 next to a price table at the Work with Price Table Screen.
PRR0029 DISPLAY Work with Price Table Group 5/16/97 12:14:39 Mail Order
Price Table : 123 GROUP QUANTITY PRICING
Opt Group Description
Type options, press Enter. 2=Change 3=Copy 4=Delete 5=Display
12ABC PERFORMANCE INCENTIVES 34DEF SEASONAL GREETING CARDS 56GHI MOTIVATIONAL POSTERS 78JKL PAY ENVELOPE ENCLOSURES
F3=Exit F6=Create F12=Cancel F21=Print list F24=Select Company |
Field |
Description |
Group |
A code representing a group of items within a price table that share pricing information. Alphanumeric, 5 positions; optional. |
Description |
The description associated with the price table group. Alphanumeric, 30 positions; optional. |
Screen Option |
Procedure |
Create a new price table group |
Press F6 to advance to the Create Price Table Group Screen. |
Change a price table group |
Enter 2 next to a group to advance to the Third Work with Price Table Group Screen. |
Copy a price table group |
Enter 3 next to a group to advance to the Copy Price Table Group Window. |
Delete a price table group |
Enter 4 next to a group to delete it. |
Display a price table group |
Enter 5 next to a group to advance to the Third Work with Price Table Group Screen; each field will be display-only. |
Create Price Table Group Screen
Purpose: Use this screen to define a group's code and description before completing its pricing information.
How to display this screen: Press F6 at the First Work with Price Table Group Screen.
PRR0038 ENTER Create Price Table Group 5/16/97 12:25:47 Mail Order
Price table . . . : 123 GROUP QUANTITY PRICING
Group . . . . . . . Description . . . .
F3=Exit F12=Cancel |
Field |
Description |
Group |
A code representing a group of items within a price table that share the same pricing type, group premium (if any), and, potentially, pricing level information. Alphanumeric, 5 positions; required. |
Description |
The description associated with the price table group. Alphanumeric, 30 positions; required. |
Completing this screen: You advance to the Second Work with Price Table Group Screen.
Note: If you exit the Second Work with Price Table Group Screen without entering pricing information for the item, you return to the First Work with Price Table Group Screen. Your cursor will be positioned at the group code you have just entered; however, the system will not have created the record. You must create the group again by pressing F6.
Second Work with Price Table Group Screen
Purpose: Use this screen to specify pricing information for a group of items within a price table.
How to display this screen: Complete the Create Price Table Group Screen.
Note: The detail lines at the bottom of the screen display differently depending on whether the pricing type is based on quantity or dollars. See Dollar Pricing Level Information by Group.
PRR0030 CHANGE Work with Price Table Group 4/16/97 12:47:29 Mail Order
Price table 123 GROUP QUANTITY PRICING Group . . . . . . . : 12ABC PERFORMANCE INCENTIVES Price Type . . . . . . . (2=Quantity, 3=Dollars) Discount % . . . . . Group Premium . . . . . . (Y=Yes, N=No) Item . SKU Qty Reqd. $ Reqd. Qty To Add Multiple Y Free Gift N Price Tax Price
Level Qty Price Disc $ Disc % N/C Tax Price
F3=Exit F7=Clear F12=Cancel |
Field |
Description |
Price table |
The price table containing the group. Alphanumeric, 5 positions; display-only. |
Price table description (Unlabeled field to the right of the price table) |
The description associated with the price table. Alphanumeric, 30 positions; display-only. |
Group |
The group of items within the price table whose pricing information you are defining. Alphanumeric, 5 positions; display-only. |
Description |
The description associated with the price table group, as you defined it on the Create Price Table Group Screen. You have the option of changing it here. Alphanumeric, 30 positions; required. |
Price type |
This field indicates how the system should evaluate when items belonging to this group qualify for a price break. Valid values are: 2 = Group Quantity (default): Items qualify for price breaks based on the total quantity the customer orders of all items associated with this group. In Order Entry and Order Maintenance, the system checks the pricing detail information you entered for the item, if any, to determine how to reprice the item; if there are no pricing levels defined for the item, the system checks the pricing levels defined for the group. The system selects the highest pricing level whose quantity is less than or equal to the quantity of items from the group on the order. |
|
3 = Group Dollars: Items qualify for price breaks based on the total dollar value of all items on the order associated with this group. In Order Entry and Order Maintenance, the system checks the pricing detail information you entered for the item, if any; if there are no pricing levels defined for the item, the system checks the pricing levels defined for the group. The system selects the highest pricing level whose dollar value is less than or equal to the total value of items from the group on the order. For this calculation, the system uses each item's level 1 (highest) price. If you select Group Dollars as the price type, the system revises the pricing level fields at the bottom of the screen so you can enter dollar level rather than quantity pricing information. See Dollar Pricing Level Information by Group. Alphanumeric, 1 position; required. |
The percentage discount to subtract from the item price of every item within the price table group, after applying any discounts you define at pricing level detail lines, either for an item within the group or at the group level. For example, if you define a discount of 15% here, and an additional discount of $1.00 for the first pricing level for an item or group, the system subtracts the discount amount from a $10.00 price as follows: $10.00 - $1.00 = $9.00 $9.00 - $1.35 (15% of $9.00) = $7.65 The customer pays $7.65 for the item. Numeric, 5 positions with a 2-place decimal; optional. |
|
Group premium |
This field indicates whether the customer can earn a premium item for total orders within the price table group. If you have defined an item premium for an individual item within the group, the customer can earn both premiums. When an order qualifies for one or more premiums, you advance to the Display Premiums Screen (Price Table Premiums) in Order Entry. At this screen, you can indicate whether to add or remove the premium(s) from the order. The customer may not want the premium item, particularly if it is offered at an additional cost. If the Apply End of Order Discounts during Repricing (J37) system control value is set to Y, the system allows you to immediately add any premium items to the order during repricing (F21), initial order accept (F9), and the final order accept (F9 or F19); otherwise, the system does not add any premium items to the order until after you accept the order. In Order Maintenance, you should press F21 to display this screen so that you will be able to change the premium or order information before accepting the order. |
|
Valid values are: Y = The customer can earn a premium item. N = The customer cannot earn a premium item from this group. Alphanumeric, 1 position; required. |
Item |
The code representing the item you are offering as a group premium. Item codes are defined in and validated against the Item file. Alphanumeric, 12 positions; required if the Group premium field is set to Y. |
SKU |
The premium item's unique characteristics, such as its color and size. Alphanumeric, 1 14-position field (full SKU) or 3 4-position fields (split SKU); required if the Group premium field is set to Y and the item has SKUs. |
Qty reqd (Quantity required) |
The total unit quantity the customer must order of items belonging to the group in order to qualify for the premium item. Numeric, 5 positions; required if the Group premium field is set to Y and you do not specify a dollar requirement. |
$ Reqd (Dollars required) |
The total dollar amount the customer must order of items within the group to qualify for the premium item. The dollar total is the net total; that is, it is calculated based on the dollars after applying discounts and repricing through the price table. Numeric, 11 positions with a 2-position decimal; required if the Group premium field is set to Y and you do not specify a quantity requirement. |
Qty to add (Quantity to add) |
The unit quantity of the premium item to add to a qualifying order. Numeric, 5 positions; required if the Group premium field is set to Y. |
Multiple |
This field indicates whether to multiply the premium item quantity by the number of times the order qualifies for the premium. For example, if the dollar requirement for 2 free premium items is $100.00, and the group total is $200.00, this field indicates whether the customer has earned 2 or 4 premiums. Valid values are: Y (default) = The customer earns an additional premium item (or quantity of the premium item, if the Qty to add field is equal to more than 1) for each multiple of the qualifying quantity or dollars. N = The customer earns only one premium item (or quantity of the premium item, if the Qty to add field is equal to more than 1) per order. Alphanumeric, 1 position; required. |
Free gift |
This field indicates whether to add the premium item to the order as a free gift, or whether there is a price attached to the premium item. Valid values are: Y = Add the premium item to the order free of charge. N (default) = There is a charge for the premium item. Alphanumeric, 1 position; required. |
Price |
The price to charge for the premium item, if the Free gift? field is set to N. Numeric, 7 positions with a 2-place decimal; required if the Group premium field is set to Y and the Free gift field is set to N |
Tax price (Tax-inclusive premium price) |
The dollar amount to charge for the premium item on qualifying orders that are subject to VAT. This field displays only if the Tax Included in Price (E70) field in the System Control file is set to Y. Numeric, 7 positions with a 2-place decimal; optional. |
Quantity Pricing Level Information by Group
The system displays the pricing level fields differently on the Second Work with Price Table Group Screen depending on whether you define a price type based on quantity or dollar value.
PRR0030 CHANGE Work with Price Table Group 4/16/97 12:47:29 Mail Order
Price table 123 GROUP QUANTITY PRICING Group . . . . . . . : 12ABC PERFORMANCE INCENTIVES Price Type . . . . . . . (2=Quantity, 3=Dollars) Discount % . . . . . Group Premium . . . . . . (Y=Yes, N=No) Item . SKU Qty Reqd. $ Reqd. Qty To Add Multiple Y Free Gift N Price Tax Price
Level Qty Price Disc $ Disc % N/C Tax Price
F3=Exit F7=Clear F12=Cancel
|
Field |
Description |
Level |
The number of the pricing level. The system assigns a sequential number to each pricing level after you enter the information. Numeric, 3 positions; display-only, assigned by the system. |
Qty (Quantity) |
The quantity of items within the group that the customer must order to qualify for the pricing level. Numeric, 5 positions; required. |
Price |
The unit price that the customer pays for items that qualify for the pricing level, before calculating any additional discount. Numeric, 7 positions with a 2-place decimal; required. |
Disc $ (Discount dollar amount) |
The amount to subtract from the unit price of items that qualify for the pricing level. For example, if the price is $10.00, and the discount is $1.00, the actual unit price the customer pays for items that qualify for the pricing level is $9.00. This discount is applied before the Discount % (Discount percentage), if any, defined for the group. Numeric, 7 positions with a 2-place decimal; optional |
Disc % (Discount percentage) |
The percentage to subtract from the unit price of items that qualify for the pricing level. For example, if the price is $10.00, and the discount is 15, the actual unit price the customer pays for items that qualify for the pricing level is $8.50. Numeric, 5 positions with a 2-place decimal; optional. |
N/C (No charge): |
This field indicates whether items within the group are offered at no charge at this pricing level. You cannot enter a price, discount dollar amount, or discount percentage if the item is no charge. Valid values are: Y = The items are no charge at this pricing level. N (or blank) = This item has a price at this level. Alphanumeric, 1 position; optional |
Tax price (Tax-inclusive price) |
The unit price that the customer pays for items in the group that qualify for the pricing level, before calculating any additional discount specified in the price table, on orders subject to VAT. This field displays only if the Tax Included in Price (E70) field in the System Control file is set to Y. If the item is subject to VAT, the system applies any discounts as it normally would if using the regular (tax-inclusive) price. Numeric, 7 positions with a 2-place decimal; required. |
Quantity pricing level example:
Level |
Qty |
Price |
Disc |
$ |
Disc % |
N/C |
1 |
1 |
10.00 |
|
|
|
|
2 |
5 |
9.00 |
|
|
|
|
3 |
10 |
8.50 |
|
|
|
|
4 |
15 |
8.00 |
|
|
|
|
If the customer orders: |
the price is: |
1-4 |
$10.00 apiece |
5-9 |
$9.00 apiece |
10-14 |
$8.50 apiece |
15 or more |
$8.00 apiece |
If you define pricing level details for any item that belongs to the group, the system uses those prices, although it still uses the total quantity for the group to determine the qualifying price level.
Dollar Pricing Level Information by Group
A sample of the pricing level field layout you use for a group dollars pricing type is presented below.
PRR0030 CHANGE Work with Price Table Group 4/16/97 12:47:29 Mail Order
Price table 456 DOLLAR LEVEL PRICING Group . . . . . . . : 456BC PERFORMANCE INCENTIVES Price Type . . . . . . . (2=Quantity, 3=Dollars) Discount % . . . . . Group Premium . . . . . . (Y=Yes, N=No) Item . SKU Qty Reqd. $ Reqd. Qty To Add Multiple Y Free Gift N Price Tax Price
Level Dollars Price Disc $ Disc % N/C Tax Price
1 .01 .75 .85 2 1.00 .72 .80 3 5.00 .60 .70
F3=Exit F7=Clear F12=Cancel
|
Field |
Description |
Dollars |
The total dollar amount of items associated with the group that the customer must order to qualify for the pricing level. The system evaluates the total dollars using the first (highest) pricing level. For example, if the first pricing level is $10.00 for total dollars of $50.00, and the next pricing level is $9.00 for total dollars of $100.00, the system multiplies the unit quantity of the item by $10.00 to determine the qualifying price level. Numeric, 11 positions with a 2-place decimal; required. |
Dollar pricing level example:
Level |
Dollars |
Price |
Disc |
$ |
Disc % |
N/C |
1 |
1.00 |
10.00 |
|
|
|
|
2 |
25.00 |
9.00 |
|
|
|
|
3 |
50.00 |
8.50 |
|
|
|
|
4 |
100.00 |
8.00 |
|
|
|
|
If the customer's total order from the group comes to: |
the price is: |
$1.00 - $24.99 |
$10.00 apiece |
$25.00 - $49.99 |
$9.00 apiece |
$50.00 - $99.99 |
$8.50 apiece |
$100.00+ |
$8.00 apiece |
Note: The total order from the group is calculated using the highest (level one) price.
If you have defined unique pricing level information for an item, it is still subject to any discounts or premiums defined at the group level if it belongs to a group.
How to complete this screen: If you are changing between a quantity and dollar pricing type, press Enter to change the pricing level field format. Complete the pricing level fields only if you want items within the group to inherit group-level pricing information (for each item that has no item-level pricing information defined).
Note: If you are changing between a quantity and a dollar pricing type and pricing level information exists for the group, you can use F7 to clear the fields so that you can then display the desired field format; however, this will clear all but the default fields (Price type, Group premium, Multiple and Free gift) as well.
Third Work with Price Table Group Screen
To change: Enter 2 next to a group at the First Work with Price Table Group Screen. You can also advance to this screen in display-only mode by entering 5 next to a group at the First Work with Price Table Group Screen. In change mode, you can change any information on this screen except the price table and group. For field descriptions, see Second Work with Price Table Group Screen.
PRR0041 CHANGE Work with Price Table Group 4/16/97 12:47:29 Mail Order
Price table 123 GROUP QUANTITY PRICING Group . . . . . . . : 12ABC PERFORMANCE INCENTIVES Price Type . . . . . . . (2=Quantity, 3=Dollars) Discount % . . . . . Group Premium . . . . . . (Y=Yes, N=No) Item . SKU Qty Reqd. $ Reqd. Qty To Add Multiple Y Free Gift N Price Tax Price
Level Qty Price Disc $ Disc % N/C Tax Price
F3=Exit F7=Clear F12=Cancel |
To copy: Enter 3 next to a price table group at the First Work with Price Table Group Screen to display this window:
Copy Price Table Group Mail Order
From Price Table . . . : 456 From Group . . . . . . : 12ABC To Price Table . . . . . To Price Group . . . . . Copy Price Table Item . . . Y
F12=Cancel |
You must complete each field in this window to copy the group. You can copy the group to a different group within the same price table, or to a different price table.
If you set the Copy price table item field to Y, the system will copy each price table item along with the group as long as the item does not already exist for that price table. The system will not replace an existing price table item record. If you set the Copy price table item field to N, the system copies only the group information.
The system does not copy the group description. You must enter 2 next to the destination group to enter a description.
| Chapter 20: Assigning Price Codes (APCD) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 22: Package Insert Processing (WPIP) |
MK02_07 CWDirect 18.0 August 2015 OTN