4 Replies Latest reply on Mar 17, 2009 1:25 PM by 691316

    Matching Items with Suppliers Items

    Dimitris Svourdakos
      Hi all I need to link our Items with suppliers items.
      For Example lets say we have Item1 and we purchase this item from three vendors. Each vendor has his own item code in Example Vendor1Item1 Vendor2Item1, Vendor3Item1.

      I want to use the matching in
      1. Reporting
      2. Entering POs.
      3. Receiving Goods

      Thanks in advance.
        • 1. Re: Matching Items with Suppliers Items
          You need to map the vendor item codes to your standard item codes, or international standard codes.
          • 2. Re: Matching Items with Suppliers Items
            You can do it by using descriptive flexfields to store supplier item, create a mapping table of items in database then use custom.pll to customize for as soon as you create a PO and save it to database the custom.pll code will populate the descriptive flexfield with supplier item. The you can customize the Print Purchase Order report to show the supplier item not your internal item, then you can fax or email it to supplier. Accordingly you can customize receiving screens where a receiving clerk enters supplier item, the form will automatically selects your internal item on a custom field on the form, you can do it by cusom code in custom.pll

            This is general overview, details you can work out on thes guidelines.
            • 3. Re: Matching Items with Suppliers Items
              Dimitris Svourdakos
              So, you are saying that there is no standard way of doing it? I was hoping that APPS had this kind of functionality or at least part of it.
              I know I can do whatever I want with custom code but I need to first explore what can be done with Standard functionality.

              In Receivables for example you can use the Customer Items function to link your items with customer items.
              • 4. Re: Matching Items with Suppliers Items
                You can do this using Approved Supplier List. There's a field for Supplier Item. This is standard functionality

                From purchasing user guide (B28669-01) about ASL:
                "provides storage for general data attributes that are unique to the supplier/item
                "Link the primary supplier item number with your internal item number. This
                designated item will default to Purchase Order and Requisition lines."