Hi Craig,

There is no 'Alternative Item part number' field stored in the Inventory Control data set; neither Quik Reports DOS nor Crystal Reports have such a field in their tables for IC 65A.

What Inventory Control does is assign items to an Alternate Item set; the field you specified. When you select an Alternate Item number within Add/Modify/Delete Items, what is actually happening is that you are assigning the same Alternate Item set of the Alternate Item number to the item you are editing. You are not assigning that specific item number as an alternate.

You are limited to how you can use this field for reporting, based on the data structure. About the closest you can get is to insert the Alternate Item Set field into you report and create a group on that field. This will group each item with the associated alternate items.