Creating Item/SKU Offers (MISO)

Purpose: Use Create Item/SKU Offers to indicate that an item is available in an offer and to enter the related pricing and return information.

Using this menu option may be more efficient than selecting the Work with Item/SKUs menu option (fast path = MITM) and advancing to the Create Item Offer or the Create SKU Offer screens if, for example, you are entering offer information for a group of existing items and SKUs.

In this chapter:

Create Item/SKU Offers Screen

Create SKU Offers Screen

For more information: See Performing Initial Item Entry (MITM) for more information on the screens you use to work with items or SKUs.

Create Item/SKU Offers Screen

Purpose: Use this screen to create item and SKU offer information. This screen may be more efficient than selecting the Work with Item/SKUs menu option (fast path = MITM) and advancing to the Create Item Offer Screen if, for example, you are entering offer information for a group of existing items.

How to display this screen: Enter MISO in the Fast path field at the top of any menu or select Create Item/SKU Offer from a menu.

Field

Description

Update SKUs

Indicates whether to update the SKU information.

Selected = Update the SKUs. You advance to the Create SKU Offers Screen when you press Enter so you can enter different information at the SKU level.

Unselected = Do not update the SKUs.

Item

A user-defined code that represents a new unit of inventory. Validated against the Item table.

Alphanumeric, 12 positions; required.

Offer

The offer you would like to include the item/SKU in. Validated against the Offer table.

Alphanumeric, 3 positions; required.

Effective date

The date the price or quantity break discount becomes valid. This date should be on or after the effective date of the offer.

If there are multiple effective dates for the same item/offer, the system uses the price associated with the effective date closest to, but not greater than, the order date. For example, if there are effective dates of Feb. 20, and Mar. 31 and the customer placed an order on April 1, the customer receives the price associated with the effective date of March 31.

Numeric, 6 positions (in user date format); optional.

Sub page

Informational only. You can use this field to call an external program that creates an item alias outside of Order Management System. The system provides a “hook” to the program when a user defines a sub page code and completes this screen or the Create Item Offer Screen in Work with Item/SKUs (fast path = MITM). Once the program completes, Order Management System returns to normal processing. See Working with User Exit/Edit Point (WUEP) for more information on user exit points.

Alphanumeric, 5 positions; optional.

Price

The price at which the item will be sold in this offer, if no discounts are applied and the order date is on or after the effective date. Multiple effective dates and prices can be established for the same item/offer.

Alternate currency pricing: If the Use Alternate Currency Pricing (H89) system control value is selected, the Alt currency price field enables you to enter the price of the item in the offer in the alternate (foreign) currency.

• If you enter the alternate price for the item, the system updates the Price field with the local price, using the conversion rate defined for the offer.

• If you enter the local price for the item, the system updates the Alternate currency price field with the alternate price, using the conversion rate defined for the offer.

• If you enter both an alternate price and local price for the item, the system uses the alternate price you defined and updates the Price field (local price) using the conversion rate defined for the offer.

See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 7 positions with a 2-place decimal; required.

Associate price

The price at which the item will be sold in this offer to associate customers. Associate price is used when the Associate field on the order is selected and the order date is equal to or greater than the effective date.

Numeric, 7 positions with a 2-place decimal; optional.

Tax inclusive price

The price at which the item will be sold in this offer on orders subject to VAT. In tax-inclusive pricing, a "hidden tax" is included in the order detail line for the item rather than accumulating in the Tax bucket.

Included only if the Tax Included in Price (E70) system control value is selected.

Numeric, 7 positions with a 2-place decimal; optional.

Tax incl assoc price (Tax-inclusive associate price)

The price at which the item will be sold to associate customers on orders subject to VAT. In tax-inclusive pricing, a "hidden tax" is included in the order detail line for the item rather than accumulating in the Tax bucket.

Included only if the Tax Included in Price (E70) system control value is selected.

Numeric, 7 positions with a 2-place decimal; optional.

Alt currency price

The price at which the item is sold in this offer in the alternate currency, if no discounts are applied, and the order date is equal to or greater than the effective date.

Included only if the Use Alternate Currency Pricing (H89) system control value is selected. You cannot enter any other item/offer amounts in the alternate currency; all other amounts display in the local currency.

