Example:

Item PA123 has prices in the following offers on a date of 11/16/06:

• OF1 (offer date range 10/1/06-12/31/08):

• $50.00 / quantity = 1 / Effective date = 11/1/06

• $55.00 / quantity = 1 / Effective date = 11/10/06

• $45.00 / quantity = 5 / Effective date = 11/15/06

• OF2 (offer date range 9/1/06 -12/31/08):

• $51.00 / quantity = 1 / Effective date = 11/5/06

• $52.00 / quantity = 1 / Effective date = 11/14/06

• $47.00 / quantity = 1 / Effective date = 11/14/06

Additionally, there is a SKU Price for the XLRG TALL SKU in OF2: $60.00 / quantity = 1 / Effective date = 10/1/06

Result:

• The screen displays the XLRG TALL SKU with an offer of OF2 and a price of $60.00, because the SKU Price overrides the Item Price.

• The screen displays the other SKUs with an offer of OF1 and a price of $55.00:

• The OF1 offer is selected because it has the later start date of 10/1 vs. 9/1

• The $55.00 price is selected because it has the latest Effective date of single-unit Item Prices

S (Status)

(Unlabeled field)

A code displayed to the left of the item number that identifies the selling status code for your items, such as "discontinued." These codes can be used for sorting inventory reports or for cycle counting in a physical inventory.

Item status codes are defined in and validated against the Item Status file. You can assign a status code to an item in the Status field in the Item file or in the SKU file. If a SKU has a different status in the SKU file than in the Item file, the screen displays the SKU status.

Alphanumeric, 1 position; display-only.

Item

The code for an item that you sell. Item numbers are defined in and validated against the Item file.

This is the base item number; the SKU code, if any, appears after the item number to accurately identify the item.

An item alias may display instead of the actual item code. See Displaying Item Aliases.

Enter a full or partial item code, or a valid alias code, to display items in alphanumeric order beginning with your entry. See Displaying Item Aliases on scanning if you are using aliases.

Prompting on this field displays the:

• Alias Selection Screen if the Display Item Alias (D56) system control value is set to Y;

• otherwise, it displays the SKU Cross Reference Selection Screen if the Search SKU Cross Reference (J56) system control value is set to Y and the Display Item Alias (D56) system control value is set to N;

• otherwise, it displays the Item Selection screen, listing all items in your company in alphanumeric order.

Note: The Search Offers for Alias (J68) system control value does not affect the function of this field; if you enter an alias, the system searches all active offers for a match.

• Alphanumeric, 12 positions; optional.

SKU

The specific style of the item, such as its color, size, or style.

Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); display- only.

Whs (Warehouse)

The code for the warehouse where the item is stored. Warehouse codes are defined in and validated against the Warehouse file. See Warehousing Creating and Maintaining Warehouses (WWHS).

Numeric, 3 positions; optional.

Avail (Quantity available)

 The quantity of the item that is available to sell in this warehouse. This quantity includes only reservable locations, not locations defined as defective or return-to-vendor. Item availability is calculated as follows:

On hand - Protected - Reserved - Reserve Transfer - Backordered = Quantity Available

When this field is blank or this value is followed by a minus sign, the item is unavailable or on backorder.

Numeric, 7 positions; display-only, updated by the system.

On ord (Quantity on-order)

 The total item quantity you expect to receive on purchase orders. This value is increased by PO Entry and reduced by PO Receiving.

If you receive purchase orders into suspense, the amount of stock received remains in this field until you place the suspended stock through Suspense placement.

Numeric, 7 positions; display-only, updated by the system.

Ord qty (Order quantity)

The number of units of this item that the customer wants to order.

See Selecting Items Prior to Order Entry.

Numeric, 5 positions; optional.

P/O date (Next expected P/O date)

The date when you next expect to receive this item from your vendor in this warehouse, based on the date entered during PO Entry or calculated using the value in the Lead days field in the Vendor/Item record.

This is the date of the next purchase order you can use for new orders (that is, if there are earlier backordered orders already awaiting a purchase order that you expect to receive in the shorter term).

The next expected purchase order date is cleared once you receive the purchase order through Purchase Order Receipts.

If you receive purchase orders into suspense, run Batch Purchase Order Layering to update this field. Once you place the suspended stock, run Batch Purchase Order Layering again in order to clear this field. See Customer Service Purchase Order Layering and Backorder Notifications.

