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
We are having issues running trial balances. They are taking over 45 minutes to run and i need to figure out what is causing this, not sure if its a SQL or AX issue. Any guidance would be appreciated, i have tried to Compile/Generate CIL and restart AOS services with no luck. Here are some screenshots of the SQL trace.
For what period do you run this report? Is it just a single month or the whole year?
Has the standard report been modified?
What financial dimension set did you select? Have you already tried rebuilding the financial dimension set?
Is it equally slow if you run it a second time right after the first run? If it's faster on the second time, maybe enabling Rebuild balances batch jobs could speed it up.
If those dimension set balances are not up to date, the system has to update them when the report is printed.
Running this for a our last period 4/22/19-5/28/19, single month.
The standard report has not been modified.
The Financial Dimension set has been set to "Main Account Set"
Have not tried rebuilding the financial dimension set, how would i do that?
I ran the rebuild balances and refreshed the trial balance page and it now shows the balances and tried to run the report again with no luck. The report is still taking a while to generate the details.
Just wanted to give you guys an update. I was able to resolve the issue by going into SQL and running update statistics on the tables that were associated with the query for the Trial balance.
Great to hear that you have fixed your issue.
Just wondering how long it takes you to run the report now in seconds/minutes.
Business Applications communities