Notifications
Announcements
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Volodya 2
tgudwanski 1
