BAQ: Query for Active Vendors

Epicor ERP 10
,
1

Is it possible to query for Vendors which we haven’t purchased from in over 2 years? If so, does anyone have an idea of how to do this?

We have over 700 vendors in our database and we would like to clean out and flag the ones that we haven’t purchased from in over x amount of time as inactive. I’m aware that you can manually search up each vendor in the Supplier tracker and retrieve all POs from them, but is there a more efficient way of doing this rather than go through all 700 vendors?

2

Hi @KLA

You can create BAQ as below:

  • Create CTE query to list all distinct VendorNum FROM POHeader and put criteria for date parameter on OrderDate.

  • In main query Select Vendor Table and put criteria to select VendorNum IN CTE query.

I hope this will fulfill your requirement.

Regards

3

thank you for your response. this has met my requirement.

4

I am trying to do this same exact thing in 10.2.400 but cannot get it to work. Could someone assist?

I have the first query selecting POHeader, CTE, Distinct. Displaying VendorNum, PONum and OrderDate.
I have the next query as a TopLevel with All Result Set Rows.
Criteria between the two queries as VendorNum.
I haven’t set the OrderDate criteria yet but my results still return all vendors and all of their PO’s.
This is my first time attempting CTE.

Thanks,
Chris