Skip to content
Dynamics 365 Blog

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

PowerBI.com and Microsoft Dynamics NAV 2015 

Power BI just got even more attractive – Microsoft Dynamics NAV 2015 is ready to take on all the benefits! At Convergence 2015, Satya Nadella, CEO of Microsoft, announced that the PowerBI.com preview would be released worldwide. This is an exciting opportunity for our Microsoft Dynamics NAV users around the world to leverage their existing...

Read more

A Couple of RDLC Performance Optimization Tips 

We have received several requests related to optimization tips for the Microsoft Dynamics NAV RDLC report experience. So in this blog post we provide you with a couple of tips for how you can refactor a report in order to increase its performance in terms of dataset reduction – the example is based on the...

Read more

Report Execution Insights 

With the release of Microsoft Dynamics NAV 2015, the way reports are executed has changed. In Microsoft Dynamics NAV 2015, reports can use a built-in RDLC layout (as before), a built-in Word layout, or a custom layout, which can be based on RDLC or Word. Built-in layouts are part of the report object, while custom...

Read more

NEW document reporting tool for Microsoft Dynamics NAV 2015 

Microsoft Dynamics NAV has a great business insight story – Dynamics NAV 2015 makes it even better! With Microsoft Dynamics NAV 2015 endusers can now customize and create their own document reports in familiar Microsoft Word. Building on this capability, Microsoft has announced the upcoming availability of the Microsoft Word reporting add-in – Jet Reports...

Read more

Windows Regional Settings and Number Formatting in RDLC Reports 

You probably know this blog post from Robert Miller: http://blogs.msdn.com/b/nav/archive/2014/03/25/formatted-decimal-values-dropping-symbols-in-rdlc.aspx. It talks about changing/forcing number formats when Windows is not able to do so. For Switzerland (de-CH), number formats in Windows are not correct regarding the thousands separator. It should be formatted “1’234,56” but is formatted like “1 234,56” (a space instead of an apostrophe).  Current...

Read more

Formatted decimal values dropping symbols in RDLC 

I have seen several reports about the Microsoft Dynamics NAV RDLC reports dropping symbols out of decimals when printing out a report.  One of the most common occurrences, that I have seen, is when the de-CH locale is being used by the end user.  After some investigation, it appears that this problem is due to...

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

RDLC Report and Performance in Microsoft Dynamics NAV 

It has been a while since I last blogged and I am taking the chance now to post on a very delicate argument. The main focus of my dissertation is about performance (Out Of Memory exception, typically) with Microsoft Dynamics NAV 2009 R2, Microsoft Dynamics NAV 2013, and Microsoft Dynamics NAV 2013 R2. I would encourage you...

Read more

SAVEASWORD and the Fixed Header design 

Microsoft Dynamics NAV 2013 and Microsoft Dynamics NAV 2013 R2 implement a new rendering extension and give users the capability of saving the report into Word .DOC (NAV 2013) or .DOCX (NAV 2013 R2) format. The same action can be done through C/SIDE by using the SAVEASWORD C/AL statement.  For more information, see the MSDN Library:...

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

Delivering more choice with Zetadocs Express 

Equisys has released a new version of Zetadocs Express for Microsoft Dynamics NAV that not only supports Microsoft Dynamics NAV 2013 R2, but also includes the ability for customers to archive documents to network folders on their file servers....

Read more