• If you enter the alternate price for the item, the system updates the Price field with the local price, using the conversion rate defined for the offer.

• If you enter the local price for the item, the system updates the Alternate currency price field with the alternate price, using the conversion rate defined for the offer.

• If you enter both an alternate price and local price for the item, the system uses the alternate price you defined and updates the Price field (local price) using the conversion rate defined for the offer.

 

Decimalized currency? The system looks at the Currency table to determine if the currency uses decimals for alternate currency pricing. If the currency has Decimalized currency selected, the system includes decimals when converting to the currency; if the field is unselected, the system rounds to the nearest whole unit of currency. See Decimalized Currency? for conversion calculations and examples.

If the offer is not associated with a currency code, indicating the offer is in the local currency, an error message indicates if you enter a price in the Alternate currency price field: No conversion rate for offer.

Note: The alternate currency price is not stored in any table in Order Management System; the system displays the alternate price based on the local price from the Price field in the Item Price table and the conversion rate defined for the offer.

See Using Alternate Currency Pricing for an overview and required setup.

Numeric, 9 positions with a 2-place decimal; optional.

Special handling

Indicates whether this item is eligible for any type of special handling in this offer (such as monogramming, hemming, etc.).

Selected = This item is eligible for special handling.

Unselected = This item is not eligible for special handling.

If this field is selected and there is a default special handling code defined (see below), OR if you specify special handling for an item in order entry, you advance to the Work with Special Handling Screen or the Work with Custom Special Handling Screen; however, if the special handling code’s:

Suppress S/H window field is selected: the system adds the special handling code and charge to the item without displaying the special handling screen.

Bypass S/H field is selected: you do not advance automatically to the special handling screen unless you enter the special handling code when entering the item; however, you can still advance to the special handling screen by selecting Special Handling for the item.

See Special Handling Overview for more information.

S/H price (Special handling price)

The price to charge the customer for special handling. Use the Evaluate Special Handling Charges by Order Line (D67) system control value whether to add the price just once for each order line, or to multiply the special handling price by the unit quantity on the order.

Numeric, 7 positions with a 2-place decimal; optional.

S/H code (Special handling code)

The additional charge code associated with the type of special handling you are offering for the item.

The system validates that the additional charge code is defined as special handling type standard or custom; the system handles each type in a different way. See Special Handling Overview for more information.

If you enter a special handling code here, you will advance to the Work with Special Handling Screen or Work with Custom Special Handling Screen automatically in order entry; however, if the special handling code’s:

Suppress S/H window field is selected: the system adds the special handling code and charge to the item without displaying the special handling screen.

Bypass S/H field is selected: you do not advance automatically to the special handling screen unless you enter the special handling code when entering the item; however, you can still advance to the special handling screen by selecting Special Handling for the item.

See Special Handling Overview for more information.

Alphanumeric, 2 positions; optional.

Gift wrap

Indicates whether you offer gift wrapping for this item in this offer. Defaults to selected if the Gift Wrap Default (F07) system control value is selected; however, you can override this default.

Selected = This item can be gift wrapped.

Unselected = This item cannot be gift wrapped.

G/W price (Gift wrap price)

The price you are charging to gift wrap this item. The G/W field must be selected to indicate that this item is eligible for gift wrap. The gift wrap price is multiplied by the unit quantity on the order line to arrive at the total gift wrap charge for the order line.

Numeric, 7 positions with a 2-place decimal; optional.

Freight

The freight amount to charge for this item. Multiplied by the unit quantity on the order line to determine the freight charge for this item. Used only if the Freight method field for the Source Code table is set to By Item or Flat Rt/Item.

Numeric, 6 positions with a 2-place decimal; optional.

Hidden freight

Used only with item level freight methods, such as flat rate by item, by item quantity, and by item source.

Hidden freight represents the portion of the item's catalog price that is used for freight. You might define a hidden freight value when the freight charge to ship the item is very high. The hidden freight charge is included in the price of the item so the actual freight charge is not visible to the customer.

Hidden freight is also know as "theoretical" or "buried" freight.

Numeric, 6 positions with a 2-place decimal; optional.

Sale item

