Job and SO Pick List BAQ Issues

Epicor ERP 10
1

Hello,

I have created a BAQ for reporting the open material requirements for jobs and sales orders which will be used in a BAQ report and dashboard to pick materials by day.

Currently there are a few issues in the report that I cannot understand. Parts-on-the-fly are not appearing in the query as they should. This is very important. I included in the subquery criteria to filter so that materials with an on hand quantity >0 or NonParts will show. This should show materials in stock as well as parts on the fly.

I have also attempted to filter out materials for sales orders that have not been received, but for some reason they are still appearing. In the subquery criteria, I included a statement that checks if RcvDtl.Received = 1 or PartDtl.JobNum is not null. (Only show received orders and jobs)- but unreceived orders are still showing.

Can anyone see what is wrong?
Here is the BAQ: PICK_BY_DAY.baq (69.3 KB)

3

I have solved the parts on the fly issue by checking if the PartNum from PartDtl is not IN the Part table instead of using the NonPart field.

I still do not understand why sales orders that are not received are showing up though.