Alternate parts on BOMs

I think Capture CIS by itself is not designed to support "equivalents" as individual records as we call them.  

If you use EMA's Component Information Portal, alternate equivalents are added by importing the CIS BOM into the CIP web interface.

A second option is to configure multiple manufacturers/MPN properties in the database and CIS.

Distributor part numbers?   I don't believe Operations ever used those.  They were thrilled when I include OctoPart URLs with each MPN.

First question they have is if stock is at a distributor or do we have to use a broker in China.  O_o

The big need came with all the part shortages in the last few years. We didn't pay enough attention to the database. Now it is catch up time.

For the same CIS Part Number:

I can add alternate distributors for the same part (E.g., Digikey and Mouser) and addition distributor part number for the same part.

I can also add additional parts for the same CIS Part Number (E.g., Panasonic and Vishay).

Now this is the odd part.

I went through for one of our small count PCBs; 54 parts with many multiples of the same part.

In CIS, I replaced obsolete parts with active parts. These updated parts have no distributor name or part number on the BOM even though they are in CIS.

The still active parts that I did not need to update, are in the the BOM. If there are two distributors, that data is there too.

A quick test of 1 part with alternates has no distributor data either.

I am baffled!

Best regards,

Fred

Are you using Component Information Portal to manage your parts database?

If you are missing part data, are you able to Update Part Status All in CIS Part Manager without any issues?

CIS supports CIS PNs linked to a number of equivalent MPNs.   But, CIS will only export the first SQL record it finds. 

EMA-EDA/CIP had to implement importing a list of CIS PNs/REFDES instances to re-create a new BOM spreadsheet with all equivalents.

I don't believe we can get that from CIS directly.

Some things can be made through Relational view.

I don't know how this is done exactly, but i've seen it working (under Allegro and seems to be available in OrCAD as well). If setup correctly, everytime you select a master record in CIS, it will show the alternate part list in a separate section of the CIS window.

At DB level, you basically have a main component, set as default, but you also have a series of alternates connected to this master record. You will not be able to select from the alternates when placing a component on schematic, but you can see the full list of equivalents behind it, along with properties like price and availability for example. This means that the trick lies in the way you setup the database and connect your PLM to the CIS database so that at BOM time, manufacturer know they can populate any of the alternates.

I have 16.6, 22.1 and 24.1 Allegro Designer.   Don't know if Orcad X is different as I don't have an Orcad license.

I'm not able to get the equivalent parts to be visible.  The View menu you're showing only shows up when I'm linking a part.

I believe the goal is to have all equivalent parts listed in the BOM export so Operations can find stock and finish the build kit.

I don't think the BOM import function in CIP would exist if I could get this directly from CIS.