Connection Error while launching debugger in NAV

Recently I was working on a project where we have switched the authentication from Windows to NAVUserPassword.

To access different databases and instances we have created different config files and have used them in our shortcut to launch them, everything was working fine but when I try to debug an issue, I was getting the following error, which complains about the DnsIdentity

The key is when  you launch the debugger it uses the config file (ClientUserSettings.config.) located at C:\Users\YourUserName\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\70 and depending on the version you are on it would be 80 or 90 folder. It does not use your custom config files you have created to launch the application.

So, you need to make sure this file is also updated with proper authentication using the ClientServicesCredential which should be NAVUserPassword if you are using UserName/Password. In my case everything was set properly except the DnsIdentity Property value which is blank.

Once I updated the DnsIdentity Value with proper subject name which is the CN name , the debugger started without any issues.

For more information about DnsIdentity and Certificates please check the following link

https://docs.microsoft.com/en-us/dynamics-nav/how-to--configure-authentication-of-microsoft-dynamics-nav-web-client-users

Share:

Read more..

January 2018 Cumulative Updates for NAV 2013, 2013 R2, 2015, 2016 and 2017

Here are links to the release notes and download link for the CU's released.

NAV 2013 – Cumulative Update 58

You can download the cumulative update from KB4058596

NAV 2013 R2 – Cumulative Update 51

You can download the cumulative update from KB4058597

NAV 2015 – Cumulative Update 39

You can download the cumulative update from KB4058598

NAV 2016 – Cumulative Update 27

You can download the cumulative update from KB4058599

NAV 2017 – Cumulative Update 14

You can download the cumulative update from KB4058600

Share:

Read more..

How to print a remote file from NAV

I have seen couple of times the requirement where we need to print a document from NAV which is not a report, it could be a marketing campaign letter, sales sheets or any other document.

Most of the time we upload these kind of documents on a website/remote site, so if we need print those documents with every invoice or any other statement, below is the function you can use from NAV.

In the below example I just took a random PDF URL from the web and used it for testing.

The key in this function is to download the document from the web using WebClient locally and then use the Process to print the document to the printer.

LOCAL PROCEDURE PrintRemoteFile@1240060002();
     VAR
       FileURL@1240060000 : Text;
       ProcessStartInfo@1240060001 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Diagnostics.ProcessStartInfo";
       Process@1240060002 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Diagnostics.Process";
       WebClient@1240060003 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.WebClient";
       LocalFileName@1240060004 : Text;
     BEGIN
       FileURL := 'http://che.org.il/wp-content/uploads/2016/12/pdf-sample.pdf';
       ProcessStartInfo := ProcessStartInfo.ProcessStartInfo();
       WebClient := WebClient.WebClient();
       LocalFileName := 'C:\Temp\TempFile.pdf';
       WebClient.DownloadFile(FileURL,LocalFileName);
       ProcessStartInfo.FileName := LocalFileName;
       ProcessStartInfo.Verb := 'Print';
       ProcessStartInfo.CreateNoWindow := FALSE;
       Process := Process.Process;
       Process := Process.Start(ProcessStartInfo);
       MESSAGE('Document Printed');
     END;

If you have any other tips or suggestions to resolve this error, please do share them in the comments below.

Share:

Read more..

Cumulative Update 28 for Microsoft Dynamics NAV 2015 (Build 47871)

Cumulative Update 28 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see http://support.microsoft.com/contactus/.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

• AT – Austria
• AU – Australia
• BE – Belgium
• CH – Switzerland
• CZ – Czech Republic
• DE – Germany
• DK – Denmark
• ES – Spain
• FI – Finland
• FR – France
• IS – Iceland
• IT – Italy
• NA – North America
• NL – Netherlands
• NO – Norway
• NZ – New Zealand
• RU – Russia
• SE – Sweden
• UK – United Kingdom
• W1 – International

Note: You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than Cumulative Update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

Where to find Cumulative Update 28

You can download the cumulative update from KB 4011764  – Cumulative Update 28 for Microsoft Dynamics NAV 2015 (Build 47871).

