# Baq bom

**URL:** <https://www.epiusers.help/t/baq-bom/103179>\
**Category:** Kinetic ERP\
**Tags:** baq, epicor\
**Created:** [May 22, 2023, 6:36pm UTC](https://www.epiusers.help/t/baq-bom/103179 "2023-05-22T18:36:41Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![taustin](https://www.epiusers.help/letter_avatar_proxy/v4/letter/t/ecccb3/32.png) [@taustin](https://www.epiusers.help/u/taustin)\
**Post date:** [May 22, 2023, 6:36pm UTC](https://www.epiusers.help/t/baq-bom/103179/1 "2023-05-22T18:36:41Z")

</div>

Hello  
I am trying to create dashboard with all our parts with their BOM’s. I have it done except i have a lot of parts that have more than one material on their BOM’s? how do i get more than just the first MtlSeq on it?

 ![image](https://www.epiusers.help/uploads/default/original/3X/5/5/5520c3493a08eba033fc9f313b62418d8a896a25.png)

---

<div class="post-metadata">

**Author:** ![gpayne](https://www.epiusers.help/user_avatar/www.epiusers.help/gpayne/32/55751_2.png) [@gpayne](https://www.epiusers.help/u/gpayne)\
**Post date:** [May 22, 2023, 6:42pm UTC](https://www.epiusers.help/t/baq-bom/103179/2 "2023-05-22T18:42:15Z")

</div>

@taustin without seeing the baq it is hard to say. do a search for bom explode and there are some good example of how to do this for multilevel boms

---

<div class="post-metadata">

**Author:** ![taustin](https://www.epiusers.help/letter_avatar_proxy/v4/letter/t/ecccb3/32.png) [@taustin](https://www.epiusers.help/u/taustin)\
**Post date:** [May 22, 2023, 6:53pm UTC](https://www.epiusers.help/t/baq-bom/103179/3 "2023-05-22T18:53:50Z")

</div>

I attached the fields i pulled in for the BAQ. Here is the test screen. If you look at the first # 010562000 we use the 882021 plus another material. I need both to show up on this BAQ  
Does that help at all?

---

<div class="post-metadata">

**Author:** ![taustin](https://www.epiusers.help/letter_avatar_proxy/v4/letter/t/ecccb3/32.png) [@taustin](https://www.epiusers.help/u/taustin)\
**Post date:** [May 22, 2023, 6:54pm UTC](https://www.epiusers.help/t/baq-bom/103179/4 "2023-05-22T18:54:15Z")

</div>

![image](https://www.epiusers.help/uploads/default/original/3X/2/3/232cc6c5240788692c3f13c99b904db63afebf59.png)

Sorry here is the attachment

---

<div class="post-metadata">

**Author:** ![gpayne](https://www.epiusers.help/user_avatar/www.epiusers.help/gpayne/32/55751_2.png) [@gpayne](https://www.epiusers.help/u/gpayne)\
**Post date:** [May 22, 2023, 7:00pm UTC](https://www.epiusers.help/t/baq-bom/103179/5 "2023-05-22T19:00:44Z")

</div>

If it is just PartMtl then there a condition stopping the rest. Are there other tables that are joined but not displayed? I would start with no conditions.

---

<div class="post-metadata">

**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\
**Post date:** [May 22, 2023, 7:06pm UTC](https://www.epiusers.help/t/baq-bom/103179/6 "2023-05-22T19:06:06Z")

</div>

This BAQ will need to be a CTE. otherwise, you will only get one level.

Multi-Level BOM creation is fun, you have to figure out which part rev of the child you want to use, as you go down levels of the BOM.

---

<div class="post-metadata">

**Author:** ![taustin](https://www.epiusers.help/letter_avatar_proxy/v4/letter/t/ecccb3/32.png) [@taustin](https://www.epiusers.help/u/taustin)\
**Post date:** [May 22, 2023, 7:11pm UTC](https://www.epiusers.help/t/baq-bom/103179/7 "2023-05-22T19:11:07Z")

</div>

i only have the Part Mtl on it

 ![image](https://www.epiusers.help/uploads/default/original/3X/d/b/dbda3800971ca4e3bd00a0172a2c716f36fd6420.png)

---

<div class="post-metadata">

**Author:** ![gpayne](https://www.epiusers.help/user_avatar/www.epiusers.help/gpayne/32/55751_2.png) [@gpayne](https://www.epiusers.help/u/gpayne)\
**Post date:** [May 22, 2023, 7:12pm UTC](https://www.epiusers.help/t/baq-bom/103179/8 "2023-05-22T19:12:55Z")

</div>

@knash I think she is just dumping PartMtl, so all materials should show.

---

<div class="post-metadata">

**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\
**Post date:** [May 22, 2023, 7:14pm UTC](https://www.epiusers.help/t/baq-bom/103179/9 "2023-05-22T19:14:56Z")

</div>

Yes but this will not be a multi-level BOM.

---

<div class="post-metadata">

**Author:** ![taustin](https://www.epiusers.help/letter_avatar_proxy/v4/letter/t/ecccb3/32.png) [@taustin](https://www.epiusers.help/u/taustin)\
**Post date:** [May 22, 2023, 7:15pm UTC](https://www.epiusers.help/t/baq-bom/103179/10 "2023-05-22T19:15:13Z")

</div>

sorry it is working. I see what i did wrong. Thank you everyone