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?
Thanks!
Are the parts on your PO in your Part Master?
Yes.
Rcvdtl.
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.
