Creating Item/SKU Offers (MISO) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Working with Deferred SKU Offer Changes (WDSO) |
Updating Item/SKU Offers (MUSO)
Purpose: Use Update Item/SKU Offers to update information on multiple Item/SKU Offer records at one time.
The Update Item or SKU Offer(s) Screen is divided into two sections.
• Use the top section to enter the item and SKU for the offers you wish to update, and the update information. You must complete at least one update field to continue.
• Use the lower portion of the screen to enter the offers that you want to update.
The system updates only those fields in which you enter data; all other fields will remain as is.
You can update both the item offer and SKU offer by making changes for the “base” item and leaving the SKU field blank. When you select OK to accept the changes, you advance to the Confirm Multiple SKU Offer Update Window where you select the Update ALL SKU Offers for base item field.
Defaulting active offers: If the Default Active Offers (J07) system control value is selected and you do not manually enter an offer in the Offer fields, the system defaults the 20 most recent active offers to the Offer fields for the entered item: Offers have been defaulted - press Enter to update.
The offers default to the Offer fields in descending Start date sequence.
• If you enter an item without a SKU code, the system defaults the 20 most recent active offers defined for the item.
• If you enter an item and SKU code, the system defaults the 20 most recent active offers defined for the SKU. The system will not default any item offers, even if no SKU offers exist.
Note:
• If the item is not assigned to 20 active offers, the system defaults the available active offers assigned to the item. For example, if the item is assigned to 25 offers, but only 8 offers are active, the system defaults the 8 active offers.
• If the item is assigned to more than 20 active offers, the system evaluates the offer’s Start date to determine the 20 most recent active offers to default.
• If active offers do not exist for the item, the Offer fields remain blank and you must manually enter offers in the Offer fields.
• If you update the Item and/or SKU field, the system will not update the defaulted offers.
• You can manually enter an offer that is a future offer or expired offer.
Update Item or SKU Offer(s) Screen
Use this screen to update information on multiple Item/SKU Offer records at one time.
How to display this screen: Enter MUSO in the Fast Path field at the top of any menu or select Update Item/SKU from a menu.
Field |
Description |
Item |
A unit of inventory. Item codes are defined in and validated against the Item table. Alphanumeric, 12 positions; required. |
Clr Size Wdth (SKU codes) |
The item's unique characteristics, such as its color and size. Alphanumeric, three 4-position fields; required if SKU/offer records exist. |
Effective date |
The date the price or quantity break discount becomes valid. This date should be equal to or greater than the effective date of the offer. The customer receives this price when placing an order on this date or later, if the order is for a great enough quantity. If you establish 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. Example: If you establish effective dates of Feb. 20, and Mar. 31 and the customer places an order on April 1, the customer receives the price associated with the effective date of March 31. Numeric, 6 positions (MMDDYY format); optional. |
Price |
The price at which you are selling the item in this offer, if no discounts are applied, and the order date is on or after the effective date. You can establish multiple effective dates and prices for the same item/offer. See Work with Item Prices Screen (Quantity Price Breaks by Offer). Alternate currency pricing: If the Use Alternate Currency Pricing (H89) system control value is selected, the At 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 you are selling the item in this offer to associate customers. The system uses the associate price when the Associate field on the order is selected and the customer places the order on or after 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-inclusive (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. |
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 one or more of the offers 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. All of the offers you select must be associated with the same currency code, or an error message indicates: Offers with multiple currency codes selected. Note: The alternate currency price is not stored in any table in CWSerenade; 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. |
Page # |
The primary page number where the item appears in the offer. The system uses this assignment for reporting purposes, such as in the Offer Page Analysis Report (OPAR). Numeric, 5 positions; optional. |
Sale item |
Indicates whether the item is on sale in this offer. This flag controls whether to generate a sale credit when the customer returns the item, based also on the payment method and the setting of the Generate Sale Credit for Orders with Sale Items (I64) system control value. Valid values are: • selected = this item is on sale • unselected = this item 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. |
Projected units |
The number of units of this item that you expect to sell in the offer. You enter this number manually; the system does not update this field. The system uses this number in forecasting reports, such as the Inventory Status & Projection Report (ISRP). Numeric, 7 positions; optional. |
Cost |
The cost to include the item in the offer. The system uses this value in square inch analyses and offer page analyses, such as the Offer Page Analysis Report (OPAR), to determine item contribution and profitability. Numeric, 11 positions with a 4-place decimal; optional. |
Freight |
The freight amount to be charged for this item. Multiplied by the quantity ordered. Used only if the Freight method for the source code is By Item or Flat Rt/Item. Numeric, 6 positions with a 2-place decimal; optional. |
Sq. in (Square inch) |
The square inches (not the percentage) that the item occupies on the page. The system uses this value to calculate the profitability of the item. Numeric, 3 positions; optional. |
Hidden freight |
The system uses this value 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 pays freight. You can define a hidden freight value when the freight charge for the item is very high. You include the hidden freight charge in the item price so that the customer is not aware of the actual cost of shipping. Hidden freight posts to a separate G/L number, which you can define in the Division table. Hidden freight is also known as “theoretical” or “buried” freight. Numeric, 6 positions with a 2-place decimal; optional. |
S/H (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. |
Volume discount |
Determines whether you can apply discounts to the item for large order quantities. • selected = This item is eligible for volume discount. • unselected = This item is not eligible for volume discount. |
S/H charge 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. |
Price (Special handling price) |
The price to charge for special handling of the item. The system multiplies this charge by the total unit quantity if the Evaluate Special Handling Charges by Order Line (D67) system control value is unselected. Numeric, 7 positions with a 2-place decimal; optional. |
Expected return % |
The percentage of returns you expect to receive for the item/offer. The system uses this field for forecasting projections and other reports (such as the inventory status and projection report). Numeric, 5 positions with a 2-place decimal; optional. |
G/W flag (Gift wrap flag) |
Indicates whether this item is eligible for gift wrapping in this offer. If the Gift Wrap Default (F07) system control value is selected, this field will default to selected; however, you can override this value. • selected = The item can be gift wrapped. • unselected = The item cannot be gift wrapped. |
Price (Gift wrap price) |
The price to charge for gift wrapping the item. The system multiplies the gift wrap price by the total unit quantity gift wrapped. Numeric, 7 positions with a 2-place decimal; optional. |
Feature/option |
Indicates whether the item 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 might be optional items. Valid values are: • Feature = This is a feature 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 offer. Valid values are: • Pickup = This is a pickup item. • New = This is a new item. Optional. |
Warranty |
Defines whether the item in this offer is a warranty item. Valid values are: • selected = The item in this offer is a warranty 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 the 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. |
Offers |
The offers where the item/SKU should be updated. If the Default Active Offers (J07) system control value is selected and you do not manually enter an offer in the Offer fields, the system defaults the 20 most recent active offers to the Offer fields for the entered item. The offers default to the Offer fields in descending Start date sequence. Offers are defined in and validated against the Offer table. See Working with Offers (WOFR). Alphanumeric, twenty 3 position fields; required. |
Create if record does not exist |
Controls whether to create the Item/offer or SKU/offer record automatically if it doesn't already exist. • selected = Create the record. • unselected (default) = Do not create the record. Note: If this field is unselected and the Update all SKU offers for base item field is selected, the system creates SKU Price records only for those SKUs that are already associated with the offer. |
Screen Option |
Procedure |
Display item/offer or SKU/offer records |
Select Display Offers to advance to the Work with Item Offers Screen or Work with SKU Offers Screen. If the item is a SKU’ed item, you must specify a SKU code before displaying offers. |
Completing this screen: Enter the fields you want to update in the item/SKU offer and select OK. Leave the SKU field blank to update both the item offer and all associated SKU offers for the “base” item. When you select OK to accept the changes, you advance to the Confirm Multiple SKU Offer Update window.
Confirm Multiple SKU Offer Update Window
Use this window to update the item offer and all SKU offers for the item.
Select the Update ALL SKU Offers for base item field to update both the item offer and all SKU offers for this “base” item.
Note: If the Update ALL SKU Offers for base item field is selected and the Create if record does not exist field is unselected, the system creates SKU Price records only for those SKUs that are already associated with the offer.
If you select Exit or select this field, the system updates the item or SKU offer(s) entered and clears the fields so that you can update another item/SKU offer if desired.