Supplier wise Item Mapping

Hi, I am looking for feature where I can map Item Supplier wise.

  1. I have 3items in system.
  2. Supplier A provide all three items (Item01, Item02 and Item03)
  3. Supplier B Provide only (Item 02)
  4. Supplier C provide 2Items (Item02 and Item03)
  5. Supplier D provide 2Items (Item01 and Item03)

Now I want to see which are the supplier for Item- Item02. I already have think about Default Supplier (Item Master) but it only let map only one supplier per item.

Purpose: Just for Purchase department information.

You can use Supplier details table in the item master to track this information. Also, you will be able to generate a report based on Item master and get list of suppliers for an item.