Notifications
Announcements
No record found.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 544 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