Or you can download the cumulative update from the Microsoft Download Center.

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.
3. Note: We are currently transitioning to a new Knowledge Base system to provide you a better experience. During the transition period, access to Knowledge Base articles from within CustomerSource and PartnerSource will be unavailable. During this transition period, Knowledge Base articles can be found by utilizing the search functionality located on the Microsoft Support Website.

Additional Information

For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2015 Cumulative Update.

For information about how to work around a recent process change, see How to Get Back the ‘Hotfix Directories’ from NAV 2015 Cumulative Update 1.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2015.

Share:

Read more..

Cumulative Update 27 for Microsoft Dynamics NAV 2015 (Build 47665)

Cumulative Update 27 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see http://support.microsoft.com/contactus/.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

•   AU – Australia
•   AT – Austria
•   BE – Belgium
•   CH – Switzerland
•   CZ – Czech Republic
•   DE – Germany
•   DK – Denmark
•   ES – Spain
•   FI  – Finland
•   FR – France
•   IS – Iceland
•   IT – Italy
•   NA – North America
•   NL – Netherlands
•   NO – Norway
•   NZ – New Zealand
•   RU – Russia
•   SE – Sweden
•   UK – United Kingdom

Note: You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than Cumulative Update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

Where to find Cumulative Update 27

You can download the cumulative update from KB 3216192  – Cumulative Update 27 for Microsoft Dynamics NAV 2015 (Build 47665).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2015 Cumulative Update.

For information about how to work around a recent process change, see How to Get Back the ‘Hotfix Directories’ from NAV 2015 Cumulative Update 1.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2015.

Share:

Read more..

How to upload files to FTP server using .NET Interop

In my previous posts i have explained how to download the files from the FTP Server or  move the files from one folder to another on the FTP server. Here are the posts if you have missed them

How to download files from FTP server using .NET Interop

How to move files from one folder to another on FTP server.

In this post i will show you the code i have used to upload the files to the FTP server.   The FTPSetup is a Setup table which I have used to store the path, ftp server, user, and password information.

In the first function (UploadFilesToFTP) I have used an Array to store the paths of all the files from the upload directory, then I iterate through the array and execute second function to upload the file. In the second function it uses FTP Web Request method ‘STOR’ to upload the file to the server.

LOCAL PROCEDURE UploadFilesToFTP@1240060030();
     VAR
       FTPWebRequest@1240060000 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.FtpWebRequest";
       FTPWebResponse@1240060001 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.FtpWebResponse";
       NetworkCredential@1240060002 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.NetworkCredential";
       WebRequestMethods@1240060003 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.WebRequestMethods+File";
       UTF8Encoding@1240060004 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Text.UTF8Encoding";
       ResponseStream@1240060005 : InStream;
       FileStream@1240060006 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.FileStream";
       TempBlob@1240060008 : TEMPORARY Record 99008535;
       FileName@1240060007 : Text;
       OutStream@1240060009 : OutStream;
       SearchOption@1240060013 : DotNet "'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.SearchOption" RUNONCLIENT;
       ArrayHelper@1240060012 : DotNet "'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Array" RUNONCLIENT;
       ArrayLength@1240060011 : Integer;
       DirectoryHelper@1240060014 : DotNet "'mscorlib'.System.IO.Directory" RUNONCLIENT;
       i@1240060015 : Integer;
       RelativeServerPath@1240060016 : Text;
       ClientFilePath@1240060017 : DotNet "'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.String" RUNONCLIENT;
       PathHelper@1240060010 : DotNet "'mscorlib'.System.IO.Path";
     BEGIN
       GetFTPSetup;
       ArrayHelper := DirectoryHelper.GetFiles(FTPSetup."FTP Local Upload FilePath",'*.txt',SearchOption.TopDirectoryOnly);

      ArrayLength := ArrayHelper.GetLength(0);

      IF ArrayLength = 0 THEN
         EXIT;

      FOR i := 1 TO ArrayLength DO BEGIN
         RelativeServerPath := FORMAT(ArrayHelper.GetValue(i - 1));
          UploadFileToFTP(RelativeServerPath);
       END;
     END;

    LOCAL PROCEDURE UploadFileToFTP@1240060031(FileToUpload@1240060018 : Text);
     VAR
       FTPWebRequest@1240060000 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.FtpWebRequest";
       FTPWebResponse@1240060001 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.FtpWebResponse";
       NetworkCredential@1240060002 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.NetworkCredential";
       WebRequestMethods@1240060003 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.WebRequestMethods+File";
       UTF8Encoding@1240060004 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Text.UTF8Encoding";
       ResponseStream@1240060005 : InStream;
       FileStream@1240060006 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.FileStream";
      Stream@1240060020 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.Stream";
       FileDotNet@1240060019 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.File";
       TempBlob@1240060008 : TEMPORARY Record 99008535;
       FileName@1240060007 : Text;
       OutStream@1240060009 : OutStream;
       SearchOption@1240060013 : DotNet "'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.SearchOption" RUNONCLIENT;
        i@1240060015 : Integer;
       RelativeServerPath@1240060016 : Text;
       ClientFilePath@1240060017 : DotNet "'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.String" RUNONCLIENT;
       PathHelper@1240060010 : DotNet "'mscorlib'.System.IO.Path";
     BEGIN
       GetFTPSetup;
       FTPWebRequest := FTPWebRequest.Create(FTPSetup."FTP Local Upload FilePath" + PathHelper.GetFileName(FileToUpload));
       FTPWebRequest.Credentials := NetworkCredential.NetworkCredential(FTPSetup."FTP UserName",FTPSetup."FTP Password");
       FTPWebRequest.UseBinary := TRUE;
       FTPWebRequest.UsePassive := TRUE;
       FTPWebRequest.KeepAlive := TRUE;
       FTPWebRequest.Method := 'STOR';

      FileStream := FileDotNet.OpenRead(FileToUpload);
       Stream := FTPWebRequest.GetRequestStream();
       FileStream.CopyTo(Stream);
       Stream.Close;

      FTPWebResponse := FTPWebRequest.GetResponse();
       FTPWebResponse.Close();
     END;

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.

