BAQ that shows material part demand

[DAEpicorian (Dana Andrejeva)]

Hi all,

I have been requested to create a BAQ that shows the demand for material parts specifically from sales orders, so not the demand for the top level part, but its materials. We have started by creating a subquery that pulls in the orders and parts required for it and qty of top level part required. Then the next subquery lists the material parts for that part and multiplies how many of the material part top part requires by the number of top part required. However, the issue we run into is that some of the material parts are actually subassemblies that have component parts themselves, which again there is a requirement to know the demand for those, but the BAQ doesn’t show that.

Has anyone had to do something similar please; how did you go about it? Thank you!

[gpayne (Greg Payne)]

I would review this thread and the baq attached in it.

Build BOM in Query

This CAN be done… but it takes a RECURSIVE (CTE) BAQ. I have demoed this in the past at user group meetings. Note that this is NOT something for the faint of heart… your brain gets twisted while trying to get your head around a CTE query. BOM_Explode.baq (72.8 KB) Recursive BAQs.pdf (983.2 KB)

[JasonMcD (Jason McDermott)]

You don’t run MRP, I guess? Or at least not for the parts in question?

If you do, you might be able to run multi-level pegging (if you’re not doing jobs make-direct already).

But Greg’s idea is certainly the direct answer to your question.