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)
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.
On RcvHead you have a criteria that says PONum ISNULL
.
Missing the NOT
or just remove it.
Thank you!