Part number / primary supplier baq - need help

Epicor ERP 10
1

I have an urgent need for some help if anyone knows how to address this.

TASK: I am trying to creat a BAQ that will list ALL active Part Numbers along with the PRIMARY SUPPLIER.

I have tried a few combinations but my BAQ results in only 2678 records for my 7700+ Part Numbers.

Any suggestions how to accomplish the above task.
NOTE: I do not yet know how to create a subquery, so if there is a way to do it without a subquery that would be great!

Jay

2

Start with Part, and add a filter Inactive = 0
Then add an inner join from Part to Part Plant
Then add a left join to Part Plant to Vendor

This should show you all active parts, and if there is no primary supplier, Vendor ID or Vendor Name (whichver you choose to display) will be blank.

image
image.png757×663 60.6 KB