BAQ For showing ready to fullfill

Epicor ERP 10
1

I am trying to create a BAQ to show that a parent part is available to fullfill because child components are in stock. I just can’t seem to get the right combination of table values to make this work.

my end goal,
a dashboard with a single jobnum and partnum that would only display jobnums that are 100% fullfillable by checking that the jobmtl all shows in stock. I can get it to where it shows me that a job is partially fullfillable, but I really want it to show me when ALL jobmtl is in stock. I am guessing this has something to do with a subquery or type that I just don’t understand yet.

I am using jobhead, jobmtl, and partbin. maybe there is a better table?

Any advice? Thanks!

2

There is a process called “Production Planning Process” that you run after MRP finishes, and then use the Production Planner Workbench to view the results. On the “Jobs” tab you can see both jobs with shortages and jobs with full availability, and you can slice and dice with various search parameters.

3

Hmm, I must have a bug. Ernie, I will PM you.