Part Info lookup

Anyone know of a way to take a list of parts and do a quick lookup on that list to retrieve the descriptions or other database info?

Where’s the original list? How big is the list?

It’s in excel, 1000 part numbers.

Charlie

A couple of approaches:

  1. do a BAQ table dump of the part information you need, paste it in XLS and use VLOOKUP
  2. create a menu for one of the UD tables, open the module and paste insert the part numbers into Key 1 list view and then do BAQ queries linking your UD table to whatever part tables you need
  3. tie the XLS file, and the Epicor tables, to Access as linked tables and then write the queries needed. Super easy, and super powerful but the tables are live if you have wide open access. :slight_smile:

Ross

2 Likes

Ross,

Interesting set of options. To bad I can’t just paste insert the list into a dashboard…

Thank you for the feedback, I am sure all three will solve the problem.