Breaking news from around the world
Get the Bing + MSN extension
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
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?
Business Applications communities