Share:

Read more..

How to move a file from one folder to another on FTP Server

To move a file from one folder to another we normally using System.IO.File functions Move or Copy but in this scenario these functions will not work on FTP server. To achieve this on FTP we need to use FTP web request methods and below is the code i have used for that.

For your reference please check my previous post for downloading files from the FTP Server How to download files from FTP server.

The function is very simple. The tricky part over here is what method to use on FTP WebRequest to move the file, the method we have to use is ‘RENAME’ and using RenameTo  property to specify the file path.

[TryFunction]
LOCAL PROCEDURE MoveFileFromConcurFTPToArchive@1240060038(FileToDownload@1240060010 : Text);
VAR
  FTPWebRequest@1240060000 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.FtpWebRequest";
  FTPWebResponse@1240060001 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.FtpWebResponse";
  NetworkCredential@1240060002 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.NetworkCredential";
  WebRequestMethods@1240060003 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.WebRequestMethods+File";
  ResponseStream@1240060005 : InStream;
  FileStream@1240060006 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.FileStream";
  FileName@1240060007 : Text;
BEGIN
  GetFTPSetup;
  FTPWebRequest := FTPWebRequest.Create(FTPSetup."FTP Download FilePath" + FileToDownload);
  FTPWebRequest.Credentials := NetworkCredential.NetworkCredential(FTPSetup."FTP UserName",FTPSetup."FTP Password");
  FTPWebRequest.UseBinary := TRUE;
  FTPWebRequest.UsePassive := TRUE;
  FTPWebRequest.KeepAlive := TRUE;
  FTPWebRequest.Method := 'RENAME';
  FTPWebRequest.RenameTo := 'archive/' + FileToDownload;
  FTPWebResponse := FTPWebRequest.GetResponse();
END;

I hope this will save time for others who are looking for a solution.

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.

Share:

Read more..

How to download FTP files using .NET Interop

Recently i have worked on a project where the requirement was to upload and download the files from a FTP.  In this blog i will be explaining how to download the files using .NET Interop. There are several other blogs which have explained, how to download the files using ScriptingHost or .net interop but i have not found an example to download all the files from a particular folder.

These are couple of blogs i found, related to this.

http://www.archerpoint.com/blog/Posts/automating-command-line-functions-nav-rtc-transmit-ftp

http://www.dynamics.is/?p=583

Below is the code that downloads all the files from a particular FTP Folder to your local download folder. The GetFTPSetup is just another function to retrieve the setup values.

