BAQ: Query for Active Vendors

baq
e10

(Krismina) #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?


(Zoher Ali) #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


(Krismina) #3

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