Was this ever resolved? I too am trying to create a BAQ that pulls the NCR data but TrnType “P” - Purchase Order Receipts and “R” - RMA receipt do not return in the results.
I want to calculate the number of days the parts have been sitting in inspection and the average. I thought it would be a relatively easy query to pull together. Does anyone know which table the PO receipts are? Thanks!
@Ernie funny seeing you here! 