If I enter one part number after another in part maintenance, each part remains loaded, and the arrows at the top of the screen can be used to tab through them. I have a column of part numbers in Excel and would like to load them all into part maint at once. Is there a way to do this that doesn’t involve tools like DMT or a BPM? (I need to do this with random groups of part numbers over a period of time.)
I think you would have to do this with a BAQ and a quick search or named search. You would have to update the criteria for the BAQ before running the search from Part Maintenace. But this should let you copy/paste part number lists into the BAQ criteria.
2 Likes
Posting back to confirm this worked. This was the BAQ I used:
select
[Part].[PartNum] as [Part_PartNum]
from Erp.Part as Part
where (Part.PartNum in ('PART1', 'PART2', 'PART3'))
Save this with the BAQ Search like column set to part num. Reopen the Part Maintenance Search and click over to the BAQ tab. find the BAQ you save, and it should return only the parts that match those in your BAQ list. Looking for new parts? Paste/insert into the “IN” list in the BAQ table criteria before you open Part Maintenance.
1 Like