Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Epicor 9 BAQ 2 level BOM Multiple Revisions

Status
Not open for further replies.

KPNeedsHelp

Technical User
Jun 10, 2015
1
US
I'm hoping someone out there has tried to do this and can offer some help

I've created a BAQ that pulls level 2 of my BOM, however I'm having trouble with items that have multiple approved revisions.

My parent part table is PartMtl and I have linked it to PartMtl and given that table and alias of Level2. The table relationship is PartMtl Parent MtlPartNum to Child table Level2 PartNum. I can't link on the revision number because then it only pulls the BOM parts for 8888 Rev A and I need it to only pull BOM parts for 8888 Rev D.

Example: My parent part in level 1 is 9999 Rev A
in my BOM I have a subassembly part 8888 Rev D. However, part 8888 also has approved revisions A, B and C.
I can't get my BAQ to only pull the revision that is in the actual BOM, it pulls all revisions.

Is there even a way to do this?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top