# How do you search for material parts number in a job with multiple assemblys

**URL:** <https://www.epiusers.help/t/how-do-you-search-for-material-parts-number-in-a-job-with-multiple-assemblys/123753>\
**Category:** Epicor ERP 10\
**Tags:** e10, epicor\
**Created:** [March 4, 2025, 8:50pm UTC](https://www.epiusers.help/t/how-do-you-search-for-material-parts-number-in-a-job-with-multiple-assemblys/123753 "2025-03-04T20:50:28Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jamie-Lill](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/85f322/32.png) [@Jamie-Lill](https://www.epiusers.help/u/Jamie-Lill)\
**Post date:** [March 4, 2025, 8:50pm UTC](https://www.epiusers.help/t/how-do-you-search-for-material-parts-number-in-a-job-with-multiple-assemblys/123753/1 "2025-03-04T20:50:28Z")

</div>

Is there a way to search for a specific material part number in a job with multiple assembly’s?  
I would like to find the part with the red arrow but I have to know the assembly to find it.

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

Thanks

---

<div class="post-metadata">

**Author:** ![Craig](https://www.epiusers.help/user_avatar/www.epiusers.help/craig/32/52991_2.png) [@Craig](https://www.epiusers.help/u/Craig)\
**Post date:** [March 4, 2025, 8:54pm UTC](https://www.epiusers.help/t/how-do-you-search-for-material-parts-number-in-a-job-with-multiple-assemblys/123753/2 "2025-03-04T20:54:47Z")

</div>

you should be able to go to the material tab of Job tracker and go to list view. that should list all the mtls.

---

<div class="post-metadata">

**Author:** ![Jamie-Lill](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/85f322/32.png) [@Jamie-Lill](https://www.epiusers.help/u/Jamie-Lill)\
**Post date:** [March 4, 2025, 8:59pm UTC](https://www.epiusers.help/t/how-do-you-search-for-material-parts-number-in-a-job-with-multiple-assemblys/123753/3 "2025-03-04T20:59:59Z")

</div>

Hi Craig,  
It only show the material in the sub assembly you selected. I am running Epicor 10. I need to search all sub assembly’s for the material part number.

---

<div class="post-metadata">

**Author:** ![Craig](https://www.epiusers.help/user_avatar/www.epiusers.help/craig/32/52991_2.png) [@Craig](https://www.epiusers.help/u/Craig)\
**Post date:** [March 4, 2025, 9:14pm UTC](https://www.epiusers.help/t/how-do-you-search-for-material-parts-number-in-a-job-with-multiple-assemblys/123753/4 "2025-03-04T21:14:07Z")

</div>

if you can make a BAQ, the jobmtl table will have all that info.

---

<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:** [March 4, 2025, 9:14pm UTC](https://www.epiusers.help/t/how-do-you-search-for-material-parts-number-in-a-job-with-multiple-assemblys/123753/5 "2025-03-04T21:14:40Z")

</div>

A BAQ on JobMtl will do this, but I am not aware of a where used on Jobs, only boms.

---

<div class="post-metadata">

**Author:** ![Mark\_Wonsil](https://www.epiusers.help/user_avatar/www.epiusers.help/mark_wonsil/32/51594_2.png) [@Mark\_Wonsil](https://www.epiusers.help/u/Mark_Wonsil)\
**Post date:** [March 4, 2025, 9:18pm UTC](https://www.epiusers.help/t/how-do-you-search-for-material-parts-number-in-a-job-with-multiple-assemblys/123753/6 "2025-03-04T21:18:38Z")

</div>

I think if you have the Executive Analysis module, there is a Part Where Used tracker that does the trick:

 ![image](https://www.epiusers.help/uploads/default/original/3X/3/0/304ff49b2ce65f52867cc3faefe915a5b02c8250.png)

This does exist in E10.

---

<div class="post-metadata">

**Author:** ![Jamie-Lill](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/85f322/32.png) [@Jamie-Lill](https://www.epiusers.help/u/Jamie-Lill)\
**Post date:** [March 4, 2025, 9:18pm UTC](https://www.epiusers.help/t/how-do-you-search-for-material-parts-number-in-a-job-with-multiple-assemblys/123753/7 "2025-03-04T21:18:43Z")

</div>

Thanks all