Microsoft Dynamics NAV 2009 Ships!

A week ago, the Microsoft Dynamics NAV team celebrated the launch of version 2009, a product that involved over three years of work.  We had a party on the MDCC campus (which subsequently ended up in an Irish bar somewhere in Copenhagen) and spent some time talking about our accomplishments.  The energy in the room… Read more

Using variables and C/AL code in a report in NAV 2009

This previous blog “NAV 2009 – The structure of reports in VS report designer” describes how to get data from your data items into the layout of a report in Visual Studio (VS) report designer. This time we look at how to control the iterations of a report with code, and showing variables rather than fields… Read more

Dynamics NAV and export to Excel: Export dates as true excel dates

When running Send-to Excel functionality and exporting data to MS Excel using style sheets, all data exported form NAV is formatted as either numbers or strings. That also includes dates, that are exported as strings and not formatted as true dates in excel. As of update 1 for NAV 5.0 SP1, data.xml generated when running export to excel… Read more

NAV 2009 – Report Designer – Introduction to the new environment

Microsoft Dynamics NAV has always had its own report designer. In NAV 2009 it still does, but in addition to this you can also use the Visual Studio (VS) report designer. NAV 2009 – both the classic and the new client – will still run reports designed in NAV’s report designer. So in way nothing… Read more

TAP Customers and Partners Deploy Microsoft Dynamics NAV 2009

Most Microsoft product teams involve their top customers and partners the development process via Technology Adoption Programs (TAP).  These high touch engagements result in much better product quality and features as well as early (pre-RTM) deployments of new versions.  The Dynamics NAV 2009 TAP has succeeded with 10 live customers in Germany, Denmark, Canada and… Read more

Bio – Brett Johnson

Brett Johnson is the NAV Technology Adoption Manager for North America and Asia Pacific. Brett has been with Microsoft for about 8 years working with .NET technologies and our largest Enterprise Customers and Partners.  He is very pleased to have joined the Dynamics world in 2007 to lead the creation of the first ever Technology… Read more

Dynamics NAV 5.0 SP1 and export to Excel

A number of issues previously reported when running with Dynamics NAV 5.0 and using send-to Excel functionality, are now corrected.  These issues include (among others): decimals exported as text, Item/Customer numbers exported as decimals, dates exported as decimals. To implement correction, update with 5.0 SP1, update 1 (KB 956161, build 27191), use default style sheets included in SP1, and make the following change to… Read more

Basic SQL – Restoring a SQL Server backup

This post is part of “Overview of NAV-specific SQL features for application consultants“. You can back up your Microsoft Dynamics NAV database either from a NAV client or from SQL Server Management Studio. To restore a backup made from SQL Server, follow these steps: 1)     Open SQL Server Management Studio 2)    You don’t need to… Read more

Basic SQL – Creating users in NAV on SQL

This post is part of “Overview of NAV-specific SQL features for application consultants“. Before you can set up a user in Microsoft Dynamics NAV on SQL Server, you must create the user on SQL Server first. If you try to create a user which does not exist on SQL Server, you will get this error… Read more