Many of our inventory items seem to have been have been populated with multiple alternate items. The alternate items number in the hundreds and are consistent from item to item.
Strangely the alternate items only show when doing an item inquiry, They do not show when accessing from item maintenance.
IC Version 9.2A (150515).
DIC is good - have no idea how or why this has happened.

Hi Bill,

The data structure for Alternate Item Numbers in Adagio Inventory is from a legacy layout, where rather than assigning a specific alternate item number, items are assigned to a 'Alternate item Set code'. This allows defining any number of alternate items that can be selected, rather than just one. Perhaps there is a pool of 5 different items that are all alternate to each other. To see this, you can include the 'Set # Key' field as a column to your Edit Items or Item Inquiry grid. All items with the same value belong to the same 'Alternate Item Group'.

When editing an item that has a blank value for the Alternate Item Number, you can only select a single item for the field result, rather than a 'group code'. Doing so adds the edited item to the pool along with all other items having the same Set # Key. It is not an error that 3 or more items are alternate to each other, and this can only be fully displayed in Inquiry, not Edit Items.

You first need to determine if this is in fact an error, or a desire to group more than 2 items together as alternates with each other. Perhaps items were imported with the same Set # Key, or edited in such a way that they were getting grouped together. It would be difficult to guess at the precise reason for what happened.

Once you determine whether they layout is correct (and unexpected large) or in fact in error, then a course of action is possible depending on how different the results are. If there are only a few items that shouldn't have an alternate item, or a different grouping, then you can edit/remove the alternate item number from the field. If there is a large volume of changes required, you'd want to use Export/Import items to refresh the Set # Key value so that the correct items are grouped together as alternates.