Announcements
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?
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).
Hi
There are many tables where the applications set the reference of posting transaction but as the first step check-in vendttrans table
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 412 Super User 2026 Season 1
Subra 396
Martin Dráb 261 Most Valuable Professional
