Question

Part Where Used

  • 24 November 2021
  • 1 reply
  • 435 views

We are going live very soon with EPICOR version 10.2.700.

We are interested in finding out if anyone has the same challenge we have in adding the ‘Part Where Used” highest level parent part. Currently, EPICOR’s “Part Where Used” lookup function only goes 1 level up and we need to go to the highest level and return the partID.

We have a job Traveller that we print for our production team members to produce manufactured parts and this highest level, parent PartID needs to be shown. 

 

To give a simple example of our multi level bill of material:

Level 1: 722512 - Dresser (Finished Good product that we sell to our customers)

  • Level 2: SA05245 - Case Assembly
    • Level 3: M00525 - Top
    • Level 3: M00526 - Gables
    • Level 3: M00527 - Bottom

When we create a job and print the Traveller for M00527, it needs to return in a field on the SSRS report the highest level parent. In this example above 722512

Very often the manufactured parts we engineer and produce are common parts used on many Finished Good Products or Parts as EPICOR defines them. We need to return the multiple highest level parents in this field shown on our Traveller.

So far I have not been able to find a way to create this customization simply through a BAQ or other method.

 


1 reply

Userlevel 3

We had Steve Rhoades at ERP Edge write us a custom dashboard for this.

you can contact him at Steve@erpedge.net

 

Paul

Reply