Indicates whether the item is on sale.

Valid values are:

selected = This is a sale item.

unselected (default) = This is not a sale item.

If the Exclude Sale Item When Prorating Discounts (I65) system control value is selected, this flag controls whether the item is included in prorated discounts or is included when determining whether an order qualifies for a promotion. See the system control value for more information.

Volume discount

Represents the discount that is applied to the item for larger order quantities.

selected = The item/SKU is eligible for the volume discount.

unselected (default) = The item/SKU is not eligible for the volume discount.

Numeric, 7 positions with a 2-place decimal; optional.

Coupon discount $

Represents the amount that is subtracted from the price when the item is ordered from this offer.

Numeric, 7 positions with a 2-place decimal; optional.

Coupon expiration date

The date the coupon is effective until (i.e., when it expires).

Numeric, 6 positions (in user date format); optional.

Feature/option

Indicates whether the item is considered a featured or optional item in a depiction. A depiction is a photograph or drawing of several items within an offer. The featured item is the focus of the depiction, whereas the optional items are less prominently displayed. For example, if a dining room is depicted, the dining room set may be the featured item and the individual place settings, crystal, and centerpiece may be the optional items.

Valid values are:

Feature = Item is the featured item in the depiction.

Option = Item is an optional item in the depiction.

Optional.

Pickup/new

Indicates whether the item has been carried over from a previous offer or is new to your product offerings.

Valid values are:

Pickup = Item is a pickup item, previously sold in another offer.

New = Item is a new addition in this offer.

Optional.

Warranty

Defines whether the item in this offer is a warranty item.

Valid values are:

Selected = The item in this offer is a warrant item. When an operator adds this item to an order in order entry or order maintenance, the system adds the item to the order at no charge.

Unselected = The item in this offer is not a warranty item.

If the Default Price Override Reason for Warranty Items (G01) system control value contains a price override reason code, the system defaults this code to the Price override code field; otherwise the operator must enter a code.

Required reason code

Defines whether an Order addition reason code is required when the item in this offer is added to an order in order entry or order maintenance. When you specify an add reason code for an item, there is a record of the add reason code stored in an order line history record, available for review at the Display Order Line History Screen.

Valid values are:

selected = The item in this offer requires an add reason code when the item is added to an order in order entry or order maintenance. The Enter Add Reason Window opens when an operator adds this item to an order in order entry or order maintenance.

unselected = The item is this offer does not require an add reason code when the item is added to an order in order entry or order maintenance.

Note: When the item is added automatically to an order through the order API, the add reason code is not required. For example, an item might be added to an order automatically if it is set up as a free gift by source code.

Screen Option

Procedure

Work with alias

Select Work with Alias to advance to the Work with Alias Screen.

Work with SKU offers

Select the Update SKUs field and select OK to advance to the Create SKU Offers Screen. Any information you have entered defaults to this screen.

Create SKU Offers Screen

Purpose: Use this screen to define offer information related to a specific SKU. This screen may be more efficient than selecting the Work with Item/SKUs menu option (fast path = MITM) and advancing to the Create SKU Offer Screen if, for example, you are entering offer information for a group of existing SKUs.

How to display this screen: Select the Update SKUs field at the Create Item/SKU Offers Screen. Any information you have entered at that screen defaults here.

Field

Description

Item

A user-defined code that represents a new unit of inventory. Defaults from the previous screen.

Alphanumeric, 12 positions; display-only.

Offer

The offer in which you are presenting the SKU. Defaults from the previous screen.

Alphanumeric, 3 positions; display-only.

Sel (Select)

Indicates whether the SKU is selected for update.

Valid values:

Select (default) = The SKU is selected for update.

Ignore = The SKU is not selected for update.

Required.

Colr Size Othr

The SKU code and description that is used to further define the item. Validated against the SKU Elements (1,2,3) tables; see Working with SKU Elements (WSK1, WSK2, WSK3).

Alphanumeric, three 4-position fields; display-only.

Price

The price at which you are selling the item/SKU in this offer, if no discounts are applied, and the offer date is equal to or greater than the effective date. Multiple effective dates and prices can be established for the same item/offer. To establish multiple effective dates, see Work with Item Prices Screen (Quantity Price Breaks by Offer).

