Item/SKU to be canceled

Enter the item and SKU that should be canceled by the batch job. Only open or held, unreserved order lines are eligible for cancellation; if the line is partially reserved and partially backordered, or if it is sold out, the batch job will not cancel it.

If the item you select for cancellation has a ship via override, the system will not add the substitute item with the same ship via override, unless the override ship via is specified in the Item file.

If you do not enter a valid item code and SKU (if the item has SKUs), an error message displays. See Merchandising Performing Initial Item Entry (MITM) for more information on creating and working with items.

Note: Substituting a set item will not cancel its component items.

Item: 12 positions, alphanumeric; required.

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

Cancel reason code

Enter the cancel reason code to use when canceling the item. Cancel reason codes control whether you update demand for cancellations. If the cancel reason code reduces demand, the canceled order line will have a status of X (closed); otherwise, the line will have a status of C (canceled).

Cancel reason codes are defined in and validated against the Cancel Reason Code file. See Establishing Cancel Reason Codes (WCNR).

Numeric, 2 positions; required.

Ship via

Enter the ship via code that must be specified on the order in order to include the order in the item substitution process.

The system first looks at the shipper defined for the order line. If a shipper is not defined for the order line, the system looks at the shipper defined on the order header.

You can enter up to 5 ship via codes.

Ship via codes are defined in and validated against the Ship Via file.

Note: This field is currently not implemented.

Numeric, 2 positions; optional.

Substitute item/SKU

Enter the item and SKU that should be added to the order as a substitute for the canceled item.

The system does not validate that the substitute item you enter is available in sufficient quantity to fulfill the orders updated by the batch job.

You can substitute a non-SKU’ed item with a SKU’ed item, or a SKU’ed item with a non-SKU’ed item, if necessary.

If you do not enter a valid item code and SKU (if the item has SKUs), an error message displays. See Merchandising Performing Initial Item Entry (MITM) for more information on creating and working with items.

If the substitute item is restricted from shipment to a country or state, the substitution will not be performed on orders with ship to addresses in the restricted area(s). See Merchandising Entering Additional Item Information for more information on item country/state restrictions.

Note: If you enter a substitute item that has restricted SKUs (the Restrict field at the Create SKU 1 of 2 (With Overrides) Screen is set to Y), the system displays the following error message:

Cannot take orders for this item/SKU (xxxxxx xxxx).

Item: 12 positions, alphanumeric; required.

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

Use canceled item's price

This field indicates whether to apply the unit price of the canceled item to the substitute item. Valid values are:

Y (default) = Use the canceled item's price for the substitute item. (Note: If the canceled item's price was zero, the substitute item will be added at no charge also.)

N = Use a different price. If you enter N in this field, you will need to enter Y in the Add item at no charge field or enter a price in the Substitute item price field.

Alphanumeric, 1 position; required.

Add item at no charge

This field indicates whether to add the substitute item to the order at no charge. Valid values are:

Y = Add the substitute item to the order at no charge. The Use canceled item's price field cannot be set to Y if this field is also set to Y.

N (default) = Do not add the substitute item at no charge. You must either set the Use canceled item's price field to Y, or complete the Substitute item price field.

Alphanumeric, 1 position; required.

Substitute item price

The unit price to use for the substitute item, if you are not simply using the canceled item's price or offering the substitute item at no charge. You cannot enter a substitute item price unless both the Use canceled item's price field and the Add item at no charge field are set to N; in this situation, the substitute item price is required.

If the order total changes, the order will be subject to a credit check and may go on hold if, for instance, the customer paid by check and there is now a balance due for the new total.

Numeric, 7 positions with a 2-place decimal; required if not using the canceled item price or no charge.

Price override reason code

Enter the price override reason code to use when adding the substitute item to the order. Price override reason codes are defined in and validated against the Price Override Reason file; see Establishing Price Override Reason Codes (WPOR).

Alphanumeric, 1 position; required.

Recalculate freight

This field indicates whether to recalculate freight on the order based on the item substitution. Valid values are:

Y = Recalculate freight based on the new merchandise total after making the item substitution.

N (default) = Do not recalculate freight.

The Recalculate Freight Default (F62) system control value controls the default setting of this field, but you can override this default.

Alphanumeric, 1 position; required.

Maximum number of substitute items to process

Enter the total number of units of the original item to cancel and replace with the substitute item. The system will cancel each complete order line for the item in chronological order by order date until it reaches this maximum.

If the system cannot cancel a complete order line quantity on an order without exceeding the maximum you enter here, it skips that order line and selects the next available order line that will not exceed the maximum. For example, if there are two units remaining to cancel before exceeding the maximum, and the next order line is for five units, the system skips this order line and cancels the next order line for the item for a quantity of two or fewer.

If each open order line for the original item exceeds the maximum number you specify here, the system does not cancel any of the order lines.

Numeric, 5 positions; optional.

Arrival date

Allows you to select items for substitution based on the item’s arrival date.

The system only includes items whose arrival date is equal to or earlier than the arrival date you specify.

Example: If you enter 2/25 in the Arrival date field, the system includes order lines whose arrival date is 2/25 or earlier.

Numeric, 6 positions (MMDDYY format); optional.

All coordinate grouped items

Allows you to select items for substitution only if a coordinate group number is defined for the item.

Valid values:

Y = The Substitute Items process only includes items with a coordinate group number defined.

N = The Substitute Items process includes items, regardless if a coordinate group number is defined.

An error message displays if you enter Y in the All coordinate grouped items field and a coordinate group number is specified in one or more of the Coordinate groups fields: All Coordinate Grouped Items must be N when a C/G field is entered.

Note: The system does not add the coordinate group number to the new order line created for the substitute item.

Alphanumeric, 1 position; optional.

Coordinate groups

Allows you to select items for substitution based on the coordinate group number defined for the item.

You can enter up to 5 coordinate group numbers.

Example: If you enter Coordinate group 20, the system only selects items for substitution whose coordinate group number is 20.

An error message displays if you enter a coordinate group number and the All coordinate grouped items field is set to Y: All Coordinate Grouped Items must be N when a C/G field is entered.

Note: The system does not add the coordinate group number to the new order line created for the substitute item.

Numeric, 3 positions; optional.

Pick message line 1 and 2

Up to two lines of messages to appear on pick slips for shipment of the substitute item. These are added to the order line messages for each updated order. You can review order line messages by entering 23 next to an item in order inquiry; see Reviewing Order Details.

Alphanumeric, 40 positions each; optional.