Announcements
No record found.
Hi ,
Please help me to find out vendors having no transaction, because we have large number of vendors and delete the inactive vendors
*This post is locked for comments
VendTable has a restricted Delete action for VendTrans, which means you cannot delete any vendors who have at least 1 transaction in the system.
It is a 5 minute task for your AX developer to write a simple job for the above two tables linked by AccountNum with a notExists join to find the vendors who do not have any transactions. Those could be deleted.
Thanks vilmos
Although your question has been answered already, I have changed the title as "AP" is not very descriptive. Please use better titles in future. Also don't use names of volunteers in your tags. I have removed them.
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 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
