Welcome to MSDN Blogs Sign in | Join | Help

November 2008 - Posts

Friday, November 21, 2008 5:39 PM

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
Posted by navblog | 4 Comments
Filed under: , ,
Wednesday, November 19, 2008 12:44 PM

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
Posted by navblog | 0 Comments
Filed under: , ,
Sunday, November 16, 2008 12:46 PM

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
Posted by navblog | 0 Comments
Sunday, November 16, 2008 12:42 PM

NAV 2009 - The structure of reports in VS report designer

One thing is to make a report look pretty. But before you can do that, you have to make it work first. This post is about how to get the data structure right when designing reports in VS report designer for the new client in NAV 2009. If you are completely
Posted by navblog | 0 Comments
Filed under: , ,
Saturday, November 15, 2008 12:40 PM

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
Posted by navblog | 0 Comments
Filed under: , ,
Thursday, November 13, 2008 8:41 AM

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
Posted by navblog | 1 Comments
Filed under: ,
Tuesday, November 11, 2008 12:38 PM

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
Posted by navblog | 0 Comments
Saturday, November 08, 2008 12:38 PM

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
Posted by navblog | 0 Comments
Filed under: ,
Saturday, November 08, 2008 12:36 PM

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
Posted by navblog | 0 Comments
Filed under: ,
Saturday, November 08, 2008 12:33 PM

Basic SQL - How to attach a database to SQL Server

This post is part of " Overview of NAV-specific SQL features for application consultants ". If you receive a SQL Server database file (.MDF), then you must attach this to your SQL Server before you can access it. This is how to do that: 1) Copy the Database
Posted by navblog | 0 Comments
Filed under: ,
Saturday, November 08, 2008 8:48 AM

Building a Role Center in 1 hour

First I want to say thanks to people who attended Michael Rosenørn and My session, about building a Role Center in 1 hour, at Convergence 2008 last week in Denmark. Our evaluation score for this session was second highest out of all sessions at Convergence,
Posted by navblog | 0 Comments
Filed under: , ,
Friday, November 07, 2008 12:32 PM

Tip 3: Using Exchange Public Folders and Outlook synchronization in Dynamics NAV 5.0, 5.0 SP1 and 2009

Many people ask if it is possible to use Public Folders for data storage in regards to the redesigned Outlook Synchronization in releases after Dynamics NAV 4.0 taking into account that there are no conditions or filters set for the contacts entities.
Posted by navblog | 0 Comments
Filed under: , ,
Wednesday, November 05, 2008 12:28 PM

Basic SQL - How to create a new NAV database for restoring a NAV backup

This post is part of " Overview of NAV-specific SQL features for application consultants ". This post describes the steps needed to create a new NAV database from a NAV backup (.fbk) file. All the steps are done from a NAV client: 1) Start a NAV client
Posted by navblog | 0 Comments
Filed under: ,
Wednesday, November 05, 2008 12:26 PM

Basic SQL - Enable trace flag 4616 on SQL Server

This post is part of " Overview of NAV-specific SQL features for application consultants ". The newest versions of Microsoft Dynamics NAV require trace flag 4616 to be enabled on SQL Server. If not, then you will get this error message when you try to
Posted by navblog | 0 Comments
Filed under: , ,
Wednesday, November 05, 2008 12:24 PM

Basic SQL - Creating Extended Stored Procedure / xp_ndo.dll

This post is part of " Overview of NAV-specific SQL features for application consultants ". Microsoft Dynamics NAV requires two extended stored procedures from xp_ndo.dll to exist on SQL Server if Windows logins are used. If these extended stored procedures
Posted by navblog | 0 Comments
Filed under: , ,
Wednesday, November 05, 2008 12:23 PM

Basic SQL - Installing SQL Server 2005 / 2008

This post is part of " Overview of NAV-specific SQL features for application consultants ". It describes the simplest way to get SQL Server installed in a test environment. It only mentions the changes to the default installation options that you need
Posted by navblog | 0 Comments
Filed under: ,
Wednesday, November 05, 2008 12:20 PM

Basic SQL - Overview of NAV specific SQL features for application consultants

As the title says, this post is not really for NAV developers, but for application consultants who don't use SQL Server every day but still need to know enough about SQL Server to at least get a Microsoft Dynamics NAV database to run on it. The challenge
Posted by navblog | 0 Comments
Filed under: ,
Tuesday, November 04, 2008 12:11 PM

Tip 2: Fixing language issues when trying to setup the Outlook Synchronization in Dynamics NAV 5.0, Dynamics NAV 5.0 SP1 and Dynamics NAV 2009

If you are working in a localized release of Dynamics NAV with the redesigned Outlook Synchronization, I bet that you were dealing with a language issue. Perhaps you forgot to set the Regional Options for the NAS user account, perhaps you did not follow
Posted by navblog | 0 Comments
Filed under: , , ,
Tuesday, November 04, 2008 12:09 PM

Tip 1: The related item for the synchronized Outlook item is not found in the specified folders. The following values were expected

When working with the Outlook Synchronization using Dynamics NAV 5.0, Dynamics NAV 5.0 SP1 and Dynamics NAV 2009 (present release: CTP4) in an Exchange Server environment, the following very annoying error may show up in the Outlook Addin. The related
Posted by navblog | 0 Comments
Filed under: , , ,
 
Page view tracker