November 2008 - NAV Developers Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • 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 on a report. So, for when you manually want to control what to print. The tricky part is really to get the structure of the report right. Once this is done, adding additional information...
    Filed under: ,

  • NAV 2009 is released!

    NAV 2009 is released and available from this link on PartnerSource (login required): Microsoft Dynamics NAV 2009 - Download page Also visit the Launch Portal for Microsoft Dynamics NAV 2009 for Demo tools, readiness, sales and marketing materials, and much more. Lars Lohndorf-Larsen Microsoft Dynamics UK Microsoft Customer Service and Support (CSS) EMEA
    Filed under:

  • 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 new to the new environment, then take a look at this post first: NAV 2009 - Report Designer - Introduction to the new environment This post also assumes that you are already familiar with designing reports in the classic report designer. Start...

  • 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 has changed. You can still use the existing report designer. VS report designer offers a lot of new options and features. The idea of this post is to describe what features out of 100s that you actually need...
    Filed under: ,

  • 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 default style sheet NavisionExportToExcel.xslt: O pen the style sheet file in...
    Filed under: ,

  • 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 create a database first, like you do from NAV. Just right click on Databases, then select “Restore Database...”. 3) In the box that opens, type in a name for your...
    Filed under:

  • 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 message: === The Microsoft Dynamics NAV Classic and SQL Server security systems have not been successfully synchronized. The SQL Server login MYUSER does not exist on the LARS-PC server. === To create...
    Filed under:

  • 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 file (.MDF), for example “Demo Database NAV (6-0)_Data.MDF” into the folder where SQL Server keeps the database files. On SQL Server 2008 this defaults to “C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA”: 2) Open...
    Filed under:

  • 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. The answer is simple: yes, you can! There is one big pitfall. In scenarios where there are thousands of contacts to be synchronized, Exchange Server tend to think that this is not OK. There are some KB published on that topic: http://support.microsoft...

  • 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 (finsql.exe), then go to File -> Database -> New. In Server Name, enter (local) - assuming you have SQL Server on the same machine. Then click OK. 2) You only have to enter a database name, and click OK. But if the database is used...
    Filed under:

  • 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 connect: === The trace flag 4616 is not set on the server (local). You must set this flag and restart the server before you can connect using Microsoft Dynamics NAV. === How to set trace flag 4616: Start SQL Server Configuration Manager: Start...

  • 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 do not exist, you will get this error when trying to log on using Windows Authentication: --- The extended stored procedure xp_ndo_enumusersids in the library file xp_ndo.dll, is not available on the LOHNDORF1 server. Until this procedure...
    Filed under:

  • 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 to make to get SQL Server running for NAV. Needless to say that for installing SQL Server in a live environment, there are further considerations to make like security, performance, etc, which are not described here. Which edition: If you...
    Filed under:

  • 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 is, that even a basic SQL course or book will cover material which is 85% unrelated to NAV, and cover SQL features which you may never use when you only need to run NAV on a SQL server in a test environment. So the point of this post is to explain...
    Filed under:

  • 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 item for the synchronized Outlook item is not found in the specified folders. The following values were expected: /o=CRONUS/ ou=First Administrative Group/cn=Recipients/cn=marcomels The Installation and Setup guide that was compiled for the Partnersource...
1 2 Next >