Announcements
No record found.
I have a requirement where I need to list out all the active vendors which have no transactions since some date(say 2018). How do I list out all those vendors in AX 2009?
Two ways of doing this: 1. SQL query if it's one time request 2. Write code in AX. Query in both cases would be like: Select * from vendtable where not exists (select vendor account from VendTrans where transdate > your cut off date). See if you have additional requirements where in u have to remove vendor from this list if they have open PO etc.
Yes, I have a requirement where I need to exclude the vendors with an open balance from the above list. How can that be achieved?
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.
Giorgio Bonacorsi 617
André Arnaud de Cal... 461 Super User 2026 Season 1
Syed Haris Shah 298 Super User 2026 Season 1
