I followed the instruction for creating an indented BOM query based on the epicor guide. I’m trying to filter it by purchased parts but it’s difficult to do so when our BOMs go between 5 and 7 levels deep.
Essentially, I want to see all of the purchased parts within the bill of materials regardless of which level it falls under so we can evaluate what we have on hand to determine the next time we can manufacture a finished good.
If anyone has experience with this, or if I’m missing something easy, let me know please.
I answered my own question. I simply added a part table to the top level query, and connected it to the subquery with subquery11partmtl_mtlpartnumber = part_partnumber, then added display field of type code (P or M). Now it displays.
I don’t know if this applies to you, but I’ve gotten burned before where we have some purchased parts that are setup with a method of manufacture because we can build them or buy them. They will show up as required parts for your top-level even if the parent part is coded as P. You may want to consider that if you have any situations where you have methods under a purchased part.