If an open PO does not exist:

• If the Include Projected Returns in Available Quantity for OE (L68) system control value is set to Y, the system calculates an expected date by adding the FTC -- # of Days for Items without Expected Ship Date (C71) to the current date.

• If the Include Projected Returns in Available Quantity for OE (L68) system control value is set to N, this screen does not display an expected date for items that are not on any open purchase orders, regardless of the setting of the Calculate Expected Date in OE if No PO (J61) system control value.

Finished goods: For finished good items created through the work order process, this field indicates when the finished good will be ready for sale, and is derived from the date entered on the work order header. See Warehousing Finished Good Work Order Processing (WWOR) for more information on work orders.

Drop ships: This date is included for drop ship items only if the Assign Drop Ship Expected Ship Date (I59) system control value is set to Y. See that system control value for more information.

Numeric, 6 positions (MMDDYY format); display-only.

Qty (Next expected quantity)

The number of units of this item ordered on a purchase order that will be available for new orders.

If the Include Projected Returns in Available Quantity for OE (L68) system control value is set to Y, the system includes an item’s Projected return quantity in the next expected quantity. Example: If the open PO quantity is 100 and the projected return quantity is 10, 110 displays as the next expected quantity.

Numeric, 7 positions; display-only.

Item description (unlabeled field below the item)

The description of the item.

By default, both the item description and the SKU description are displayed when you advance to this screen. To toggle between displaying both descriptions or just the SKU description, press F17.

Alphanumeric, 40 positions; display-only.

SKU description (unlabeled field below the item description)

The description of the SKU.

By default, both the item description and the SKU description are displayed when you advance to this screen. To toggle between displaying both descriptions or just the SKU description, press F17.

Alphanumeric, 40 positions; display-only.

Offer

A code representing a catalog or other medium you use to present merchandise to your customers. This can be either:

• the offer you entered at the initial Item Availability screen, or

• the current offer defined in the System Control file if you pressed Enter at the Item Availability Screen (Select Offer), or advanced to this screen by pressing F14 in Order Entry, or

• the offer selected by the system as most current based on its date range and the presence of an Item Price or SKU Price. See Determining the Offer and Price for more information.

Alphanumeric, 3 positions; display-only.

Ofr prc (Offer price)

The most current single-unit price for the item in the selected offer. If there is no current single-unit price, but there is a current multi-unit price, this is the multi-unit price. If there is no current Item Price of SKU Price for the item in the selected offer, this field is blank. See Determining the Offer and Price for more information.

Numeric, 7 positions with a 2-place decimal.

S/O (Soldout control code)

This code defines which calculation the system uses for item soldout processing. For example, you can define a soldout control code to flag items as sold out:

• when available quantity is less than or equal to zero, including open purchase orders and projected returns

• when available quantity is less than or equal to zero, excluding open purchase orders and projected returns

• the item must sold out immediately

See Customer Service Working with Soldout Controls (WSLD).

You assign these codes in the SKU file, or, if the item does not have SKUs, at the second item entry screen.

Displayed only if a soldout code has been assigned to the item or SKU.

Alphanumeric, 2 positions; display-only.

Item

The code for the item the customer wants to order, have shipped from the store, or pick up from the store.

Alphanumeric, 12 positions; display-only.

SKU

The style associated with the item, such as its color, size, and style.

Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); display-only.

Qty (Quantity)

The quantity of the item the customer wants to order.

Order entry: The system adds the item to the order when you press Enter at this screen after selecting a customer for the order.

Store fulfillment: Store fulfillment requests are flagged by a message next to the quantity:

• Store Pickup = add the item to the order as a store pickup. The customer will pick up the item at the store.

• Store Shipment = add the item to the order as a store shipment. The store will ship the item directly to the customer. Once you accept the order, the system automatically deletes each order detail line that represents a store fulfillment request, and sends the Store Fulfillment Request XML Message (StoreFulfillmentRequest) (.NET) to the selected store. See Merchandise Locator and Store Fulfillment Process Overview (.NET) and Merchandise Locator and Store Fulfillment in Item Availability (.NET) for more information.

