Price Table Level Override Code (E05)

Purpose: Use this screen to define the price override reason code to use when overriding the maximum price break defined for an item in a price table.

Code Field: Enter the price override reason code to use when overriding the maximum price break level specified for an item in a price table.

If you use price table pricing (discussed in Pricing Values (B31)), you can create pricing levels for items or groups based on total quantity or dollars ordered. You can also specify a maximum price break for an item, which prevents the system from repricing the item to a lower price, even if the item would otherwise qualify. By specifying a maximum price break, but also creating pricing levels that go beyond that price break, you leave yourself the option of “unlocking” the lower price in certain situations.

Example: For example, you create the following pricing levels for item AB100:

Level

Quantity

Price

1

1 to 9

$10.00

2

10 to 19

$9.00

3

20 to 49

$8.00

4

50+

$6.50

You ordinarily sell this item in quantities of 30 or less. You define 3 as your maximum pricing level for item AB100, so that even if a customer orders more than 49, the price will go no lower than $8.00.

Applying the price table maximum in order entry: One of your customers places an order for 100. The Order Entry operator can override the regular maximum level by selecting Change for the item and entering the price override reason specified here, but not entering a price override amount for the item. The system recognizes the override reason, and reprices the item after the operator selects Reprice or Accept.

Applying the price table maximum through the order API: If your web storefront passes this price override reason code (prc_ovr_rsn) for an item and does not pass an actual price (actual_price), the order API recognizes the override reason and reprices the item when it creates the order.

Important: The price override reason code you specify here is reserved for price table override use. You cannot use it as a price override reason when you enter a price override amount for a new order line in order entry. In addition, you cannot use this code for free gifts, accompanying items, or warranty items. If you try to use this price override reason code for anything but price table overrides, the system displays a message similar to the following: Price override reason reserved and cannot be manually entered.

Leave this field blank if you do not need to override maximum levels in price tables.

The price override reason code is a one-position, alphanumeric code, defined in and validated against the Price Override Reason table.

For more information: See:

Establishing Price Override Reason Codes (WPOR)

Working with Price Tables (WPTB)

Inbound Order XML Message (CWORDERIN)

Work with Order Lines Screen (Adding Items to the Order)

IN03_02 OMS 17.1 September 2018 OTN