Inspection Pending BAQ not showing pending inspections


I have a BAQ that shows all parts still pending inspection. See below:

My BAQ results show as follows:

But when i run the canned Inspection Pending report in E10, i get these records:

So I cannot figure out why the PO receipts are not showing up in my BAQ.

Any ideas?


Are the parts on your PO in your Part Master?



1 Like

How can I connect that to my current BAQ, relationship-wise?

You can make it be another subquery and then union with your first query.

The common table would be part, but I would not try and create this as one big join.

Make sure the result column names are the same.