Changing the quantity: Optionally, you can increase or decrease the quantity to order. If you clear the quantity, or change the quantity to zero, the system displays the Confirm Delete window when you press Enter. Press Enter to confirm the delete; otherwise, press F12 to retain the item.

Numeric, 5 positions; optional.

Avail (Available quantity)

The quantity of this item or SKU currently available to sell in all allocatable warehouses. This quantity includes only reservable locations, not locations defined as defective or return-to-vendor. Item availability is calculated as follows:

On hand - Protected - Reserved - Reserve Transfer - Backordered = Quantity available

When this field is blank or this value is followed by a minus sign, the item is unavailable or on backorder.

Numeric, 7 positions; display-only, updated by the system.

Ofr price (Offer price)

The most current single-unit price for the item in the selected offer. If there is no current single-unit price, but there is a current multi-unit price, this is the multi-unit price. If there is no current Item Price of SKU Price for the item in the selected offer, this field is blank. See Determining the Offer and Price for an overview.

Note: The price indicated here may differ from the actual price charged for the item once you add the item to an order.

Numeric, 7 positions with a 2-place decimal.

Next expected PO date

The date when you next expect to receive this item from your vendor in this warehouse, based on the date entered during PO Entry or calculated using the value in the Lead days field in the Vendor/Item record.

This is the date of the next purchase order you can use for new orders (that is, if there are earlier backordered orders already awaiting a purchase order that you expect to receive in the shorter term).

The next expected purchase order date is cleared once you receive the purchase order through Purchase Order Receipts.

If you receive purchase orders into suspense, run Batch Purchase Order Layering to update this field. Once you place the suspended stock, run Batch Purchase Order Layering again in order to clear this field. See Customer Service Purchase Order Layering and Backorder Notifications.

Finished goods: For finished good items created through the work order process, this field indicates when the finished good will be ready for sale, and is derived from the date entered on the work order header. See Warehousing Finished Good Work Order Processing (WWOR) for more information on work orders.

Drop ships: This date is included for drop ship items only if the Assign Drop Ship Expected Ship Date (I59) system control value is set to Y. See that system control value for more information.

Note: This screen does not display an expected date for items that are currently backordered and are not on any open purchase orders, regardless of the setting of the Calculate Expected Date in OE if No PO (J61) system control value.

Numeric, 6 positions (MMDDYY format); display-only.

Next expected PO quantity

The number of units of this item ordered on a purchase order that will be available for new orders.

Numeric, 7 positions; display-only.

Item description (Unlabeled field below the item)

The description of the item.

Alphanumeric, 40 positions; display-only.

Sku description

(Unlabeled field below the item description)

The description of the SKU. Included only for SKU’d items; otherwise, this line is blank.

Alphanumeric, 40 positions; display-only.

Location

The store location where the customer will pick up the item, or to ship the item. Displayed only for store fulfillment requests.

Alphanumeric, 40 positions; display-only.

Warehouse

The code for the warehouse where the item is available. Warehouse codes are defined in and validated against the Warehouse file.

Numeric, 3 positions; display-only.

Item

The code for a unit of inventory that you sell. Item codes are defined and validated against the Item file.

Alphanumeric, 12 positions; display-only.

SKU

The code for the style of the item, such as its color or size. SKU codes are defined in and validated against the SKU file.

Alphanumeric, three 4-position fields (split SKU) or one 14-position field (full SKU); display-only.

Location

The code for the area in the warehouse where the item is stored. Location codes are defined in and validated against the Location file. Items are assigned to a location in the Item/Warehouse/Location file.

Alphanumeric, 7 positions; display-only.

Typ (Type)

A code that defines the type of warehouse location where the item is stored.

Valid values are:

P = Primary: the main location where you pick an item.

S = Secondary: An additional location used for picking or replenishment.

B = Bulk: an overstock area in the warehouse to store the item in case lots or cartons that you do not break up at Purchase Order Receiving. Bulk locations are used only to replenish primary and secondary locations for an item.

T = Temporary: a location created only so that you can recognize an item as “received” before you assign a permanent location. The system deletes temporary locations when the quantity reaches zero.

You must define a location as “pickable” for the system to print a pick slip for the location.

Alphanumeric, 1 position; display-only.

On hand

The quantity of the item in this location that is available to sell.

Numeric, 7 positions; display-only.

Printed

