Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Power BI reports in Microsoft Dynamics 365 for Finance and Operations will display no data, blank, or empty if default main account categories are not used

If you enabled Power BI integration in your Microsoft Dynamics 365 for Finance and Operations system as instructed in the article below, you may notice that parts of the reports do not display data while some do, even though there are transactions in the system and the Power BI reports were not modified by you…. Read more

Data collection for the Named User License Counts report in Dynamics AX 2012 R3 Cumulative Update 9 and later

You may be already familiar with the blog post of my colleague in which the background of the Named User License Counts report is explained. Using the Named User License Count report In this post, I would like to explain a change that was introduced in relation to this report in Cumulative Update 9 for… Read more

Why does converting a report to pre-processing help to resolve timeout issues?

I assume you are familiar with the below post that contains detailed instructions for increasing relevant timeouts to enable long running reports to execute successfully. How To: Addressing SSRS Session Timeouts (Alternatively Tips to help prevent long-running reports from timing out [AX 2012]) The first recommendation in case of reports which use the Report Data… Read more

View a full breakdown of cost per item using the Inventory Value Statement with Standard Cost Breakdowns report in Dynamics AX

*Disclaimer: This blog only applies to items using a Standard Cost item model group.   Many customers have the need to view a full breakdown of costs for individual items that they produce, but have difficulty generating a report that accurately and cleanly breaks down this information.  This can easily be achieved by effectively utilizing… Read more

AX Content: Warm up those SSRS servers

Microsoft SQL Server Reporting Services periodically restarts, and each restart clears the Reporting Services cache. After this cache has been cleared, it may take some time for the next report that is run to display. For example, you may have noticed that it takes a really long time for the first report that is run… Read more

AX Content: Email reports to specific people by using tokens

With cumulative update 7 for Microsoft Dynamics AX 2012 R2, you can email reports to specific people by using tokens. When you use this feature, you don’t have to enter the email addresses of all recipients. Instead, you simply enter a token. The token instructs Dynamics AX to retrieve the appropriate email addresses from worker,… Read more

AX Content: Using Power View with Dynamics AX

Have you heard about Power View? Microsoft introduced the interactive data exploration, visualization, and presentation tool with SQL Server 2012. You can use it with Microsoft Dynamics AX to build some amazing-looking reports. It’s just another reporting tool, isn’t it? I’ve been a technical writer for 14 years. I’ve seen my fair share of reporting… Read more

We want to hear from you! Participate in the Microsoft Dynamics AX product suggestions program

Make your opinion count! Give us your product suggestions and help to make future versions of the Microsoft Dynamics AX applications better. Use this Microsoft Connect site to submit your product suggestions for Microsoft Dynamics products. Search existing suggestions and vote on suggestions submitted by others. Your feedback counts – future versions and enhancements of… Read more

Dynamics AX 2012 Reporting: How to add company logo into query based report

In the old X++ framework (Dynamics AX 2009 and earlier) when you wanted to display company logo on report you could use display method on table. In Dynamics AX 2012 that would not work. For RDP reports you could add CompanyLogo field into temporary table and then fill it in Data Provider class (for details… Read more

AX 2012 Print destination settings dialog does not show up due to WMI error

I recently came across a case where the printer destination settings dialog typically used by report to select print destination does not show up. The cause we found is that an exception occurs when Dynamics AX client queries existing printer from hosted machine.  The code is from Forms\SRSPrintDestinationSettingsForm\printerMap() at line 30 which is a call… Read more