Chapter 44: Resequence the SKU Collating Sequence Number (RSCS)

Purpose: Use the Resequence SKU Collating Sequence Number Screen to assign a SKU sort sequence number to each SKU of an item.

In this chapter:

• SKU Sort Sequence Numbers

• Where is the Sort Sequence Number Used?

• How is a Sort Sequence Number Assigned?

• Related System Control Values

• Assigning SKU Sort Sequence Numbers Based on SKU Element

• Resequence SKU Collating Sequence Number Screen

SKU Sort Sequence Numbers

SKU Sort Sequence Numbers are sequence numbers assigned to SKUs to determine the order in which the SKUs sort. You can use the sort sequence to display SKUs in a different order, such as by size, rather than alphanumerically by SKU code.

Example: T-Shirts in sizes extra small, small, medium, large and extra large that are not assigned a SKU sort sequence number sort alphanumerically by SKU code:

• t-shirt LRGE • t-shirt MEDM • t-shirt SMLL • t-shirt XLRG • t-shirt XSML

You can define a SKU sort sequence number for each SKU of the t-shirt so that they sort from smallest to largest size:

• t-shirt XSML (sequence # 1) • t-shirt SMLL (sequence # 2) • t-shirt MEDM (sequence # 3) • t-shirt LRGE (sequence # 4) • t-shirt XLRG (sequence # 5)

Note: If some SKUs of an item are not assigned a sort sequence number, the system sorts those SKUs first alphanumerically by SKU code, and then displays SKUs assigned to a sort sequence alphanumerically by sort sequence. For example, if sizes SMLL, MEDM, and LRGE are assigned a sort sequence number, but sizes XSML and XLRG are not assigned a sort sequence number, the system displays sizes XLRG and XSML first: XLRG, XSML, SMLL, MEDM, LRG.

Where is the Sort Sequence Number Used?

The sequence number is used to sort items:

• on physical inventory reports

• on the Print Inventory Status and Projection Reports (ISRP)

• when scanning for a SKU during purchase order entry and maintenance

• when scanning for a SKU during order entry and maintenance

How is a Sort Sequence Number Assigned?

You can assign a SKU sort sequence number to each SKU of an item in the following ways.

• Enter a SKU sort sequence number in the Sort sequence number field on the Create SKU 1 of 2 (With Overrides) Screen or the Change SKU Screen.

• Select an item that contains SKUs at the Resequence SKU Collating Sequence Number Screen and press Enter to have the system automatically assign a sort sequence number to each SKU, based on the SKU collating sequence number defined for each SKU element. See Assigning SKU Sort Sequence Numbers Based on SKU Element.

• Enter a SKU sort sequence number in the Sort sequence number field on the Work with SKU Generator Screen in Using the SKU Generator (ESKG).

• Enter Y in the Auto Assign Sort Sequence Number During SKU Generation (F24) system control value to have the system automatically assign a SKU sort sequence number to each SKU in the SKU Generator (fast path = ESKG).

Related System Control Values

System Control Value	Description
Auto Assign Sort Sequence Number During SKU Generation (F24)	Defines whether the system automatically assigns a SKU sort sequence number to each SKU created in the SKU Generator.
Require Sort Sequence Number in the SKU File (F23)	Defines whether the Sort sequence number field on the Create SKU and Change SKU screens in Work with Item/SKUs is a required field.

Assigning SKU Sort Sequence Numbers Based on SKU Element

The system uses the sort collating sequence number defined in Working with SKU Elements (WSK1, WSK2, WSK3) to determine the SKU sort sequence number to assign to each SKU. The system assigns a sort sequence number to each SKU in increments of 10.

Example:

For example, you are generating SKUs for a skirt in colors black and navy, styles petite and regular and sizes small and medium. In Work with SKU Elements, the sort sequence numbers are defined as follows: SKU Element 1 black: sort sequence number is blank navy: sort sequence number is blank SKU Element 2 petite: sort sequence number is 1 regular: sort sequence number is 12 SKU Element 3 small: sort sequence number is 2 medium: sort sequence number is 5

To assign the sort sequence number, the system first retrieves the sort sequence number defined in Work with SKU Element 1. In this example, the colors black and navy are not assigned a sort sequence number. Since they are not assigned a sort number, the system sorts the elements defined in SKU Element 1 alphanumerically.

The system then retrieves the sort sequence number defined in Work with SKU Element 2. In the example, petite is assigned a sort sequence number of 1 and regular is assigned a sort sequence number of 12. The system sorts petite styles before regular styles.

The system then retrieves the sort sequence number defined in Work with SKU Element 3. In the example, small is assigned a sort sequence number of 2 and medium is assigned a sort sequence number of 5. The system sorts small sizes before medium sizes.

The system assigns SKU sort sequence numbers to each SKU based on the sort collating sequence numbers defined for each SKU element:

Item/SKU	Element 1/ Sequence #	Element 2/ Sequence #	Element 3/ Sequence #	SKU Sort Sequence Number
skirt	black (blank)	petite (1)	small (2)	10
skirt	black (blank)	petite (1)	medium (5)	20
skirt	black (blank)	regular (12)	small (2)	30
skirt	black (blank)	regular (12)	medium (5)	40
skirt	navy (blank)	petite (1)	small (2)	50
skirt	navy (blank)	petite (1)	medium (5)	60
skirt	navy (blank)	regular (12)	small (2)	70
skirt	navy (blank)	regular (12)	medium (5)	80

Resequence SKU Collating Sequence Number Screen

Use this screen to select an item you wish to assign SKU sort sequence numbers to for each of the item's SKUs.

The following error message displays if the Auto Assign Sort Sequence Number During SKU Generation (F24) system control value is set to N: Auto Assign Sort Seq# is not set to 'Y'.

How to display this screen: Enter RSCS in the Fast path field at the top of any menu or select Resequence SKU Collating Sequence Number from a menu.

INR1147 ENTER Resequence SKU Collating Sequence Nbr 3/20/98 12:25:22 The KL Mail Order Company Item Number: F3=Exit F12=Cancel

Field	Description
Item number	The item you wish to assign SKU sort sequence numbers to for each of the item's SKUs. The following error message displays if you enter an item that does not contain SKUs: Item entered is a Non-SKU’ed Item. Alphanumeric, 12 positions; required.