Breaking news from around the world
Get the Bing + MSN extension
End of mainstream support for Microsoft Dynamics AX 2009, 2012, and 2012Mainstream support for Dynamics AX 2009 Service Pack 1 (SP1), Dynamics AX 2012, and Dynamics AX 2012 R2 ended Oct. 9, 2018. After that date, only security hotfixes will be provided for these three versions through the extended support period that until Oct. 12, 2021. Read more
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
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 and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
I'm using AX2012 and need to make query for customer aging report with SQL.
If anyone already have the query or can give information, please give it to me.
Why do you need it in SQL? There are out of the box configurable reports available. You are not telling what information should come out of the query. can you also tell in detail what you expect from such query?
I mean I want to see the result of customer aging report in SQL. If there are many ways to make the report with sql query, I just want to know standard report query.
If you follow the logic used by Microsoft to create their report, you might be able to compose an SQL query. But, you haven't answered why you need an SQL statement... What would be the purpose?
Why do you need to do that?
Doing that seems to be quite complex. See e.g. the notes that you can find here:
Thanks Andre and Ludwig,
The purpose of my need for sql query to make customer aging report is to use for Power BI.
Our Power BI project will use the query to bring the data same as the report from AX.
Like previous posters said, you would need to "reverse engineer" this complex report, by looking how it's designed. You can also capture trace and use Trace parser to see the underlying SQL queries.
Or, you might export the AX SSRS report to Excel and use that Excel as a data source in Power BI.
Business Applications communities