Standalone Manufacturer Parts in agile
Is it possible to get the standalone manufacturer parts from Agile which are not linked to any Items?
There is no way to search for mfr parts in which the Where Used is null (you can do that for parts and documents).
The only good way is to execute the following query in the database :
select m.name MANUFACTURER, mp.part_number from manufacturers m, manu_parts mp
where mp.manufacturer = m.id and not exists (select null from manu_by where manu_part = mp.id);
This will list the mfr parts that are not (and never have been) used in any AML for any part.
While it doesn’t work for MPNs that have never been linked to an item, you can use Component Engineer Searches >> Mfr Pts Not Used for a Latest Released Part to see all the MPNs not currently linked to an item.
