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'