The number of units of this item that have been allocated in this location (picks slips have been printed).

Numeric, 7 positions; display-only.

Example:

You set up pricing for item AB123 at the item level, with the exception of tall sizes, which use a different price structure. When you display pricing for AB123 BLUE MEDM REG, you advance to the Display Item/Offer Prices screen, which displays Item Prices set up for Item Offers. However, when you display pricing for AB123 BLUE XLRG TALL, you advance to the Display SKU/Offer Prices screen, which displays any SKU Prices set up for SKU Offers, and does not display any Item Prices set up for Item Offers.

Item

The item and description for which you are reviewing pricing information.

Item code: Alphanumeric, 12 positions; display-only.

Item description: Alphanumeric, 30 positions; display-only.

SKU

The SKU information is displayed only when there is pricing set up at the SKU level for this SKU; in this situation, the screen name is Display SKU/Offer Prices rather than Display Item/Offer Prices. See above for a discussion.

SKU: Three 4-position fields (split SKU) or one 14-position field (full SKU); display-only.

SKU description: alphanumeric, 40 positions; display-only.

Curr code (Currency code)

A code that defines the currency for orders you process for this offer.

Note: This field appears only if the Multi Currency by Offer (E03) field in the System Control file is set to Y.

When you enter a source code associated with this offer in Order Entry, the system searches for a price only among offers that share this currency. Additionally, you cannot override the offer on an order detail line to one with a different currency.

The currency used on an order is indicated by the bank code on various screens and reports, such as those having to do with refunds. This is because each currency must be associated with at least one unique bank. When you create a source code, you must specify a division which links to a bank code that is consistent with the currency of the offer.

The currency code is defined in and validated against the Currency file. See Accounts Payable Working with Currency (WCUR).

Alphanumeric, 3 positions; display-only.

Offer code

A code representing the catalog whose prices you are reviewing.

Offers are defined in and validated against the Offer file. Use the Item/SKU Offer file to identify which items/SKUs are carried in the offer. Also, use the Item/SKU Prices file to define price breaks for the item/SKU in the offer.

Alphanumeric, 3 positions; optional.

Qty (Quantity)

The quantity of the item/SKU that must be purchased to receive the price break. Any SKU ordered for this item is counted towards this quantity.

This number is defined in the Qty field in the Item Prices file.

Numeric, 7 positions; display-only.

Price

The selling price of the item for your regular customers who order the required quantity of the item or who belong to the appropriate pricing column.

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

Tax incl (Tax-inclusive price)

The price at which the item is sold on orders subject to tax-inclusive pricing and VAT. Included only if the Tax Included in Price (E70) system control value is set to Y.

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

Gross margin %

The percentage of the item's price that exceeds the cost of the item. You can use gross margin to determine the profit of an item on the order based on the item's selling price.

The Display Gross Margin (A65) secured feature controls the display of this field in order entry, maintenance, inquiry and item availability.

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

Assoc price (Associate price)

The selling price of the item for your associate customers (Associate = Y in the Customer file) who order the required quantity of the item or who belong to the appropriate pricing column.

Items eligible for the price break are repriced automatically and the system updates the pricing method field with *Quantity Break Price.

Numeric, 7 positions with a 2-place decimal; required, calculated by the system.

Tax incl (Tax-inclusive associate price)

The price at which the item is sold to associate customers on orders subject to tax-inclusive pricing and VAT. Included only if the Tax Included in Price (E70) system control value is set to Y.

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

Column (Column number)

The pricing column eligible for this price break.

Customers belonging to this pricing column receive the quantity price break automatically, regardless of the quantity ordered.

Numeric, 2 positions; display-only.

Item

The code for an item that you sell.

Alphanumeric, 12 positions; optional.

SKU

The specific style of the item, such as its color, size, or style.

Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); display- only.

SKU description

The description of a SKU.

Alphanumeric, 40 positions; optional.

Available qty (Quantity available)

The quantity of this item or SKU currently available to sell in all allocatable warehouses. This quantity includes only reservable locations, not locations defined as defective or return to-vendor. Item availability is calculated as follows:

On hand - Protected - Reserved - Reserve Transfer - Backordered = Quantity available

When this field is blank or this value is followed by a negative sign, the item is unavailable or on backorder.

Numeric, 7 positions; display-only, updated by the system.