BAQ that shows material part demand

Epicor ERP 10
, ,
1

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!

2

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

3

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.

1 Like