I have used two functions to download the files, the first function DownloadFilesFromFTP will find all the files and add to the list, then we will loop through the list to download the file using the second function.

PROCEDURE DownloadFilesFromFTP@1240060028();
     VAR
       FTPWebRequest@1240060000 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.FtpWebRequest";
       FTPWebResponse@1240060001 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.FtpWebResponse";
       NetworkCredential@1240060002 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.NetworkCredential";
       WebRequestMethods@1240060003 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.WebRequestMethods+File";
       UTF8Encoding@1240060004 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Text.UTF8Encoding";
       ResponseStream@1240060005 : InStream;
       FileStream@1240060006 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.FileStream";
       TempBlob@1240060008 : TEMPORARY Record 99008535;
       FileName@1240060007 : Text;
       OutStream@1240060009 : OutStream;
       StreamReader@1240060010 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.StreamReader";
       List@1240060012 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Collections.Generic.List`1";
       i@1240060011 : Integer;
       PathHelper@1240060013 : DotNet "'mscorlib'.System.IO.Path";
       FileAttributes@1240060014 : DotNet "'mscorlib'.System.IO.FileAttributes";
       DotNetFile@1240060015 : DotNet "'mscorlib'.System.IO.File";
     BEGIN
       GetFTPSetup;
       FTPWebRequest := FTPWebRequest.Create(FTPSetup."FTP Download FilePath");
       FTPWebRequest.Credentials := NetworkCredential.NetworkCredential(FTPSetup."FTP UserName",FTPSetup."FTP Password");
       FTPWebRequest.UseBinary := TRUE;
       FTPWebRequest.UsePassive := TRUE;
       FTPWebRequest.KeepAlive := TRUE;
       FTPWebRequest.Method := 'NLST';
       FTPWebResponse := FTPWebRequest.GetResponse();
       StreamReader := StreamReader.StreamReader(FTPWebResponse.GetResponseStream());
       List := List.List();
       FileName := StreamReader.ReadLine();
       WHILE FileName <> '' DO BEGIN
         List.Add(FileName);
         FileName := StreamReader.ReadLine();
       END;
       FOR i:=1 TO List.Count DO BEGIN

        IF FORMAT(List.Item(i-1)) <> 'archive' THEN BEGIN
           DownloadFileFromFTP(FORMAT(List.Item(i-1)));
         END;
         
       END;
     END;

    [TryFunction]
     LOCAL PROCEDURE DownloadFileFromFTP@1240060029(FileToDownload@1240060010 : Text);
     VAR
       FTPWebRequest@1240060000 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.FtpWebRequest";
       FTPWebResponse@1240060001 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.FtpWebResponse";
       NetworkCredential@1240060002 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.NetworkCredential";
       WebRequestMethods@1240060003 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.WebRequestMethods+File";
       UTF8Encoding@1240060004 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Text.UTF8Encoding";
       ResponseStream@1240060005 : InStream;
       FileStream@1240060006 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.IO.FileStream";
       TempBlob@1240060008 : TEMPORARY Record 99008535;
       FileName@1240060007 : Text;
       OutStream@1240060009 : OutStream;
     BEGIN
       GetFTPSetup;
       FTPWebRequest := FTPWebRequest.Create(FTPSetup."FTP Download FilePath" + FileToDownload);
       FTPWebRequest.Credentials := NetworkCredential.NetworkCredential(FTPSetup."FTP UserName",FTPSetup."FTP Password");
       FTPWebRequest.UseBinary := TRUE;
       FTPWebRequest.UsePassive := TRUE;
       FTPWebRequest.KeepAlive := TRUE;
       FTPWebRequest.Method := 'RETR';
       FTPWebResponse := FTPWebRequest.GetResponse();
       ResponseStream := FTPWebResponse.GetResponseStream();
       TempBlob.Blob.CREATEOUTSTREAM(OutStream);
       COPYSTREAM(OutStream,ResponseStream);
       FileName := FTPSetup."FTP Local Download FilePath" + FileToDownload; // 'download' + FORMAT(CURRENTDATETIME,0,'<Year4><Month,2><Day,2><Hours24><Minutes,2><Seconds,2>') +'.txt';
       TempBlob.Blob.EXPORT(FileName);
     END;

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.

Share:

Read more..

Microsoft Dynamics NAV Client has Stopped Working

Last week i encountered an error with Microsoft Dynamics NAV RTC client, whenever i open the client it crashes and gives me the above error message it does not give me an option to reconnect or choose a different service, it just crashes. The error/problem details on that page does not give any information about the error.

Below is the error details i can view from that window.

so first thing i did is to check the event viewer and there are two errors reported at that time

1.  Application Error

This has very little information about the error and which is not helpful to debug the issue, the details of the error are something like in the below screenshot

2. .NET Runtime

This error has following details

If you notice the error is related to SQL Database Sync. Below are the steps i have performed to resolve the error.

1. RESTART NAV SERVICES -  THIS DID NOT FIX THE ISSUE

2. DELETE THE PERSONALIZATION STORE XML – THIS DID NOT FIX THE ISSUE

3. FROM DEVELOPMENT ENVIRONMENT – I RAN Sync. Schema For All Tables

This did the trick and resolved my issue.

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.

Share:

Read more..

Cumulative Update 24 for Microsoft Dynamics NAV 2015 has been released (Build 47039)

Cumulative Update 24 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see http://support.microsoft.com/contactus/.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

•   AU – Australia
•   AT – Austria
•   BE – Belgium
•   CH – Switzerland
•   CZ – Czech Republic
•   DE – Germany
•   DK – Denmark
•   ES – Spain
•   FI  – Finland
•   FR – France
•   IS – Iceland
•   IT – Italy
•   NA – North America
•   NL – Netherlands
•   NO – Norway
•   NZ – New Zealand
•   RU – Russia
•   SE – Sweden
•   UK – United Kingdom

Note: You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than Cumulative Update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

Where to find Cumulative Update 24

You can download the cumulative update from KB 3193867  – Cumulative Update 24 for Microsoft Dynamics NAV 2015 (Build 47039).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2015 Cumulative Update.

For information about how to work around a recent process change, see How to Get Back the ‘Hotfix Directories’ from NAV 2015 Cumulative Update 1.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2015.

Share:

Read more..

Cumulative Update 21 for Microsoft Dynamics NAV 2015 (Build 46293)

Cumulative Update 21 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see http://support.microsoft.com/contactus/.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

1.   AU – Australia
2.   AT – Austria
3.   BE – Belgium
4.   CH – Switzerland
5.   CZ – Czech Republic
6.   DE – Germany
7.   DK – Denmark
8.   ES – Spain
9.   FI  – Finland
10.   FR – France
11.   IS – Iceland
12.   IT – Italy
13.   NA – North America
14.   NL – Netherlands
15.   NO – Norway
16.   NZ – New Zealand
17.   RU – Russia
18.   SE – Sweden
19.   UK – United Kingdom

Note: You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than Cumulative Update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

Where to find Cumulative Update 21

You can download the cumulative update from KB 3172546 – Cumulative Update 21 for Microsoft Dynamics NAV 2015 (Build 46293).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2015 Cumulative Update.

For information about how to work around a recent process change, see How to Get Back the ‘Hotfix Directories’ from NAV 2015 Cumulative Update 1.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2015.

Share:

Read more..

Paste Rows option is missing on RTC Pages

One of the feature on the Navision RTC page is ability to copy rows and paste to excel and also copy rows from excel and paste into the page, mostly this option is heavily used on the worksheet pages i.e. Journal pages.

But recently i have noticed this option is missing  on most of the pages, that is due to a bug/ or change made by Microsoft in the recent Cumulative Updates. The reason why this option does not appear on the page is because of the property PasteIsValid  on the associated source table is set to NO. The default value of this property is yes  but for some tables in the recent builds it is set to No.

So in order to have the option Paste Rows you need to set the PasteIsValid property on the table to yes.

For example if the option is missing on the General Journal Page, then you need to set that property on the Gen. Journal Line (Table 81).

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.

Share:

Read more..

Dynamics NAV Compatibility on Windows 10

Windows 10 free upgrade will end on July 29, 2016 and most people may be still wondering if they upgrade, will NAV system be compatible with windows 10 or not. NAV Team officially announced the compatibility for the 2013, 2013 R2 , 2015 and 2016 for a specific version. Below are the details :

Dynamics NAV 2016 is compatible with Windows 10 on release.

NAV 2015 is compatible with CU12

https://blogs.msdn.microsoft.com/nav/2015/10/12/cumulative-update-12-for-microsoft-dynamics-nav-2015-has-been-released/

NAV 2013 is compatible with CU32

https://blogs.msdn.microsoft.com/nav/2015/11/04/cumulative-update-32-for-microsoft-dynamics-nav-2013-has-been-released/

NAV 2013 R2 is compatible with CU 24

https://blogs.msdn.microsoft.com/nav/2015/10/12/cumulative-update-24-for-microsoft-dynamics-nav-2013-r2-has-been-released/

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to po

Share:

Read more..

Cumulative Update 20 for Microsoft Dynamics 2015 (Build 46054)

Cumulative Update 20 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see http://support.microsoft.com/contactus/.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

•   AU – Australia
•   AT – Austria
•   BE – Belgium
•   CH – Switzerland
•   CZ – Czech Republic
•   DE – Germany
•   DK – Denmark
•   ES – Spain
•   FI  – Finland
•   FR – France
•   IS – Iceland
•   IT – Italy
•   NA – North America
•   NL – Netherlands
•   NO – Norway
•   NZ – New Zealand
•   RU – Russia
•   SE – Sweden
•   UK – United Kingdom

Note: You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than Cumulative Update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

Note: To enable customized translation of profiles, a number of actions are now available on the Profile List page. You can export and import resource files to enable translation for one or more profiles. The steps to install and uninstall language modules have also been modified. For more information, see How to: Install Language Modules, How to: Uninstall Language Modules, and How to: Export, Edit, and Import Translated Profile Strings in Help for Microsoft Dynamics NAV.

Where to find Cumulative Update 20

You can download the cumulative update from KB 3166286 – Cumulative Update 20 for Microsoft Dynamics NAV 2015 (Build 46054).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2015 Cumulative Update.

For information about how to work around a recent process change, see How to Get Back the ‘Hotfix Directories’ from NAV 2015 Cumulative Update 1.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2015.

Share:

Read more..

Cumulative Update 19 for Microsoft Dynamics NAV 2015 (Build 45813)

Cumulative Update 19 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see http://support.microsoft.com/contactus/.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

•   AU – Australia
•   AT – Austria
•   BE – Belgium
•   CH – Switzerland
•   CZ – Czech Republic
•   DE – Germany
•   DK – Denmark
•   ES – Spain
•   FI  – Finland
•   FR – France
•   IS – Iceland
•   IT – Italy
•   NA – North America
•   NL – Netherlands
•   NO – Norway
•   NZ – New Zealand
•   RU – Russia
•   SE – Sweden
•   UK – United Kingdom

Note: You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than Cumulative Update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

Note: To enable customized translation of profiles, a number of actions are now available on the Profile List page. You can export and import resource files to enable translation for one or more profiles. The steps to install and uninstall language modules have also been modified. For more information, see How to: Install Language Modules, How to: Uninstall Language Modules, and How to: Export, Edit, and Import Translated Profile Strings in Help for Microsoft Dynamics NAV.

Where to find Cumulative Update 19

You can download the cumulative update from KB 3157490 – Cumulative Update 19 for Microsoft Dynamics NAV 2015 (Build 45813).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2015 Cumulative Update.

For information about how to work around a recent process change, see How to Get Back the ‘Hotfix Directories’ from NAV 2015 Cumulative Update 1.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2015.

Share:

Read more..

Cumulative Update 18 for Microsoft Dynamics NAV 2015 (Build 45483)

Cumulative Update 18 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015.

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see http://support.microsoft.com/contactus/.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

•   AU – Australia
•   AT – Austria
•   BE – Belgium
•   CH – Switzerland
•   CZ – Czech Republic
•   DE – Germany
•   DK – Denmark
•   ES – Spain
•   FI  – Finland
•   FR – France
•   IS – Iceland
•   IT – Italy
•   NA – North America
•   NL – Netherlands
•   NO – Norway
•   NZ – New Zealand
•   RU – Russia
•   SE – Sweden
•   UK – United Kingdom

Note: You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than Cumulative Update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

Note: To enable customized translation of profiles, a number of actions are now available on the Profile List page. You can export and import resource files to enable translation for one or more profiles. The steps to install and uninstall language modules have also been modified. For more information, see How to: Install Language Modules, How to: Uninstall Language Modules, and How to: Export, Edit, and Import Translated Profile Strings in Help for Microsoft Dynamics NAV.

Where to find Cumulative Update 18

You can download the cumulative update from KB 3151020 – Cumulative Update 18 for Microsoft Dynamics NAV 2015 (Build 45483).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.
3. 
   

Additional Information

For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2015 Cumulative Update.

For information about how to work around a recent process change, see How to Get Back the ‘Hotfix Directories’ from NAV 2015 Cumulative Update 1.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2015.

Share:

Read more..

Cumulative Update 16 for Microsoft Dynamics NAV 2015 (Build 44973)

This Cumulative Update 16 includes hotfixes and regulatory features released for Microsoft Dynamics NAV 2015, including hotfixes and regulatory features released in previous Cumulative Updates.

Note: You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than cumulative update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

• AU - Australia
• AT - Austria
• BE - Belgium
• CH - Switzerland
• DE - Germany
• DK - Denmark
• ES - Spain
• FI - Finland
• FR - France
• IS - Iceland
• IT - Italy
• NA - North America
• NL - Netherlands
• NO - Norway
• NZ - New Zealand
• SE - Sweden
• UK - United Kingdom

Where to download this cumulative update

You can download the cumulative update from  KB 3138205– Cumulative Update 16 for Microsoft Dynamics NAV 2015

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.

How to install a Microsoft Dynamics NAV 2015 cumulative update

See How to install a Microsoft Dynamics NAV 2015 Cumulative Update .

Share:

Read more..

Cumulative Update 15 for Microsoft Dynamics NAV 2015 (Build 44363)

This Cumulative Update 15 includes hotfixes and regulatory features released for Microsoft Dynamics NAV 2015, including hotfixes and regulatory features released in previous Cumulative Updates.

Note: You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than cumulative update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

• AU - Australia
• AT - Austria
• BE - Belgium
• CH - Switzerland
• DE - Germany
• DK - Denmark
• ES - Spain
• FI - Finland
• FR - France
• IS - Iceland
• IT - Italy
• NA - North America
• NL - Netherlands
• NO - Norway
• NZ - New Zealand
• SE - Sweden
• UK - United Kingdom

Where to download this cumulative update

You can download the cumulative update from   KB 3130292 – Cumulative Update 15 for Microsoft Dynamics NAV 2015

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.

How to install a Microsoft Dynamics NAV 2015 cumulative update

See How to install a Microsoft Dynamics NAV 2015 Cumulative Update .

Share:

Read more..

Cumulative Update 14 for Microsoft Dynamics NAV 2015 has been released(Build 43887)

This Cumulative Update 12 includes hotfixes and regulatory features released for Microsoft Dynamics NAV 2015, including hotfixes and regulatory features released in previous Cumulative Updates.

Note: You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than cumulative update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

• AU - Australia
• AT - Austria
• BE - Belgium
• CH - Switzerland
• DE - Germany
• DK - Denmark
• ES - Spain
• FI - Finland
• FR - France
• IS - Iceland
• IT - Italy
• NA - North America
• NL - Netherlands
• NO - Norway
• NZ - New Zealand
• SE - Sweden
• UK - United Kingdom

Where to download this cumulative update

You can download the cumulative update from   KB 3121037 – Cumulative Update 14 for Microsoft Dynamics NAV 2015

Warning

Before you install a cumulative update in a production environment, take the following precautions:

1. Test the cumulative update in a non-production environment.
2. Make a backup of the system or computer where the cumulative update is to be installed.

How to install a Microsoft Dynamics NAV 2015 cumulative update

See How to install a Microsoft Dynamics NAV 2015 Cumulative Update .

Share:

Read more..

How to modify the Sales Invoice Report to print Serial No./Lot No.

There are several requests on the Microsoft Dynamics Community forum to get an example or for the logic to print the serial no. or lot no. on the sales invoice report. In this post I will explain how to modify the standard sales invoice report (Report 10074: NAV 2015) to print the serial no. or lot no. on the report.

For this purpose I have added a new function in the report 10074, called GetSerialLotNo

LOCAL PROCEDURE GetSerialLotNo@1240060002();
    VAR
      ItemTrackingMgt@1240060000 : Codeunit 6500;
      TempItemLedgEntry@1240060001 : TEMPORARY Record 32;
      InvoiceRowID@1240060002 : Text[150];
      LineNo@1240060003 : Integer;
      Inserted@1240060004 : Boolean;
      SerialLot@1240060005 : Code[60];
      ValueEntryRelation@1240060006 : Record 6508;
      ValueEntry@1240060007 : Record 5802;
      ItemLedgEntry@1240060008 : Record 32;
    BEGIN
      
      IF TempSalesInvoiceLine.Type <> TempSalesInvoiceLine.Type::Item THEN
        EXIT;
      TempItemLedgEntry.RESET;
      TempItemLedgEntry.DELETEALL;
      InvoiceRowID := TempSalesInvoiceLine.RowID1;
      ValueEntryRelation.RESET;
      ValueEntryRelation.SETCURRENTKEY("Source RowId");
      ValueEntryRelation.SETRANGE("Source RowId",InvoiceRowID);
      IF ValueEntryRelation.FIND('-') THEN BEGIN
        REPEAT
          ValueEntry.GET(ValueEntryRelation."Value Entry No.");
          ItemLedgEntry.GET(ValueEntry."Item Ledger Entry No.");
          TempItemLedgEntry := ItemLedgEntry;
          TempItemLedgEntry.Quantity := ValueEntry."Invoiced Quantity";
          IF TempItemLedgEntry."Entry Type" IN [TempItemLedgEntry."Entry Type"::Purchase,TempItemLedgEntry."Entry Type"::Sale] THEN
            IF TempItemLedgEntry.Quantity <> 0 THEN
              TempItemLedgEntry.INSERT;
        UNTIL ValueEntryRelation.NEXT = 0;
      END;
      IF TempItemLedgEntry.FINDFIRST THEN
        REPEAT
          SerialLot := TempItemLedgEntry."Serial No." + ' ' + TempItemLedgEntry."Lot No.";
          WITH TempSalesInvoiceLine DO BEGIN
            INIT;
            "Document No." := "Sales Invoice Header"."No.";
            "Line No." := HighestLineNo + 10;
            HighestLineNo := "Line No.";
          END;
          IF STRLEN(SerialLot) + 1 <= MAXSTRLEN(TempSalesInvoiceLine.Description) THEN BEGIN
            TempSalesInvoiceLine.Description := SerialLot;
            TempSalesInvoiceLine."Description 2" := '';
          END ELSE BEGIN
            SpacePointer := MAXSTRLEN(TempSalesInvoiceLine.Description) + 1;
            WHILE (SpacePointer > 1) AND (SerialLot[SpacePointer] <> ' ') DO
              SpacePointer := SpacePointer - 1;
            IF SpacePointer = 1 THEN
              SpacePointer := MAXSTRLEN(TempSalesInvoiceLine.Description) + 1;
            TempSalesInvoiceLine.Description := COPYSTR(SerialLot,1,SpacePointer - 1);
            TempSalesInvoiceLine."Description 2" :=
              COPYSTR(COPYSTR(SerialLot,SpacePointer + 1),1,MAXSTRLEN(TempSalesInvoiceLine."Description 2"));
          END;
          TempSalesInvoiceLine.INSERT;
        UNTIL TempItemLedgEntry.NEXT = 0;
      
    END;

The Serial No. and Lot No. information is stored in the item ledger entry table, so the above function is used to retrieve all the item ledger entries associated to a sales invoice line, and then store those into a temporary ledger entry table, by using the temporary ledger entry table we populate TempSalesInvoiceline table, which will take care of displaying the values on the report without modifying/formatting RTC report.

To print the serial no./ lot no. we just call the new function GetSerialLotNo on the OnAfterGetRecord of the Sales Invoice Line DataItem.

Below is an example of the invoice report printing serial no.
















Download the object from this link Sales Invoice Report

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.

Share:

Read more..