Can you do a Where Used search on multiple part numbers?
I have a list of part numbers (5880 to be exact) of which I need to do a Where Used search on all of them.
Is there a way to perform this search in one hit rather than doing individual Where Used searches for each part number?
Any help would be much appreciated! Many thanks in advance.
Yes and no… There are a couple of ways in the web client, but neither are all that much better than doing them individually, and the output format is pretty useless. The best way would be to query the database directly. If you have access to do that let me know and I’ll see if I can provide a query for you.
I have used Agile reports, like the Where Used Report. You can search for parts that have something in common. We have a Page Two attribute that is no longer in use. So, I populate it with a unique value. If I have 500 or so part numbers, I create a csv file with two columns; one for the item number and the other column has that special unique value. I then use the Import tool from the web client to update all 500 parts, mapping that unique value to the special Page Two attribute. Then, I run the report and tell it to select all items having that unique value. It is true that the format of the report is ugly, but once you get it into Excel, you can use formulas to clean it up.
We’ve set up a custom External URL PX tool for many self-serve custom reports that aren’t handled by out-of-the-box Agile. Its a webapp that houses many custom reports that prompts users for certain report options. One of them us a multiple item where-used report which takes part numbers from a text box (each part number on a different row), parses for unique numbers, and then performs a where used search on each number, and presents the user with a single Excel file of the results. Bit of work to set up but we rely heavily on some of these custom reports.