Filter Vendor Receipt BAQ to only include Top 10 Vendors by Spend

Epicor ERP 10
,
1

I am trying to write a BAQ that will give me the OTD data for our top 10 vendors by how much we have spent over the past 12 months. I can get the OTD data for everyone just fine. The problem is filtering the top 10. I added an InnerSubQuery and tried filtering the Vendor Number on the main query to = any of the vendor numbers from the subquery :frowning: I tried adding the subquery as a table to the top level and linking it to the receipt vendor number :frowning:

Iā€™m not sure what else to try.

image

image

image
image864Ɨ293 11.3 KB

2

I was able to only return 10 results using these parameters. Note, it will only return top 10 of the overall report. Does this work for you?

image
image760Ɨ421 9.86 KB

3

I found the problem - the automatic link the system put between the Vendor and the Check header was on the wrong field :frowning: