Working with Price Tickets (WPTW)
Price tickets are labels you attach to items that you wish to transfer to a retail store. The ticket contains information such as the item number and SKU, retail price and outlet price. A barcode is defined on each label so you can scan the label information automatically into your system.
There are two types of price tickets you can use:
• A Hanging price ticket is used for items that are stored in a hanging location, such as a suit.
• A Label price ticket is used for items that are stored on a flat surface, such as shoes.
Retail Point of Sale interface: The Retail Point of Sale interface allows you to transfer inventory information from CWDirect to Cam Data's retail point of sale system. The system generates a price ticket for each order representing a retail store restock; see Working with the Retail Point of Sale Interface.
In this topic:
• When is a Price Ticket Generated?
• Determining the Retail and Outlet Prices
• Work with Price Tickets Screen
When is a Price Ticket Generated?
The system automatically generates price tickets for items on a retail store order.
Identifying retail store orders: The system considers an order a retail store order if:
• The Mailorder/retail field for the order type on the order is set to R (retail), and
• The sold to customer on the order represents a retail store (the Warehouse field for the customer contains a warehouse code whose Retail outlet field is set to Y).
However, you can manually create a price ticket for any item at the Create Price Ticket Screen or Create Price Tickets for Order Screen.
When is the price ticket generated? The Generate Price Tickets During Pick Slip Generation (I77) system control value controls when price tickets are generated.
• H = The system generates price tickets in hanging format during pick slip generation for retail store orders.
• L = The system generates price tickets in label format during pick slip generation for retail store orders.
• N or blank = The system does not generate price tickets during pick slip generation for retail store orders; instead, the system creates a record in the Price Ticket Work file for each price ticket. You must use the Work with Price Tickets Screen to print the price tickets. At this time, you can select which price ticket format (hanging or label) to print.
The system uses the print program defined in the Price Ticket Print Program (F46) system control value to print the price tickets. The base print program, FLR0715, prints price tickets in a format suitable for a Monarch printer. Print program FLR1128 prints price tickets in a format suitable for a Zebra printer.
If you wish to print price tickets on a different printer, you need to verify that the printer will print the correct number of labels. See Hanging Price Ticket and Label Price Ticket for sample price tickets in hanging format and label format.
Note: If the Generate Price Tickets During Pick Slip Generation (I77) system control value is set to H or L, the system automatically prints the price tickets during pick slip generation and clears the Price Ticket Work file of any other price ticket records; price tickets printed during pick slip generation will not display on the Work with Price Tickets Screen and any other price tickets that existed in the work file no longer display.
Determining the Retail and Outlet Prices
The price that defaults to the Retail price field and Outlet price field varies, depending on where you generate the price ticket.
Retail price:
• If generating the price ticket from the Create Price Ticket Screen: The Retail price for the item/SKU on the price ticket is from the Original retail dollars field in the SKU file. If the Original retail dollars field is blank, the system requires you to enter a retail price.
• If generating the price ticket from the Create Price Tickets for Order Screen: The Retail price for the item/SKU on the price ticket is from the List price field in the SKU file. If the List price field is blank, the system defaults the Original retail dollars field from the SKU file. If both the List price field and Original retail dollars field are blank, the Retail price remains blank.
• If generating the price ticket during pick slip generation: The Retail price for the item/SKU on the price ticket is from the Original retail dollars field in the SKU file. If the Original retail dollars field is blank, the retail price is 0.00.
Outlet price:
• If generating the price ticket from the Create Price Ticket Screen: The Outlet price for the item/SKU on the price ticket is from the SKU Offer price for the offer you enter in the Offer field. This is the Price field in the SKU Price file for a quantity of 1 with the most recent effective date. If a SKU Price is not defined, the system uses the Price field from the Item Price file for a quantity of 1 with the most recent effective date. If a price is not defined for a quantity of 1, the system requires you to enter an outlet price.
• If generating the price ticket from the Create Price Tickets for Order Screen: The Outlet price for the item/SKU on the price ticket is from the List price field in the SKU file. If the List price field is blank, the Outlet price remains blank.
• If the price ticket is printed during pick slip generation: The Outlet price for the item/SKU on the price ticket is from the SKU Offer price for the offer associated with the source code on the order header. This is the Price field in the SKU Price file for the order quantity with the most recent effective date. If a SKU Price is not defined, the system uses the Price from the Item Price file for the order quantity with the most recent effective date. If a price is not defined for the order quantity, the system uses the price for a quantity of 1 with the most recent effective date. If a price is not defined for a quantity of 1, the outlet price is 0.00.
Example:
Item |
Original retail $ |
List price |
Item Offer Price |
SKU Offer Price |
Qty |
Generate from: |
A23 GRN |
5.00 |
4.50 |
1 = 1.11 2 = 2.22 |
1 = 1.50 2 = 2.50 |
1 |
Retail price = 5.00 Outlet price = 1.50 Create Price Tickets for Order Screen: Retail price = 4.50 Outlet price = 4.50 Pick gen: Retail price = 5.00 Outlet price = 1.50 |
A12 RED |
5.00 |
4.50 |
1 = 1.11 2 = 2.22 |
2 = 2.50 |
2 |
Retail price = 5.00 Outlet price = 1.11 Create Price Tickets for Order Screen: Retail price = 4.50 Outlet price = 4.50 Pick gen: Retail price = 5.00 Outlet price = 2.50 |
A34 BLU |
|
|
1 = 1.11 2 = 2.22 |
1 = 1.50 |
2 |
Retail price = blank; system requires a value Outlet price = 1.50 Create Price Tickets for Order Screen: Retail price = blank Outlet price = blank Pick gen: Retail price = 0.00 Outlet price = 2.22 |
A45 YEL |
5.00 |
4.50 |
1 = 1.11 2 = 2.22 4 = 4.44 |
1 = 1.50 2 = 2.50 4 = 4.50 |
3 |
Retail price = 5.00 Outlet price = 1.50 Create Price Tickets for Order Screen: Retail price = 4.50 Outlet price = 4.50 Pick gen: Retail price = 5.00 Outlet price = 1.50 |
A56 PNK |
|
|
2 = 2.22 |
2 = 2.50 |
1 |
Retail price = blank; system requires a value Outlet price = blank; system requires a value Create Price Tickets for Order Screen: Retail price = blank Outlet price = blank Pick gen: Retail price = 0.00 Outlet price = 0.00 |
Work with Price Tickets Screen
Use this screen to work with existing price tickets, create a price ticket, and print price tickets in hanging and label format.
How to display this screen: Enter WPTW in the Fast path field at the top of any menu or select Work with Price Ticket from a menu.
FLR0690 DISPLAY Work with Price Tickets 8/26/04 14:04:05 KAB Co.
Opt Item SKU Description Source
Type options, press Enter. 2=Change 4=Delete 5=Display
JPY1 ASIAN 16PC DINNERWARE: BLUE WA JPY2002 JPY2 ASIAN TEA SET: BLUE WAVE PATTE JPY2002 JPY3 ASIAN CRYSTAL GLASSES: BLUE RI JPY2002 JPY4 ASIAN DINNERWARE JPY2002 JPY5 ASIAN DINNERWARE: 5PC SET JPY2002 2004IT6M1 SUMMER FIESTA DINNERWARE 2004IT4M2 HOLIDAY FIESTA DINNERWARE
F3=Exit F6=Create F7=Purge F8=Create from Order F12=Cancel F21=Print Price Tickets F24=Select Company |
Field |
Description |
Item |
The item associated with the price ticket. Alphanumeric, 12 positions; optional. |
SKU |
The SKU of the item associated with the price ticket. Alphanumeric, one 14 position field (Full SKU) or three 4 position fields (Split SKU); optional. |
Description (Item description) |
The description of the item. Alphanumeric, 30 positions; display-only. |
Source (Source code) |
The source code associated with the price ticket. Source codes are assigned to a group of customers to whom you are mailing an offer (catalog). The source code controls how items are priced and shipping charges are calculated. Alphanumeric, 7 positions; display-only. |
Screen Option |
Procedure |
Create a price ticket |
Press F6 to advance to the Create Price Ticket Screen. |
Change a price ticket |
Enter 2 next to a price ticket to advance to the Change Price Ticket Screen. |
Delete a price ticket |
Enter 4 next to a price ticket to delete it. |
Display a price ticket |
Enter 5 next to a price ticket to advance to the Display Price Ticket Screen. |
Purge existing price tickets |
Press F7 to advance to the Confirm Purge pop-up window. Press Enter to purge all existing price tickets or press F12 to cancel. A message displays informing you the purge process has been submitted: Job PURGE_PRTK submitted. Once the purge process completes, the system clears all price tickets displayed on the screen. |
Create a price ticket for each open order line on a selected order |
Press F8 to advance to the Create Price Tickets for Order Screen. |
Print price tickets |
Press F21. See Printing Price Tickets. |
Purpose: Use this screen to create a price ticket in hanging or label format.
See When is a Price Ticket Generated? for more information on when the system automatically generates a price ticket for the items on an order.
How to display this screen: Press F6 on the Work with Price Tickets Screen.
FLR0688 ENTER Create Price Ticket 5/18/98 17:25:01 The KL Mail Order Company
Item . . . .
SKU . . . .
Source . . .
Tag Type (H/L) . . . . .
# of Price Tickets . .
Offer . . . . . . . .
Retail Price . .
Outlet Price . .
F3=Exit F9=Accept F12=Cancel |
Field |
Description |
Item |
The item associated with the price ticket. Item codes are defined in and validated against the Item file. Alphanumeric, 12 positions. Create screen: required. Change screen: display-only. |
SKU |
The SKU of the item associated with the price ticket. SKU codes are defined in and validated against the SKU file. Alphanumeric, one 14 position field (Full SKU) or three 4 position fields (Split SKU). Create screen: required if item contains SKUs. Change screen: display-only. |
Source (Source code) |
The source code associated with this price ticket. Source codes are assigned to a group of customers to whom you are mailing an offer (catalog). The source code controls how items are priced and shipping charges are calculated. See Marketing Working with Source Codes (WSRC). The system defaults the offer associated with the source code to the Offer field. Alphanumeric, 7 positions; optional. |
Tag type (H/L) |
A code that identifies whether this price ticket prints in hanging or label format. Valid values are: H = Print this price ticket in hanging format. A hanging price ticket is used for items that are stored in a hanging location, such as a suit. L = Print this price ticket in label format. A label price ticket is used for items that are stored on a flat surface, such as shoes. Alphanumeric, 1 position; required. |
# of price tickets (Number of price tickets) |
The number of price tickets you wish to print for this item. This is useful if the item is contained in more than one package. You can print up to 999 labels for an item. Note: The base print program, FLR0715, prints price tickets in a format suitable for a Monarch printer. Print program FLR1128 prints price tickets in a format suitable for a Zebra printer. If you wish to print price tickets on a different printer, you need to verify that the printer will print the correct number of labels. Numeric, 3 positions; required. |
Offer |
The offer associated with the price ticket. An offer is a code for a catalog or advertisement used to present merchandise to your customers. See Marketing Working with Offers (WOFR). If you define an offer, the system defaults a retail price and outlet price to the price ticket. Alphanumeric, 3 positions; optional. |
The selling price of a single unit of this item for sale in the catalog. The system defaults the Original retail dollars from the SKU file to this field, but you can override it. If the Original retail dollars field is blank, the system requires you to enter a retail price. See Determining the Retail and Outlet Prices for more information and examples. Numeric, 8 positions with a 2-place decimal; required. |
|
The discounted price of this item. This is the price of a single unit of this item for sale in the retail store. The system defaults the SKU Offer price to this field, but you can override it. The SKU Offer price is from the offer defined in the Offer field. This is the Price field in the SKU Price file for a quantity of 1 with the most recent effective date. If a SKU Price is not defined for a quantity of 1, the system uses the Price from the Item Price file for a quantity of 1 with the most recent effective date. If a price is not defined for a quantity of 1, the system requires you to enter an outlet price. See Determining the Retail and Outlet Prices for more information and examples. Numeric, 8 positions with a 2-place decimal; required. |
Completing this screen: Press F9. A message displays informing you the price ticket has been created: Price Ticket (AP57Y) created.
To change: Enter 2 next to a price ticket at the Work with Price Tickets Screen to advance to the Change Price Ticket screen. You can change any information on this screen except the item and SKU. See the Create Price Ticket Screen for a description of the fields on this screen.
To display: Enter 5 next to a price ticket at the Work with Price Tickets Screen to advance to the Display Price Ticket screen. You cannot change any information on this screen. See the Create Price Ticket Screen for a description of the fields on this screen.
Create Price Tickets for Order Screen
Purpose: Use this screen to create a price ticket for each open or held order line on a selected order.
Note: You can create price tickets for any order that contains open or held order lines; the order does not have to be a retail store order.
The system creates a price ticket for each open or held order line, using the following values:
• Item: The item number on the order line.
• SKU: The SKU code on the order line.
• Source: The source code from the order header.
• Tag type: The value you defined in the Tag type (H/L) field.
• # of price tickets: The order quantity on the order line.
• Offer: The offer associated with the source code from the order header.
• Retail price: The List price field in the SKU file. If the List price field is blank, the system defaults the Original retail dollars field in the SKU file. If the Original retail dollars field is blank, the retail price is 0.00.
• Outlet price: The List price field in the SKU file. If the List price field is blank, the outlet price is 0.00.
How to display this screen: Press F8 at the Work with Price Tickets Screen.
FLR1126 ENTER Create Price Tickets for Order 8/26/04 14:23:15 KAB Co.
Order Number . . . . . . -
Tag Type (H/L) . . . . .
F3=Exit F9=Accept F12=Cancel |
Field |
Description |
Order number |
The order number and ship to number for which you wish to print price tickets. If the order contains only 1 ship to, 1 defaults; otherwise, you will need to select a ship to number. The system prints a price ticket for each order line that is in an open or held status. An error message displays if the order ship to is in a suspended status: Order is Suspended. Cannot print Price Tickets. Order number: Numeric, 8 positions; required. Ship to number: Numeric, 3 positions; required. |
Tag type (H/L) |
A code that identifies whether the price ticket prints in hanging or label format. Valid values are: H = Print this price ticket in hanging format. A hanging price ticket is used for items that are stored in a hanging location, such as a suit. L = Print this price ticket in label format. A label price ticket is used for items that are stored on a flat surface, such as shoes. Alphanumeric, 1 position; required. |
Screen Option |
Procedure |
Create a price ticket for each open or held order line on the selected order |
Press F9. The system returns you to the Work with Price Tickets Screen and displays the message: Price Ticket created. A separate price ticket for each open or held order line on the selected order displays on this screen. |
To print: Press F21 on the Work with Price Tickets Screen to print all existing price tickets.
The system uses the program defined in the Price Ticket Print Program (F46) system control value to print price tickets. An error message displays when you press F21 to print price tickets and a print program name has not been defined in the Price Ticket Print Program (F46) system control value: Price Ticket Print Program SCV (F46) is blank.
The base print program, FLR0715, prints price tickets in a format suitable for a Monarch printer. Print program FLR1128 prints price tickets in a format suitable for a Zebra printer. If you wish to print price tickets on a different printer, you need to verify that the printer will print the correct number of labels.
A message displays informing you the print process has been submitted: Job 725723/KLETENDRE/PRICE_TICK submitted to job queue QBATCH in library QGP.
The system creates a separate spool file for price tickets in hanging format (H defined in the Tag type field) and a separate spool file for price tickets in label format (L defined in the Tag type field).
Automatically printing price tickets: If the Generate Price Tickets During Pick Slip Generation (I77) system control value is set to H (hanging price ticket) or L (label price ticket), the system automatically prints price tickets during pick slip generation. See When is a Price Ticket Generated?.
Price ticket sort: Price tickets sort in the following order:
• company
• tag type
• warehouse
• special handling
• bill batch #
• cart batch #
• zone
• picking sequence
• item
• SKU
A sample of a price ticket in hanging format is presented below. Your price ticket may vary, depending on the print program defined in the Price Ticket Print Program (F46) system control value.
Contents:
• Company description
• Retail UPC barcode
• Item number and SKU element 1
• SKU element 2
• Outlet price (price defined in the Outlet price field)
• Retail price (price defined in the Retail price field)
A sample of a price ticket in label format is presented below. Your price ticket may vary, depending on the print program defined in the Price Ticket Print Program (F46) system control value.
Contents:
• Company description
• Retail UPC barcode
• Item number and SKU element 1
• SKU element 2
• Outlet price (price defined in the Outlet price field)
• Retail price (price defined in the Retail price field)
| Working with the Retail Point of Sale Interface | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Working with Automated Inventory Transactions (WAIT) |
WH02_06 CWDirect 18.0.x 2018 OTN