Working with Offers (WOFR)

Purpose: An offer represents the medium that you use to present merchandise to your customers, for example a catalog, space advertisement, television advertisement, or web site. Use Work with Offers to create and change offer information, define items as free gifts, and set up freight charges, service charges, discounts and telemarketing specials for an offer.

Multiple currencies: You also must define a currency for the offer if you process orders in multiple currencies (the Multi Currency by Offer (E03) system control value is set to Y).

Alternate currency pricing: You also must define a currency and conversion rate for the offer if you use alternate currency pricing (the Use Alternate Currency Pricing (H89) system control value is set to Y.

In this topic:

Work with Offers Screen

Create Offer Screen

Change Offer Screen

Display Offer Screen

Work with Offer Free Gifts Screen

Work with Offer Dollar Discounts Screen

Work with Telemarketing Specials Screen

Delete Telemarketing Specials Window

Work with Linked Offers Screen

Linked Offers in Order Entry

Copy Offer Freight Charges Window

Update Prices? Window

Work with Offers Screen

Purpose: Use this screen to work with information in existing offers or create a new offer.

How to display this screen: Enter WOFR in the Fast path field at the top of any menu or select Work with Offers from a menu.

MSR0015 DISPLAY Work with Offers 11/30/00 8:57:02

KAL Co.

Opt Offer Description Type Begin End Sea

Type options, press Enter.

2=Change 4=Delete 5=Display 7=Free gifts 10=Freight chgs 11=Service Chgs

12=Dollar dsc 13=Telemrkt spcls 14=Linked Ofrs 15=Cpy Frt Chgs 98=User Fld

A01 OFFER A01 - SPECIAL EDITION C 9/30/98 9/01/99 YER

B FALL SPECIALS C 8/20/97 11/01/97 FAL

BBQ BACKYARD SUMMER BARBEQUE IDEAS C 5/01/98 12/01/98 SUM

B01 BO1 OFFER C 1/01/99 12/31/00

CAN CANADIAN OFFER C 6/06/97 6/06/98 YER

JOY THE JOY OF THE HOLIDAYS C 10/01/97 1/10/98 FAL

MAW THE GREAT WIDE YONDER C 6/13/97 6/13/98 YER

SUM OFFER INITILIZED C 12/01/99 12/01/00

T01 OFFER T01 - DISCOUNT DEALS C 3/26/97 10/31/97 5 +

F3=Exit F6=Create F12=Cancel F21=Print list F24=Select company

Field

Description

Offer

The unique code that identifies the catalog, space, television advertisement or web site you use to accept orders.

Alphanumeric, 3 positions; optional.

Description

The description of the offer.

Alphanumeric, 30 positions; optional.

Type

The code that describes the type of offer. This is a user-defined code that is not validated against any file.

Use offer type codes for reporting and analysis.

Alphanumeric, 1 position; optional.

Begin (Begin date)

The first date when you can begin to accept orders for the offer.

Numeric, 6 positions (MMDDYY format); optional.

End (End date)

The last date that you can accept orders for the offer.

Numeric, 6 positions (MMDDYY format); optional.

Sea (Season)

A code that represents a season to display offers; used for tracking and analysis.

Alphanumeric, 3 positions; optional.

Screen Option

Procedure

Create an offer

Press F6 to advance to the Create Offer Screen.

Change an offer

Enter 2 next to an offer to advance to the Change Offer Screen.

Delete an offer

Enter 4 next to an offer to delete an offer.

Note: You cannot delete an offer if there are any orders for this offer. You must use Initializing an Offer (MOFI).

Display an offer

Enter 5 next to an offer to advance to the Display Offer Screen.

Define items as free gifts for an offer

Enter 7 next to an offer to advance to the Work with Offer Free Gifts Screen.

Define freight charges for an offer

Enter 10 next to an offer to advance to the Work with Dollar Chart by Offer Screen (Freight Charges).

Define service charges for an offer

Enter 11 next to an offer to advance to the Work with Dollar Chart by Offer Screen (Service Charges).

Define dollar discounts for an offer

Enter 12 next to an offer to advance to the Work with Offer Dollar Discounts Screen.

Define items as telemarketing specials for an offer

Enter 13 next to an offer to advance to the Work with Telemarketing Specials Screen.

Define a sub-offer for an offer

Enter 14 next to an offer to advance to the Work with Linked Offers Screen.

Copy freight charges from one offer to another

Enter 15 next to an offer whose freight charges you want to copy to advance to the Copy Offer Freight Charges Window.

Define a user defined field

Enter 98 next to an offer to advance to the Work with User Fields screen. See Setting Up User-Defined Fields (WUDF).

Create Offer Screen

Purpose: Use this screen to create a new offer.

How to display this screen: Press F6 on the Work with Offers Screen.

MSR0017 ENTER Create Offer 3/28/02 10:05:36

KAB Co.

Offer number . . . . . . . .

Description . . . . . . . .

Offer type code . . . . . .

Offer date range . . . . . . to

Currency of offer . . . . .

Conversion rate . . . . . .

Season . . . . . . . . . . .

# of pages . . . . . . . . . Square inches/page

Publication cost . . . . . . Insert cost . . .

Flat freight rate . . . . .

Guaranteed order charge . .

Additional charge code . . . (Guaranteed service charges)

Additional charge code . . . (Dollar chart charges)

Curve . . . . . . . . . . .

Report sort sub-total . . .

Date of 1st order . . . . :

Default source . . . . . . .

Update offer/drop/period at detail level(Y,N)

F3=Exit F12=Cancel

Field

Description

Offer number

The unique code that identifies the catalog, space, television advertisement or web site you use to accept orders.

Alphanumeric, 3 positions.

Create screen: required.

Change screen: display-only.

Description

The description of this offer.

Alphanumeric, 30 position; required.

Offer type code

The code that describes the type of offer. This is a user-defined code that is not validated against any file.

Use offer type codes for reporting and analysis.

Alphanumeric, 1 position; required.

Offer date range

The start and end dates for the prices you define for this offer. Orders entered prior to the start date and after the end date will not use these prices. The system searches backwards by end date for the next most recent price and does not consider an offer with a start date greater than the order date. If the system can not find a price, it displays an invalid price message in Order Entry.

If you process orders in multiple currencies, the system searches for a price only in offers with the same currency. See the Currency of offer (when using multiple currency by offer) field.

Note: If you change the start date in the Offer date range at the Change Offer Screen, the Update Prices? Window opens. At this window, you need to indicate whether to change any existing prices for items and SKU’s in the offer that used the previous effective date. See that window for more information.

Numeric 6 positions each (MMDDYY format); required.

Currency of offer (when using alternate currency pricing)

The currency for orders you process for this offer when using alternate currency pricing.

Note: This field displays only if the Use Alternate Currency Pricing (H89) system control value is set to Y.

If you enter a currency code in this field, you must enter a conversion rate in the Conversion rate (when using alternate currency pricing) field or an error message displays: Conversion rate required.

Leave this field blank if this offer is in your local currency (the currency code defined in the Local Currency Code (A55) system control value).

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.

The currency and conversion rate used on an order are stored in the Order Header Extended file.

Currency codes are defined in and validated against the Currency file; see Accounts Payable Working with Currency (WCUR).

See Customer Service Using Alternate Currency Pricing for an overview and required set up.

Alphanumeric, 3 positions; required if you enter a conversion rate.

Conversion rate (when using alternate currency pricing)

The rate at which the currency defined for the offer is converted to and from the local currency if you are using alternate currency pricing.

Note: This field displays only if the Use Alternate Currency Pricing (H89) system control value is set to Y.

If you enter a conversion rate in this field, you must enter a currency code in the Currency of offer (when using alternate currency pricing) field or an error message displays: Offers require a currency when using multi-currency.

Leave this field blank if this offer is in your local currency (the currency code defined in the Local Currency Code (A55) system control value).

The system multiplies the amount in the local currency by the conversion rate to determine the amount in the alternate currency. Likewise, the system divides the amount in the alternate currency by the conversion rate to determine the amount in the local currency. The local currency is the currency code defined in the Local Currency Code (A55) system control value.

See Customer Service Using Alternate Currency Pricing for an overview and required set up.

Numeric, 11 positions with a 7-place decimal; required if you enter a currency of offer.

Season

The code that represents the season associated with this offer. Season codes are defined in and validated against the Season file. See Working with Season Codes (WSEA).

Season codes are used for reporting and analysis.

Alphanumeric, 3 positions; optional.

Currency of offer (when using multiple currency by offer)

The currency for orders you process for this offer when using multiple currency by offer.

Note: This field appears only if the Multi Currency by Offer (E03) system control value is set to Y.

When you enter a source code associated with this offer in Order Entry, the system will search 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; required if it appears on the screen.

# of pages

The total number of pages in this (catalog) offer. This value is used in profitability analysis.

The number of pages should not include inserts, but should include front and back covers if the covers advertise items and/or the cost of covers are included in the overall cost.

Numeric, 5 positions; optional.

Square inches/page

The size of a (catalog) offer page. This value is used in offer square inch and profitability analysis.

Numeric, 3 positions; optional.

Conversion rate (when using multiple currency by offer)

The current conversion rate in effect for the currency, as specified in the Currency file.

Note: This field appears only if the Multi Currency by Offer (E03) system control value is set to Y.

The actual conversion rate displays only on the Change and Display Offer screens, once you have specified the currency for the offer.

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

Publication cost

The overall cost of publishing this offer. This value is used in profitability analysis.

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

Insert cost

The cost to publish the insert included in this offer.

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

Flat freight rate

The amount of freight charged to the customer for each shipping address on an order. You need to set the Freight method for the source code to the Flat rate by ship-to (F) method to use this freight method. The system uses the Flat freight rate defined for the offer only if there is not a Flat amount defined for the source code on the order header.

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

Guaranteed order chg

The charge required to guarantee an order. If the Guaranteed Order Charge field in Order Entry is set to Y, the charge defined in this field is added to the order as an additional charge and is included in the Charge bucket.

You can exclude the Guaranteed Order Charge at the source code level. See the Exclude serv chg (Exclude service charges) field.

For more information: See Work with Dollar Chart by Offer Screen (Service Charges) for background on service charges.

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

Addl charge code (Additional charge code for Guaranteed service charges)

If you defined a Guaranteed Order Charge in the previous field, you must enter a code in this field to identify the type of charge. This code is validated against the Additional Charges Code file; see Customer Service Establishing Additional Charge Codes (WADC). This code points to the General Ledger account number to which these charges post.

Alphanumeric, 2 positions; required if Guaranteed order charge was entered.

Addl charge code (Additional charge code for Dollar chart charges)

A code that represents the type of additional charge on an order. The additional charge refers to a service charge, if one has been defined in Working with Dollar Chart by Offer (WDCO) or Working with Dollar Chart by Source Code (WDCS).

This code is validated against the Additional Charges Code file; see Customer Service Establishing Additional Charge Codes (WADC). This code points to the General Ledger account number for posting these charges.

For more information: See Work with Dollar Chart by Offer Screen (Service Charges) for background on service charges.

Alphanumeric, 2 positions; optional.

Curve

The projection curve that indicates the weekly percentage of response you expect to receive from this offer. Curves are used in the Forecasting system to predict the success and item requirements of an offer. The curve you enter is validated against the Projection Curve file; see Working with Projection Curves (WCRV).

Numeric, 3 positions; optional.

Report sort/sub-total

The user-defined code that can be used as a report sort or subtotal.

Alphanumeric, 3 positions; optional.

Date of first order

The date you process the first order for this offer. The system creates this record.

Numeric, 6 positions (MM/DD/YY format); display-only, defined by the system.

Default source

A source code the system defaults to an order.

• If the Default Offer Source Code to Order Detail Line (G28) system control value is set to Y, the system defaults this source code to an order detail line when the offer on the detail line is not associated with the source code on the order header.

• If the Default Unknown Source Code (I58) system control value contains a source code, the system defaults this source code to the order header if the original source code entered on the order matches the source code in this system control value. Additionally, if this system control value contains a source code, the system requires you to enter a default source for the offer. If you haven’t created the source codes for the offer yet, you must enter a “dummy” source code until you create the actual default source code and then go back to the offer and enter the actual source code in the Default source field.

• If the Update Source Code from Mail History (J94) system control value is set to Y, the system updates the source code and offer on an order line based on the most recent customer mail history associated with the item on the order line. See this system control value for more information.

Source codes are defined in and validated against the Source Code file. See Working with Source Codes (WSRC).

Alphanumeric, 9 positions; required if the Default Unknown Source Code (I58) system control value contains a source code.

Update offer/drop/ period at detail level

Defines whether the system tracks demand statistics at the order detail level or at the order level.

When you enter an order, the Order Async updates demand statistics (number of orders, number of units, and dollar value of merchandise) for offers. You can use this information for forecasting purposes, or you can download it to an external forecasting application such as the Forerunner IF/SO Interface (EFOR, DFOR).

Enter Y in this field if you want to track demand statistics separately for this offer on an order.

Enter N (default) or leave this field blank if you want to consolidate demand statistics for an entire order into the offer associated with the order header.

For examples of demand tracking at order line level, see Forerunner IF/SO Interface (EFOR, DFOR).

Alphanumeric, 9 positions; optional.

Change Offer Screen

To change: Enter 2 next to the offer you want to change at the Work with Offers Screen to advance to the Change Offer Screen. For field descriptions, see Create Offer Screen. You can change all of the information except the Offer code field.

Note: If you change the start date in the Offer date range, the Update Prices? Window opens. At this window, you need to indicate whether to change any existing prices for items and SKU’s in the offer that used the previous effective date. See that window for more information.

Display Offer Screen

To display: Enter 5 next to the offer at the Work with Offers Screen to advance to the Display Offer screen. You cannot change any fields on this screen. For field descriptions, see Create Offer Screen.

Work with Offer Free Gifts Screen

Purpose: Use this screen to define the items to add as free gifts to orders that amount to a required merchandise dollar total.

Free gifts applied when? If the Apply End of Order Discounts during Repricing (J37) system control value is set to Y, the system determines if the order is eligible for the free gift during repricing, the initial order accept, and the final order accept; if the order is eligible for the free gift, the system applies it to the order. Otherwise, the system adds the free gift to the order after the final order accept. Regardless of the setting of the system control value, a pop-up window indicates that the free gift has been added.

Price override: The system uses the Default Price Override Reason (B35) system control value to add the free gift at no charge. If an offer price has been established for a free gift, the dollar amount of the free gift posts to the Discount General Ledger number in the Division file.

VAT amount: If a VAT Hidden tax amt (Hidden tax amount), rather than a percentage, is specified for the item, the system still posts this amount when updating sales figures and the general ledger. For a free item, this has the effect of posting a credit. No VAT is posted if a percentage, defined either at the item or country level, applies to the item. See the Tax Included in Price (E70) system control value.

Things to note: The following factors influence how the system adds free gifts to the order:

Offer price or selling price? To evaluate whether an order qualifies for a free gift, the system compares the total merchandise dollar value after applying any discounts or repricing (that is, the extended selling price of all items) with the $ required specified for the free gift.

Multiple gifts?

• If the Allow multiple gifts flag is set to Y, the system adds the free gift defined for each dollar threshold met by the order total. For example, if a free gift is defined for an order total of $10.00, $15.00, and $20.00 and the customer orders $30.00 worth of merchandise, the system will add the free gifts for a $10.00, $15.00, and $20.00 order.

• If the Allow multiple gifts flag is set to N, the system adds the free gift defined for the highest dollar threshold met by the order total. For example, if a free gift is defined for an order total of $10.00, $15.00, and $20.00 and the customer orders $17.50 worth of merchandise, the system will add the free gift defined for a $20.00 order, because this is the highest level for which the order qualifies.

Group? If a Group is specified for the free gift, the order must include items within that group with a total merchandise dollar value that meets or exceeds the % required.

Expiration date? If an Expiration date is specified for a free gift and the current date is after this Expiration date, the order does not qualify for the free gift.

Source vs. offer free gifts: You can also set up free gifts at the source code level using the Work with Source Free Gifts Screen; however, free gifts by source code override free gifts by offer. If an order would qualify for both the offer and source code free gifts, only the source code's free gift is added to the order.

How to display this screen: Enter 7 next to an offer on the Work with Offers Screen.

FGR0006 CHANGE Work with Offer Free Gifts 10/04/05 15:07:00

EZK Mail Order

Offer . . . . . . . . : OFR WELCOME TO XMAS

Allow multiple gifts? . Y (Y,N)

$ Required Group Exp Date Item COLR SIZE WDTH Qty

25.00 33 123105 ABC123 1

50.00 33 123105 XYZ456 1

F3=Exit F12=Cancel

Field

Description

Offer

The unique code and description for the catalog, space, television advertisement or web site from which you accept orders.

Offer: Alphanumeric, 3 positions; display-only.

Description: Alphanumeric, 30 positions; display-only.

Allow multi gifts? (Allow multiple gifts?)

Indicates if a customer can receive more than one free gift on an order.

Y = Apply more than one free gift on an order if the order qualifies.

N = Apply only free gift with the highest dollar level for which the order qualifies.

Alphanumeric, 1 position; required.

$ Required

The merchandise dollar amount required on an order for the customer to be eligible for the free gift. You must enter a dollar amount of $0.01 or higher. You cannot enter a negative amount.

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

Group

The group of items that the customer needs to purchase to qualify for the free gift. If you specify a group, only items from this group are counted toward the $ required in order to receive the free gift. If you do not specify a group, all items on the order count toward the $ required.

You use the Work with Promotional Pricing Groups (WPRG) menu option to set up a group of items.

Numeric, 3 positions; optional.

Exp date (Expiration date)

The last date when the system should automatically apply the free gift to orders. If you leave this field blank, the system continues to apply free gifts to qualifying orders.

Numeric, 6 positions (MMDDYY format); optional.

Item

The item to add as a free gift.

Alphanumeric, 12 positions; required.

Clr/Size/Wdth

If the specified item has SKU’s, enter the SKU to add to qualifying orders.

Alphanumeric, three 4-position fields (split SKU) or one 14-position field (full SKU); required if the item has SKUs.

Qty (Quantity)

The number of units of the free gift item to add to the order.

Numeric, 5 positions; required.

Work with Offer Dollar Discounts Screen

Purpose: Use this screen to define standard and associate discounts for an offer.

Negative additional charge or prorate? If the Prorate Dollar Discounts and Coupons (D90) field in the System Control file is set to N, the system adds these discounts to the order as an negative additional charge, or credit. If this system control value is set to Y, the dollar discount is applied on a pro-rata basis to each item on the order and is reflected in the selling price. This discount is calculated after all other discounts have been applied, and it is not related to the system's pricing hierarchy; it applies regardless of any other pricing method used.

Discount sale items? The Exclude Sale Item When Prorating Discounts (I65) system control value controls whether to include sale items in the pro-rata discount calculation. See that system control value for more information.

How to display this screen: On the Work with Offers Screen, enter 12 next to an offer.

OER0400 CHANGE Work with Offer Dollar Discounts 10/15/97 10:44:37

The KL Mail Order Company

Offer Number . : HAG HALLOWEEN SPECIALS

Type options, press Enter.

4=Delete

Merch Standard Associate Add'l

Opt Amount Discount Discount code

75.00 5.00 10.00 DD

150.00 10.00 15.00 DD

250.00 20.00 25.00 DD

F3=Exit F6=Add F12=Cancel

Field

Description

Offer

The unique code and description for the catalog, space, television or web site advertisement from which you accept orders.

Offer: Alphanumeric, 3 positions; display-only.

Description: Alphanumeric, 3 position; display-only.

Merch amount

The merchandise total on the customer's order. When the merchandise total is equal to or greater than the dollar amount entered in this field, the customer is eligible for the standard and/or associate discount defined for this amount.

When evaluating an order to see if it meets the required merchandise total, the system includes sale items (based on the setting of the Sale item flag for the Item Offer or the Sale item flag for the SKU Offer). The system does not include non-discountable items (based on the setting of the Discountable flag for the item).

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

Standard discount

The dollar amount to subtract from the customer's order when the merchandise total on the order is equal to or greater than the dollar amount entered in the Merch amount field.

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

Associate discount

The dollar amount to subtract from an associate customer's order when the merchandise total on the order is equal to or greater than the dollar amount entered in the Merch amount field.

Customers are identified as associates in the Customer record; a Y must appear in the Assoc field in Order Entry for this discount to be applied.

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

Add'l code

A code that represents a type of additional charge on an order. The system uses this code only if the Prorate Dollar Discounts and Coupons (D90) system control value is set to N.

In this case, the additional charge refers to a discount, or negative charge, applied against the order. This code is validated against the Additional Charges Code file; see Customer Service Establishing Additional Charge Codes (WADC). This file contains user-defined values to categorize the different types of charges that may be assessed or the discounts that may be applied against an order, and defines the G/L account numbers where these charges or discounts post.

If the Prorate Dollar Discounts and Coupons (D90) system control value is set to Y, the system does not use the additional charge code; instead, the discount amount is prorated against the order lines, as described in Prorating Logic.

Alphanumeric, 2 positions; required if the Prorate Dollar Discounts and Coupons (D90) system control value is set to N

To add: This screen displays in Add mode. The cursor is at the Merch amount field, so you can begin adding dollar discount information.

Each time you enter a dollar discount, the system arranges the dollar discounts in ascending order from the lowest to highest amounts.

To change: If any dollar discounts have been previously entered in this file, those discounts will display.

To change dollar discount information, press F6 to switch to Change mode.

Place your cursor at the beginning of the field you wish to change. Erase the information and reenter it.

To delete: Press F6 to switch to Change mode and display the discounts for this offer and enter 4 next to a dollar discount to delete it.

Work with Telemarketing Specials Screen

Purpose: Use this screen to define a telemarketing special promotion for the item and offer defined in this file. The Telemarketing Specials Window appears automatically after you enter items in order entry if the Display Telemarketing Window in Order Entry (H02) system control value is selected. Telemarketing promotions are also available through the Display More Options Screen in Order Entry/Maintenance (available by pressing F10) when a customer places an order for this offer.

Items appear on this screen sorted by:

• Item category (blank categories (i.e., not assigned) display first)

• Page number

• Item and SKU

Non-offer-specific telemarketing specials: If the Display Non-Offer-Specific Telemarketing Specials in Order Entry (J31) system control value is set to Y, then the system does not display any telemarketing specials that you set up through this screen in order entry; instead, only specials set up through Working with Order Telemarketing Specials (WOTS) are available. Otherwise, if the system control value is set to N, the specials you set up in this screen are available in order entry if the source code on the order header is associated with this offer; in this situation, any specials set up through Working with Order Telemarketing Specials (WOTS) are not available.

How to display this screen: On the Work with Offers Screen, enter 13 next to an offer.

OER0606 DISPLAY Work with Telemarketing Specials 4/29/98 15:46:38

EZK Mail Order

Offer . : S98 SPRING 1998

Sale

Page# Item CLR SIZE WDTH Price Price M/D% Categ

Message

4 MUG123 4.99 5.99 17 %

A collectible, "diner-style" mug in a variety of retro patterns

3 BE445 2.50 6.99 64 %

Cute dachshund beanbag doll makes a great gift for kids TOYS

3 CRE789 24.95 0 %

This is the artificial life game you have been hearing about TOYS

4 AU453 8.00 10.00 20 %

An Augie Doggie doll, great for kids or collectors TOYS

F3=Exit F8=Add/Change F11=Delete SKUs F12=Cancel

Field

Description

Offer

The unique code and description for the catalog, space, or television advertisement from which you accept orders.

Offer: Alphanumeric, 3 positions; display-only.

Description: Alphanumeric, 3 position; display-only.

Page #

The page number where the item appears. This does not need to be the same page number as specified for the item/offer or SKU/offer.

You cannot set up telemarketing specials for the same item/SKU and offer on different page numbers.

Numeric, 5 positions; required.

Item

The code for the unit of inventory that is available for this telemarketing special promotion.

Alias

Aliases are alternate names for an item that you can use to track how demand varies based on how you display and position items within an offer. If you have the Display Item Alias (D56) field in the System Control file set to Y, and you have defined any aliases for this item in this offer, you can enter the actual item code in this field when creating a telemarketing special, or you can enter the alias code. The Work with Telemarketing Specials screen displays the actual item code.

In order entry, the system searches alphanumerically for an item alias. The telemarketing specials screen displays the first alias it finds for this item/offer.

Alphanumeric, 12 positions; required.

Clr/Size/Wdth (SKU codes)

Codes representing the item's unique characteristics, such as color and size.

Entry of the SKU field(s) is optional. If you enter the base item code only for an item with SKUs, the system creates a separate telemarketing special record for each SKU that is not already set up as a telemarketing special for this offer.

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

Tax incl sale prc (Tax-inclusive sale price)

The sale price to use for the item on orders which are subject to VAT. This field will display only if the Tax Included in Price (E70) field in the System Control file is set to Y. When the telemarketing specials screen displays on an order subject to VAT, the tax-inclusive sale price displays, and the markdown percentage that displays will be based on the difference between the tax-inclusive offer price and the tax-inclusive sale price.

Numeric, 8 positions; optional.

Sale price

The special price that is offered for the telemarketing promotion for this item.

You might set up a telemarketing special without specifying a sale price in order to upsell the item.

The system uses the price override reason code defined in the Telemarketing Special Price Override Reason (F36) system control value when you add the item to the order.

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

Offer price

The regular price of this item (not the tax-inclusive price) as defined for the offer level.

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

M/D % (Markdown percentage)

The difference between the regular price defined at the item/offer level (not the tax-inclusive price) and the regular sale price, expressed as a percentage. The system calculates the percentage as follows:

100 - (Sale price/offer price X 100)

The markdown percentage is rounded up or down to the nearest whole percent.

When the telemarketing specials display in order entry, the markdown percentage will be calculated based on the tax-inclusive price if the order is subject to VAT.

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

Categ (Category)

The category of the item or SKU, such as petite or tall sizes. The items and SKUs sort by item category, with blank item categories appearing first, both on this screen and in order entry.

System Control Value

The Select Telemarketing Specials by Item Category (F35) system control value controls the option of displaying telemarketing specials for a selected category only in order entry. For example, if the customer wears petite sizes, you can display only SKUs flagged as petite by selecting the appropriate item category.

Example:

System Control Value is Set To: Y

Setting Up Telemarketing Specials:

If you enter an item without specifying an item category, any category already assigned to the item or SKU will default. If the item has multiple SKUs with different item category settings (including blank settings), the system defaults the setting for each SKU.

 

Order Entry:

You can select which telemarketing specials to display by item category. You must select an item (or base item, if the item has SKUs) to advance to a screen which displays markdown information, and where you can add the item or SKU to the current order.

Example:

System Control Value is Set To: N or blank

Setting Up Telemarketing Specials:

The item category does not default; however, you can enter an item category for sorting purposes.

Order Entry:

You advance directly to a screen which displays markdown information for each item or SKU, and where you can add the item or SKU to the current order. The items and SKUs sort in order of the item categories you assigned at the Work with Telemarketing Specials screen.

Alphanumeric, 4 positions; optional.

Message

A persuasive or descriptive message to display for the telemarketing special in order entry. This message will display below the item description.

Alphanumeric, 70 positions; optional.

To add: This screen displays in Add mode. The cursor is at the Page # field, so you can begin adding telemarketing special information.

Complete the Page # and Item fields and any optional fields. To automatically enter all SKUs for a SKUed item, enter the base item only.

Once you enter a telemarketing special, the information will display beneath the blank fields, so you can continue to add more telemarketing special information.

To change: If any telemarketing specials have been previously entered in this file, those items display.

To change telemarketing special information, press F8 to switch to Change mode.

Delete Telemarketing Specials Window

To delete all SKUs for an item:

Press F11 to display the Delete Telemarketing Specials pop-up window:

Delete Telemarketing Specials

Offer . . : S98

Item . . . .

*** All Telemarketing Specials ***

*** for item will be deleted! ***

F12=Cancel

Enter the name of the item you wish to delete. The following confirmation prompt displays:

CONFIRM: N (Y/N)

Enter Y in the prompt field. The system deletes the telemarketing specials for each SKU of the selected item.

Work with Linked Offers Screen

Purpose: Use this screen to create, change, or delete one or more sub-offers for an offer.

Sub-offers for an offer allow you to analyze how certain pages in an offer perform from the rest of the offer. For example, you may want to create a sub-offer if the main offer contains insert pages, such as a section of items sold at discounted prices.

Linked Offers in Order Entry

When you add an item to an order, the system determines the price of the item using the following hierarchy:

• use the price for the item in the offer for the order detail line (the main offer).

• if a price has not been defined for the item in the main offer, the system uses the price for the item in the sub-offer associated with the main offer. If more than one active sub-offer is associated with the main offer, the system uses the first sub-offer in sequence number sequence.

• if a price has not been defined for the item in any sub-offers linked to the main offer, the system uses the price from the most current active offer.

How to display this screen: Enter 14 next to an offer at the Work with Offers Screen.

MSR1184 DISPLAY Work with Linked Offers 12/30/99 11:41:58

KAL Co.

Offer Number B01 BO1 OFFER

Linked Sequence

Opt Offer Number Description

Type options, press Enter.

4=Delete

A01 1 OFFER A01 - SPECIAL EDITION

B 2 FALL SPECIALS

F3=Exit F8=Add/Change F12=Cancel

Field

Description

Offer number

The unique code and description for the catalog, space, or television advertisement from which you accept orders.

Offer: Alphanumeric, 3 positions; display-only.

Description: Alphanumeric, 30 position; display-only.

Linked offer

The code for the sub-offer associated with this offer.

Alphanumeric, 3 positions; optional.

Sequence number

The sequence number determines the order in which the system looks at the sub-offers associated with this offer.

Numeric, 3 positions; optional.

Description

The description of the sub-offer associated with this offer.

Alphanumeric, 30 positions; display-only.

To create: Enter a valid offer code in the Linked offer field and a sequence number in the Sequence number field. The system displays the sub-offer you created on the bottom half of the screen.

An error message displays if you enter an offer in the Linked offer field that is not a valid offer:

Offer not found.

An error message displays if you enter a sequence number in the Sequence number field that is already associated with another sub-offer:

Sequence Number Already Exists.

To change: Press F8 to make the Sequence number field enterable. You can only change the sequence number assigned to the sub-offer.

Screen Option

Procedure

Change between add mode and change mode

Press F8. The system toggles between making the Sequence number field enterable and display-only.

Copy Offer Freight Charges Window

Purpose: Use this window to copy the freight dollar chart charges from one offer to another.

How to display this window: Enter 15 next to an offer whose freight charges you want to copy. If the offer you select does not already have freight charges set up, an error message displays. See Work with Dollar Chart by Offer Screen (Freight Charges) for information on how to set up and work with freight charges for an offer.

Copy Offer Freight Charges

Copy freight charges from AAA NEW YEAR SPECIAL

To offer

F3=Exit F12=Exit

Completing this screen: Enter the code representing the offer to which you would like to copy the freight charges. Enter Y at the Confirm prompt (that appears in the lower right of the window).

If the target offer already has freight charges set up, the system displays an error message:

Offer already has freight charges defined.

Update Prices? Window

Purpose: This window opens if you change the start date for an offer at the Change Offer Screen. At this window, you need to indicate whether to change the effective date for any item prices or SKU prices that currently start on the same date as the offer.

Example: Offer 001 includes item AB100 at $10.00. The start date for offer 001 is January 1, and the effective date for item AB100 is also January 1. If you change the start date for offer 001 to January 15, the Update Prices? window prompts you to indicate whether to also automatically change the effective date for items such as AB100 to January 15.

Update Prices?

The start date of the offer has been

changed from 1/06/08 to 3/01/08 .

Do you wish to change any prices from

effective date 1/06/08 to 3/01/08 ?

Option: (Y=Yes, N=No)

Generate Item Out triggers: Y (Y/N)

Field

Description

Option

Indicates whether to change any existing Item Price or SKU Price records to be consistent with the new effective date for the offer. Valid values:

Y = update the start date for existing Item Price or SKU Price records

N = do not update the start date for existing Item Price or SKU Price records

Alphanumeric, 1 position; required.

Generate item out triggers

Indicates whether to create an outbound interface transaction trigger for each item and SKU whose effective date is changed when you complete this window. The system creates a trigger with a file type of SKU, indicating to generate an outbound item XML message for the item. See Generic Item Download API for more information on the outbound XML message. Valid values are:

Y = Create a trigger to create an outbound item XML message (CWItemOut) for each item and SKU whose effective date is changed.

N = Do not create the triggers for the outbound item XML message.

This field defaults to the setting from the last time you used this menu option. If there is no stored setting, the default is Y. See Working with Default Options (WDFT) for information on how the system stores defaults.

Note: This field is displayed only if the Create Generic Item Download Trigger Records (I15) system control value is set to Y.

Alphanumeric, 1 position; required.

MK01_02 CWDirect 18.0.x 2018 OTN