Order Up-Sell

You must use the Sales Order Entry program (P42101) to access the order up-sell item opportunities on sales orders. You click the Order Up-Sell link on the Order Advisor tab or select the Order Up-Sell option in the Go To drop down list to access the Order Up-Sell form (W42X30A).

The system displays order up-sell item opportunities in the Order Up-Sell form which includes the following subforms:

Order Up-Sell All Items Amount Chart (S42X301A)
Order Up-Sell All Items Weight Chart (S42X302A)
Discounts by Reprice Group (S42X30B)
Items in Reprice Group - reprice group name (S42X30D)

The charts in the Totals by Order and fields in the Totals by Reprice Group group boxes contain icons for adjustment information. The system uses the following icons:

Blue diamond: Current order total.
Green circle: Qualifying break. Displays the adjustment the order currently qualifies for and will be applied to the order, based on the current order total.
Yellow inverted triangle: Break within tolerance. Displays the level break within tolerance.
Red square: Displays the level break outside tolerance.

The Order Up-Sell feature uses the accumulation unit of measure for quantity and weight adjustments. The system converts the quantity and weight of each reprice group to the group's accumulation unit of measure. For amount adjustments, the Order Up-Sell feature uses the amount in the order's customer currency in currency mode.

Order up-sell uses the following tables:

Preference Hierarchy File (F40073).
Price Adjustment Type (F4071).
Price Adjustment Detail (F4072).
Free Goods Master File (F4073).
Group Code Key Definition Table (F4092).
Item Key ID Master File (F40941).
Customer Key ID Master File (F40942).
Item Branch File (F4102).
Sales Order Detail File (F4211).

The system stores the order up-sell item opportunities in the following tables:

Order Upsell Item Group Totals Work File (F42X040W).
Order Upsell Item Group Opportunities WF (F42X041W).
Order Level Upsell Candidate Items (F42X050W).