Related Items

We can define relationships between items. This allows us to search for items through these relationships. Here we’ll define two types of items

1.)   Up-Sell: This relationship indicates that a newer version of the item exists, and can be sold in place of the older item but the price will be that of new item

2.)   Cross-Sell: This relationship indicates that one item may be sold in lieu of another item.

In order to define an item relationship, define items in item master as shown below

Up-Sell Item: The main difference between Up-Sell & Upgraded Items is that in Up-Sell price will be that of the new item whereas in Upgraded Item, new item will be sold at the price of old item only.

Navigate to Order Management Responsibility > Inventory > Items > Item Relationships à Click on New & give details as shown below

Reciprocal means that even ‘VS Standard Item’ can be used as an Up-Sell for ‘VS Up Sell Item’

Create a Sales Order & give line details as shown below

Click on Related Items Tab & select the Up-Sell Item

We can see now that the new item has been updated.

Cross-Sell Item: Navigate to  Inventory > Items > Item Relationships à Click on New & give details as shown below

Now create a Sales Order & give details as shown below

Click on Related Items Tab & select Cross-Sale Item

We can see that a new line has been added & customers will now have a choice of select any one or both of the items

The base table updated is ‘MTL_RELATED_ITEMS’

select  MTL1.SEGMENT1 "Main Item",

          MTL2.SEGMENT1 "Related Item"

 from  MTL_RELATED_ITEMS  MR,

          MTL_SYSTEM_ITEMS_B MTL1,

          MTL_SYSTEM_ITEMS_B MTL2

where MTL1.INVENTORY_ITEM_ID = MR.INVENTORY_ITEM_ID

    and MTL2.INVENTORY_ITEM_ID = MR.RELATED_ITEM_ID

    and MTL1.SEGMENT1 = 'VS Standard Item'