How do I run a query to see if the vendors I have in MSD have transactions posted against it?

(0) Share

Report

Posted on by edgeappsba

We have 12K vendors in our system. I want to clean up the vendors that dont' have any historical transactions against it (and find the date of the last transaction) What is easiest way to get a list of vendors without posted transactions including the last posted date?

All responses (3)

Answers (1)

André Arnaud de Cal... 293,207 Super User 2025 Season 1 on at

Like (1)

Report

RE: How do I run a query to see if the vendors I have in MSD have transactions posted against it?

Hi,

Your question contains a contradiction. You want to have a list with vendors without posted transactions, but including the last posted date? If there are no transactions; then there can't be a last posted date.

If you need to have a list of vendors without transactions, you can edit the advanced query on the form and add the Vendor transactions table using the operator not-exists.
Suggested answer

Sheikh Sohail 6,125 on at

Like (1)

Report

RE: How do I run a query to see if the vendors I have in MSD have transactions posted against it?

Hi

There are many tables where the applications set the reference of posting transaction but as the first step check-in vendttrans table
Verified answer

huijij 19,811 on at

Like (1)

Report
RE: How do I run a query to see if the vendors I have in MSD have transactions posted against it?

Hi edgeappsba,

You can write query statements similar to:

Select * from vendtable where not exists (select ACCOUNTNUM from VendTrans where transdate > your cut off date).