Are there jobs created at the point you’re wanting to look at demand? There are two ways I would look at this:
Use MRP to create unfirm jobs so that demand for each subassembly and raw material is generated. This lets Epicor do all the hard work and all you have to do is review demand for each part.
Build a recursive BAQ that iterates through each level of each part’s BOM to explode out the full multi-level BOM for the parent part you’re looking at. From there, you can multiply the order quantity by the total qty/parent for each subassembly and raw material to see total demand at each level.
If you mean that you do have jobs created but can’t see demand for parts that are subassemblies on these jobs, you should be able to use the JobAsmbl table to view each assembly level on jobs to see total quantity of parts needed at each level as well as total parts already made.
We let MRP create all of the unfirm jobs and use those to see demand volume. We don’t have our scheduling parameters nailed down 100% so there is some movement in time for which components go to which jobs/orders, but overall the quantities are accurate and we can use them to drive planning.
PartA and PartZ are being updated with new products PartA2.0 and PartZ2.0 launching soon. PartC is NOT in PartA2.0 and PartZ2.0, but is expensive and needs to deplete before we implement PartA2.0 and PartZ2.0. So we need to know when we will run out PartC to prompt the launch of PartA2.0 and PartZ2.0