1 Reply Latest reply on Nov 26, 2009 6:50 AM by S.PDASH

    manfacturer part  numbers

    Kashif Manzoor
      During item creation in R-12 through interface tables we want to insert/update Manfacturere Part numbers details but we are not able to find any interface for uploading manfacturere part numbers details.

      Any body advise for any interface or APIs to upload manfacturere part numbers.


      regards/
        • 1. Re: manfacturer part  numbers
          S.PDASH
          Hi,
          you can only insert Manfacturere Part numbers after you define Items in your system.. and it is going to be a separate conversion altogether.. Correct me if I am wrong here..

          Basically you need to populate MTL_MFG_PART_NUMBERS table of Inventory to relate an Item with Manfacturere Part numbers ..

          You can relate MTL_MANUFACTURERS , MTL_SYSTEM_ITEMS_TL, & MTL_MFG_PART_NUMBERS tables through MANUFACTURER_ID, INVENTORY_ITEM_ID & ORGANIZATION_ID...

          Regards,
          S.P DASH