Notifications
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.
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 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
