Hi JP, I logged in and saw that you had just posted this. This won't be a really detailed answer but hopefully it will get you pointed in the right direction.

I don't know of a way to filter an export based on component ID, so here is what I would do. First, export your inventory filtered by Item Class so you only get assemblies. Then run a Component Use List report and filter it to Component ID = AAA123. Send that report to Excel. Open the exported CSV file containing your assembly items. Add a column (I would insert it next it Item ID) and use VLOOKUP to check each item ID against the Assembly ID column in the Component Use List that you sent to Excel. Then filter the CSV files to show you all the rows that returned #N/A. Delete those rows and you're left with just the assemblies you want to update. Do a find & replace on your component ID, update the revision number and effective date for each assembly, delete the VLOOKUP column and you should be in business.

Hi JP, I logged in and saw that you had just posted this. This won't be a really detailed answer but hopefully it will get you pointed in the right direction.

I don't know of a way to filter an export based on component ID, so here is what I would do. First, export your inventory filtered by Item Class so you only get assemblies. Then run a Component Use List report and filter it to Component ID = AAA123. Send that report to Excel. Open the exported CSV file containing your assembly items. Add a column (I would insert it next it Item ID) and use VLOOKUP to check each item ID against the Assembly ID column in the Component Use List that you sent to Excel. Then filter the CSV files to show you all the rows that returned #N/A. Delete those rows and you're left with just the assemblies you want to update. Do a find & replace on your component ID, update the revision number and effective date for each assembly, delete the VLOOKUP column and you should be in business.

Thanks Steve!

We had run the Component Use List report, so we knew which assemblies were impacted.  Didn't think of Inventory by Item Class. That's the ticket! (I think).  Thinking we'll make ONE assembly change, verify, then do all 233.

I'll let you know upon our success! 

Why don't you just revise the assembly?  It is a function of Quantum. 

Shirley - 233 of 'em!   One at a time? 

I personally think it would be easier to revise the items.   But that is me.