Numeric, 7 positions with a 2-place decimal; required.

Sale (Sale item)

Indicates whether the item/SKU is on sale in this offer.

Valid values are:

Yes = this item/SKU is on sale

No = this item/SKU is not on sale

If the Exclude Sale Item When Prorating Discounts (I65) system control value is selected, this flag controls whether the item is included in prorated discounts or is included when determining whether an order qualifies for a promotion. See the system control value for more information.

Description

A description of the SKU.

Alphanumeric, 40 positions; display-only.

SH? (Special handling)

Indicates whether this item/SKU is eligible for any type of special handling in this offer (such as, monogramming, hemming, etc.).

Yes = This item/SKU is eligible for special handling.

No = This item/SKU is not eligible for special handling.

If this field is set to Yes and there is a default special handling code defined (see below), OR IF you specify special handling for an item in Order Entry, a pop-up window opens for you to enter special handling instructions.

SH price (Special handling price)

The price that will be charged for special handling. Use the Evaluate Special Handling Charges by Order Line (D67) system control value to specify whether to add the price just once for each order line, or multiply the special handling price by the item quantity for the line.

Numeric, 7 positions with a 2-place decimal; optional.

S/H (Special handling code)

A code that represents the type of special handling that is required for this item/SKU. The special handling can be either standard or custom; the system handles each type in a different way. See Establishing Additional Charge Codes (WADC) and Establishing Custom Special Handling Formats (WSHF).

If you enter a special handling code here, you will advance to the Work with Special Handling Screen or Work with Custom Special Handling Screen automatically in order entry.

Alphanumeric, 2 positions; optional.

GW?(Gift wrap)

Indicates whether this SKU is eligible for gift wrap. If the Gift Wrap Default (F07) system control value is selected, this field defaults to Yes, although you can override it; otherwise, this field defaults to No.

Yes = The item/SKU can be gift wrapped.

No = In this offer, the item/SKU cannot be gift wrapped.

GW price (Gift wrap price)

The price to charge in this offer to gift wrap this item/SKU. The G/W field must be selected to indicate that this item/SKU is eligible for gift wrap. The gift wrap price is multiplied by the total unit that is gift wrapped.

Numeric, 7 positions with a 2-place decimal; optional.

Frt (Freight)

The freight amount to be charged for this item/SKU. Multiplied by the quantity ordered to determine the freight charge for this item. Used only if the Freight method field for the Source Code table is set to By Item or Flat Rt/Item.

Numeric, 6 positions with a 2-place decimal; optional.

Hdn frt (Hidden freight)

Used only with item level freight methods, such as: Flat rate by item, flat rate by item quantity, flat rate by item source, and by item.

Hidden freight represents the portion of the item's catalog price that is used for freight. You might define a hidden freight value when the freight charge to ship the item is very high. The hidden freight charge is included in the price of the item so the actual freight charge is not visible to the customer.

Hidden freight is also known as "theoretical" or "buried" freight.

Numeric, 5 positions with a 2-place decimal; optional.

F/O (feature/option)

Indicates whether the item/SKU is considered a featured or optional item in a depiction in the offer. The featured item is the focus of the depiction; optional items are displayed less prominently. For example, in a depiction of a dress, the shoes and belt depicted may be the optional items.

Valid values are:

Feature = this is the featured item

Option = this is an optional item

Optional.

Pickup/new

Indicates whether the item has been carried over from a previous offer or you are presenting it for the first time in this catalog.

Valid values are:

Pickup = this is a pickup item

New = this is a new item

Optional.

Tax Inclusive Price

The price at which the item/SKU will be sold in this offer on orders subject to VAT. In tax-inclusive pricing, a "hidden tax" is included in the order detail line for the item rather than accumulating in the Tax bucket.

Included only if the Tax Included in Price (E70) system control value is selected.

Numeric, 7 positions with a 2-place decimal; optional.

Asso. price (associate price)

The price at which the item/SKU will be sold in this offer to associate customers. Associate price is used when the Associate field on the order is selected and the order date is equal to or greater than the effective date.

Numeric, 7 positions with a 2-place decimal; optional.

MISO OROMS 17.0 2018 OTN