sort item list by customer

When my qb was migrated into acct suites, there were a load of old part number brought over.  I understand why, since i had previous transactions using them in qb.  We are a manufacturing business and have a large amount of parts that we have produced over the years.  I would like to not see the inactive parts and also be able to see just a certain customers parts. in the list, instead of taking forever to find a specific part.  Any ideas would be helpful