Updating SKU Offer Prices (MUSK)
Purpose: Use the Update SKU/Offer screen to create or update a SKU/offer price for specific SKUs of an item.
You might want to use this menu option instead of maintaining SKU/offer prices through Work with Item/SKUs, if your company contains items with many SKUs and you want to update multiple SKUs for multiple offers at one time.
The SKU/Offer price information you can update for a SKU’ed item is:
• effective date
• price quantity
• price of the SKU in the offer
• associate price of the SKU in the offer
• special handling flag
• special handling price
• special handling code
• tax inclusive price of the SKU in the offer
• tax inclusive associate price of the SKU in the offer
You can define SKU/offer prices for up to 10 offers at one time.
Number assignment: The SKU Quick Price Update Number number assignment allows more than one user to enter SKU/offer prices at one time. When a user creates a SKU/offer price, the system assigns the SKU/offer price the next number available for this number assignment. See Setting Up the Number Assignment Table (WNUM).
If the item/offer exists: The system creates a SKU/offer using the item/offer information, except for the information you defined for the SKU/offer price.
If the item/offer does not exist: The system creates a SKU/offer using the following information:
• the Gift Wrap Default (F07) system control value defaults to the Gift order field.
• the system defaults the Sale item field to unselected.
• the system defaults the Volume discount field to unselected.
• the system defaults the Column pricing field to unselected.
• the information you defined for the SKU/offer price
The system leaves any remaining fields blank.
In this chapter:
• Exclude SKU Offer Prices Screen
Use this screen to create or update a SKU/offer price for specific SKUs of an item.
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 10 most recent active offers to the Offer field for the entered SKU’ed item: Offers have been defaulted - click OK to update.
The offers default to the Offer fields in descending Start date sequence.
Note: The system does not default any offers until you enter a SKU’ed item, effective date, quantity, and price, and select OK.
You must enter a SKU’ed item on the Update SKU/Offer Screen; however, you cannot enter a SKU code. Because of this, the system always defaults the 10 most recent item offers to the Offer fields.
• If the item is not assigned to 10 active item offers, the system defaults the available active offers assigned to the item. For example, if the item is assigned to 25 item offers, but only 8 item offers are active, the system defaults the 8 active item offers.
• If the item is assigned to more than 20 active item offers, the system evaluates the offer’s Start date to determine the 20 most recent active item 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 change a defaulted offer to another offer, even if the offer is a future offer or expired offer.
How to display this screen: Enter MUSK in the Fast path field at the top of any menu or select Update SKU Offer Prices from a menu.
Field |
Description |
Item |
A user defined code that represents an item. This is the item for which you wish to create or update SKU/offer prices. An error message indicates if you enter a non-SKU’ed item in this field: Invalid item - Item must be SKU’ed. An error message indicates if you enter an item that is not associated with an item/offer: Invalid item - Item/Offer must exist. Item codes are defined in and validated against the Item table. Alphanumeric, 12 positions; required. |
Description |
A description of the item. Updates when you enter an item code in the Item field. Alphanumeric, 40 positions; display-only. |
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 SKU/offer, the system uses the price associated with the effective date closest to, but not greater than, the order date. 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. |
Quantity |
The amount of the item/SKU that the customer must order to receive the discounted (quantity break) price. Numeric, 7 positions; required. |
Tax inclusive price |
The price at which the item will be sold in the specified offer(s) on orders subject to tax-inclusive pricing and VAT. Included only if the Tax Included in Price (E70) system control value is selected. If so, the following message indicates if you do not define a price in this field: Tax Inclusive Price is required entry. Numeric, 7 positions with a 2-place decimal; optional. |
Price |
The price at which the item will be sold in the specified offer(s) when the quantity and effective date are met. Numeric, 7 positions with a 2-place decimal; required. |
Associate price |
The price at which the item will be sold in the specified offer(s) to associate customers. 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 associated price |
The price at which the item will be sold in the specified offer(s) to associate customers on orders subject to tax-inclusive pricing and VAT. Numeric, 7 positions with a 2-place decimal; optional. |
Spec. hand. (Special handling) |
Indicates whether this item is eligible for any type of special handling in this offer, such as monogramming or hemming. Valid values are: Selected = This item is eligible for special handling. When you add this item to an order, you advance to another screen where you can enter special handling instructions. Unselected (default) = This item is not eligible for special handling. |
S/H price (Special handling price) |
The price to charge the customer for special handling. You can specify in the Evaluate Special Handling Charges by Order Line (D67) system control value whether to add the price just once for each order line, or multiply the special handling price by the item quantity for the line. An error message indicates if you define a special handling price and the Special handling field is unselected: Special handling price not allowed when not eligible. The following message indicates if you enter a special handling price and you defined a custom special handling code in the Special handling code field: Special handling charge not allowed with custom format code. 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 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. |
SKU element 1 |
The name of SKU element 1, based on the Split SKU Element Column 1 Heading (A34) system control value. You can define up to 30 SKU element 1 codes for which you wish to create or update SKU/offer prices. You can leave the SKU element 1 fields blank if you wish to update all of the SKU element 1 codes for the item. Alphanumeric, thirty 4-position fields; optional. |
SKU element 2 |
The name of SKU element 2, based on the Split SKU Element 2 Column Heading system control value. You can define up to 30 SKU element 2 codes for which you wish to create or update SKU/offer prices. You can leave the SKU element 2 fields blank if you wish to update all of the SKU element 2 codes for the item. Alphanumeric, thirty 4-position fields; optional. |
SKU element 3 |
The name of SKU element 3, based on the Split SKU Element 3 Column Heading system control value. You can define up to 30 SKU element 3 codes for which you wish to create or update SKU/offer prices. You can leave the SKU element 3 fields blank if you wish to update all of the SKU element 3 codes for the item. Alphanumeric, thirty 4-position fields; optional. |
Offers |
The offers you wish to update with this SKU/offer price information. See Working with Offers (WOFR). You can create or update SKU/offer prices for up to 10 different offers at one time. 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 10 most recent active offers to the Offer fields for the entered item. The offers default to the Offer fields in descending Start date sequence. An error message indicates if you enter the same offer in more than one field: More than one offer A01 has been entered. An error message indicates if you do not define at least one offer: At least one (1) Offer must be entered. Alphanumeric, 3 positions; required. |
Instructions:
1. Complete each necessary field.
2. If you did not define specific SKU codes you wish to update, the system displays the following message: Click OK to update ALL SKUs for Item.
3. Select OK to update the SKU/offer price information, or select Exit to cancel.
4. If you selected OK, you advance to the Exclude SKU Offer Prices Screen, where you can exclude specific SKUs from being updated with this SKU/offer price.
Exclude SKU Offer Prices Screen
Purpose: Use this screen to exclude a specific SKU from being updated with the SKU/offer price you defined.
The system displays all of the valid SKU combinations for the item, based on the SKU codes you entered on the Update SKU/Offer Screen. For example, if you sell mittens in small, medium, and large and in many colors, but only defined the SKU small on the Update SKU/Offer screen, the system would show mittens only in size small in all of the available colors.
How to display this screen: Complete the Update SKU/Offer Screen.
Field |
Description |
Item |
A user defined code that represents an item. This is the item for which you wish to create or update SKU/offer prices. Item codes are defined in and validated against the Item table. Alphanumeric, 12 positions; display-only. |
Quantity |
The amount of the item/SKU that the customer must order to receive the discounted (quantity break) price. Numeric, 7 positions; display-only. |
Description |
A description of the item. Alphanumeric, 40 positions; display-only. |
Price |
The price at which the item will be sold when the quantity and effective date are met. Numeric, 7 positions with a 2-place decimal; display-only. |
Associate price |
The price at which the item will be sold to associate customers. Numeric, 7 positions with a 2-place decimal; display-only. |
Offers |
The offers you selected on the Update SKU/Offer Screen. These are the offers for which you wish to create or update SKU/offer prices. Alphanumeric, 3 positions; display-only. |
SKU elements |
The name of SKU elements 1, 2 and 3, based on the Split SKU Element Column 1 Heading (A34) system control value. The system displays the valid SKU combinations that are eligible for a SKU/offer price update, based on the SKU codes you defined on the Update SKU/Offer screen. Alphanumeric, thirty 4-position fields; optional. |
Exclude? |
Indicates whether you wish to exclude the valid SKU combination from creating a SKU/offer price. Valid values are: Selected = Exclude this SKU combination from creating a SKU/offer price. Unselected = Do not exclude this SKU combination from creating a SKU/offer price. |
1. Select the SKU combinations you wish to exclude from creating a SKU/offer price; otherwise, leave the field blank if you want to create a SKU/offer price for the SKU.
2. Select Process to create the SKU/offer prices, or select Exit to cancel.
3. The system returns you to the Update SKU/Offer screen.
You can view the SKU/Offer prices you created on the Work with SKU Prices screen in Work with Item/SKUs. See Assigning Items/SKUs to Offers.
Note: If the effective date of the SKU/offer price you created matches the effective date of an existing SKU/offer price, the system replaces the existing SKU/offer price with the new SKU/offer price.
| Maintaining SKU Cross Reference Codes (MSKR) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Maintaining Item/SKU/Offer (CPIM) |
MUSK OMSCS 18.1 April 2019 OTN