TEAMS Corporation

(612) 361-3360

Free 1 Hour Question & Answer via Go To Meeting

EAM Parts Scrubber


Fact: High Quality Part Records Produce Cost Savings

Manager to Storekeeper: “I read a White Paper that stated, the “cleaner the part records, the less time our technician will spend searching for a part(s)!”

Storekeeper to Manager: “I agree, our technician’s waste a lot of screen time searching for a part(s), because over the years, the part’s data was created by different individuals, with no pre-determined standards to follow. The records need to be cleaned up.”

Manager to Storekeeper: “Well said, I want to you to edit each record and start with the standardization of the part’s description, using the noun/adjective methodology. Then, populate the manufacturer code, commodity code, keywords, min/max levels. Plus make sure each part has a bill of material assignment and an associated vendor record.”

Storekeeper to Manager: “The difficult is done immediately, this will take a little longer. I heard that TEAMS has a Part Data Scrubber Enhancement for EAM, I’ll contact them right away.”


  • Part Search— ROI Calculator

Part Search ROI Calculator
$25 per hour is used (40 cents per minute) to calculate cost: Annual Labor Savings is based on 250 days.

• In addition to the daily improved Part search savings shown above, the labor required for the initial clean up effort and the on going maintenance of the Part Master records can be significantly reduced, resulting in the saving of thousands of labor dollars each year.

  • Sample Storeroom Menu

Sample Storeroom Menu

  1. Note – the above menu is an example of EAM’s ability to customize end user menus, i.e. Manager, Supervisor, Planner/Scheduler, Technician, Stores.
  2. Note – the following slides will demonstrate the EAM Parts Scrubber Enhancement.
  • Enhancement - Part Master Selection

Enhancement Part Master Selection

  1. Scan — the entire Part Description field of 100 characters.
  2. Vendor ID — Produce a summary of part associated with a particular vendor, i.e. Grainger or Motion Industries.
  3. Machine (Asset) ID — Produce a summary of parts associated with a particular asset, a.k.a. Where Used.
  4. Bin Label — Produce a bin label, quickly, for an individual part. This is just one of several options for bin label printing.
  5. Note — the next example will be a summary of parts where the Part Description search criteria is “bearing”.
  • Enhancement - Part Master Summary Screen – “Before” View

Enhancement Part Master Summary Screen Before View

  1. Note — the above example is a summary of bearing records that where created over several years, by several end users – hard to read - lost productivity!
  2. AC-8 Where Used — Produce a summary of asset records where the selected part is associated with the asset’s bill of materials.
  3. F16=Sequence — Powerful new feature, allows for the review of 37 part master data fields, i.e. manufacturer, keywords, commodity etc.
  4. Produce a bin label(s), quickly, for one or more selected parts. This is just one of several options for bin label printing.
  • Enhancement - Part Master Summary Screen – “After” View

Enhancement Part Master Summary Screen After View

  1. Note — the above example is a summary of bearing records that been properly edited by the part description field – easy to read – increased productivity!
  2. F16=Sequence, continue to review additional data fields, i.e. manufacturer, if applicable.
  • Enhancement – F16=Sequence Selections

Enhancement F16 Sequence Selections

  1. Sequence — Powerful new feature. Provides the ability to produce and edit a summary of part records by 37 data fields.
  2. Note — in the following example, a summary of part records will be produced by the manufacturer field.
  • Enhancement – Part Master Summary Screen

Enhancement Part Master Summary Screen

  1. Note — Any part record(s) with a “blank” manufacturer field will be at the top of the summary screen(s). This also allows for the review of inconsistent codes that were created incorrectly over the years, i.e. A-B, AB, A/B (Allen-Bradley) is a common example.
  2. Enter AC-2 (Action Command) for each part record(s) to be reviewed and edited.
  • Enhancement – Part Master Summary Screen – Where Used

Enhancement Part Master Summary Screen Where Used

  1. Note — the above example is a summary of bearing records that been properly edited by the part description field – easy to read!
  2. Note — AC-8 Where Used, will produce a list of asset(s), that the selected part is found on the asset(s) bill of materials.
  3. Best Practice — Generally speaking, all repair related parts should have at least one asset that it is associated with.

Enhancement Part Master Summary Screen Where Used Alternate

  1. Part’s Where Used asset (s)summary.
  2. Selected part record from the previous part summary screen.
  3. Where Used summary screen lists one or more assets and asset description.