Active Vendor Activity within a certain amount of time

(0) Share

Report

Posted on by alw

I am trying to provide a list of all current vendor's from the PM00200 table that have had activity within the last 6 months. What's the best way to do this?

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

sid jayawardena1 on at

Like (0)

Report

you could use a subquery

SELECT *

from pm00200

where [vendorid] in (select [vendor id] from payablestransactions where [document date]>'2/3/2014')

Was this reply helpful? Yes No
alw 35 on at

Like (0)

Report

Will that tell me that there was activity within 6 months? Not that something was changed on the vendor (like address, phone number, etc.) I am referring to activity made by/for the vendor (invoice, payment, etc.). Also, how can I specify the number of months to check compared to the current date instead of hard coding the dates. Another customer might want to see all vendors who had activity 8 months prior to the current date.

Thank you!

Was this reply helpful? Yes No