BAQ for PO approved but not received

I’m trying to write a BAQ that shows all POs with inspection required flagged and approved but not yet received. I don’t think it’s working correctly, when I go to rcvhead I’m seeing the PO numbers.

kcc-UnreceivedPO.baq (28.7 KB)

You could add the PORel table… and just filter on PORel.ReceivedQty = 0 (or < RelQty if you want to include partial receipts).

That would help cover a PO that has multiple lines but only some are received.

1 Like

On RcvHead you have a criteria that says PONum ISNULL.

Missing the NOT or just remove it.

Thank you!

1 Like