Issues with BAQ

Epicor ERP 10
1

Just finished the class through epicor on making BAQ and I am pretty new at this, so bear with me…

Trying to make a BAQ that lists all parts made on our system that are not cross referenced with a customer yet. So far I have only gotten it to spit out a list of all the parts on our system that are cross-referenced to a customer. Any advice or tips on what I might have to change for this query to work correctly?

Apologies if this isn’t clear enough, just started working with BAQs.

Thanks

2

Hi Kevin,
It sounds like you are getting where records have matches, but not the ones without. Use an outer join to show all and then when the cross ref fields are blank you’ll know there was no match.

Nancy

3 Likes
3

Thanks Nancy,

I will give that a try. Figured it had something to do with the joining of the tables.