Hi all,
I am trying to create a BAQ that lists all of the PO’s a customer has written along with the PO type (Inventory, Job, Subcontract, Other). I am using the TranType field from the PORel table but cannot find a similar field on the PODetail. The Type field on the line is not linked to a field but rather appears to be a calculated field. Does anyone know how to get this into the BAQ?
You want to group on the POType in the release. This means that if you have multiple types at the release level (e.g. buy to job AND buy to inventory) you will end up with the line being repeated for each unique type on the releases.
Thanks John, the problem I am having is that I cannot get the type from the line, not the release, into the query.
Correct, you will have to add the PORel to your query, it does not exist at the line. Add the PORel to your query and add in the type field. Don’t add any other fields from the release. Mark every column as Group By and you should be good. Pending you don’t have anything else in there that might cause extra records.
