Recently I was working on a modification where I have to display an item related information in a form, the information is always changing so we need to get the new data every time they open the form. For this scenario I have created a new table and new form . We have set the form SourceTableTemporary property to yes , since we need to get the data and insert into the table every time they open the form. ItemInfoINIT;
ItemInfo."Item No." := ItemNo;
ItemInfo."Line No." := LineNo;
ItemInfo.Attribute := Attribute1;
ItemInfo.INSERT;I have added a new function to execute on the open form...
Wednesday, December 28, 2016
Tuesday, December 27, 2016
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-ftphttp://www.dynamics.is/?p=583Below...
Tuesday, October 25, 2016
Dynamics NAV 2017 New Release Date
During the Directions Microsoft mentioned it will release NAV 2017 on October 24th, but it missed the release date and the new release date for the product would be October 28th .As per the Partners Source it will Release the product on that date including the Partner Translation ToolKit and Language Modules.Please check PartnerSource for more information related to the product and What is New in the product...
Saturday, October 22, 2016
Microsoft Dynamics NAV Client has Stopped Working
Saturday, October 22, 2016
NAV 2013
,
NAV 2013 R2
,
NAV 2015
,
NAV 2016
,
Navision Error
25 comments
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 time1. Application ErrorThis has very little information about the error...
Friday, October 7, 2016
Cumulative Update 12 for Microsoft Dynamics NAV 2016 has been released (Build 47042)
Cumulative Update 12 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.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 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 43 for Microsoft Dynamics NAV 2013 has been released (Build 47058)
Cumulative Update 43 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013.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 36 for Microsoft Dynamics NAV 2013 R2 has been released (Build 47043)
Cumulative Update 36 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2.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...
Monday, July 11, 2016
Project Madeira Preview is now available in Canada
Till today Project Madeira was available for preview only in the United States market , but wait is over for Canada market and it is available for preview in Canada from today July 11th.https://madeira.microsoft.com/en-us/blog/madeira-preview-canad...
Friday, July 8, 2016
How to Get Project Madeira Activation Code
If you want to open a Project Madeira App on Windows or on IPhone it will ask you for an activation code The App Requires the Activation Code to run, in order to get the activation code run the Project Madeira from you web page and from the search page as show in the fig, type Activation CodeOpen the Page Get the Mobile Device Activate Code and App for Tables… Page which will look like below Copy the Activation Code and use that in your App and Follow the Login Steps and you should be able to access it on your Phone App.Please leave your comments,...
Wednesday, July 6, 2016
Cumulative Update 9 for Microsoft Dynamics NAV 2016 (Build 46290)
Cumulative Update 9 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.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 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 33 for Microsoft Dynamics NAV 2013 R2 (Build 46296)
Cumulative Update 33 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2.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...
Cumulative Update 40 for Microsoft Dynamics NAV 2013 (Build 46292)
Cumulative Update 40 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013.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...
New Updates for Microsoft Project "Madeira" is coming soon.
The new update will include new capabilities in the core application, and it also introduces marketplace support for extensions that was announced earlier today https://appsource.microsoft.com. The new update will not support yet to get extensions from the AppSource.For new capabilities check this page What's New page....
Thank You for all your kind wishes !
Hello Everyone, i want to reach all my supporters through this blog entry and say THANK YOU for all the wishes and support you gave me. In the last few days i have received several emails, tweets and comments from Dynamics NAV Community members, friends, and colleagues to wish me for my Microsoft MVP Award and Microsoft Community Contributor Award. It is really so amazing how supportive everyone was this really encourages and inspires me more to do for the community and spend more time blogging and helping the people with their queries.Please...
Microsoft Introduces Dynamics 365 and AppSource
Today, Microsoft introduced new modern and enterprise-ready intelligent business apps with the introduction of Microsoft Dynamics 365 and Microsoft AppSource.Please read more information about this and what it can bring from the below link https://blogs.microsoft.com/blog/2016/07/06/turning-business-process-into-business-advantage-for-organizations-everywhere/#sm.0001q621yt77vdvnso02m7aqwfa...
Friday, July 1, 2016
My First Microsoft MVP Award 2016
Today i have received the below email from Microsoft mentioning that i was awarded as Microsoft MVP. I am so honored and humble to receive this award and grateful to all my blog readers and supporters who helped me to achieve this. I really want to thank all the members of my ArcherPoint Team and the management team who always encourages to help the community, We @ArcherPoint believe that sharing the knowledge and helping the community will help us to grow.For anyone who doesn’t know what is Microsoft MVP Award please check this link.Without...
Wednesday, June 29, 2016
Print blank when the value is zero in RTC Reports
Sometimes when we are printing decimals/integer fields in the RTC report we don’t want to display zero if the value of the expression is zero, but rather display it as blank, most of the standard Navision Reports has this logic built in.For example check this below order confirmation report, the second line unit price is set to zero on the order and it did not print zero but rather printed as blankHow did they do this ?On the RTC Report they created a new function called BlankZero and the function looks like thisPublic Function BlankZero(ByVal...
How to Enable/Disable Inventory Warning Message
Most of us must have seen the below message box when entering quantity for an item on the sales order, the system shows this Check Availability box if the item does not have enough quantity entered on the order, it is good information but sometimes it is annoying, so how can we disable this You can disable this per item or for all items by using the following two ways1. You can disable this per item by setting the field “Stockout Warning” on the Item card to No2. You can disable this for all items using the field “Stockout Warning” on the Sales...
Tuesday, June 28, 2016
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...
Thursday, June 16, 2016
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 CU12https://blogs.msdn.microsoft.com/nav/2015/10/12/cumulative-update-12-for-microsoft-dynamics-nav-2015-has-been-released/NAV 2013 is compatible with CU32https://blogs.msdn.microsoft.com/nav/2015/11/04/cumulative-update-32-for-microsoft-dynamics-nav-2013-has-been-released/NAV...
Saturday, June 4, 2016
Cumulative Update 39 for Microsoft Dynamics NAV 2013 (Build 46056)
Cumulative Update 39 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013.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 38 for Microsoft Dynamics NAV 2013 (Build 45787)
Cumulative Update 38 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013.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 32 for Microsoft Dynamics NAV 2013 R2 (Build 46057)
Cumulative Update 32 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2.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...
Cumulative Update 31 for Microsoft Dynamics NAV 2013 R2 (Build 45822)
Cumulative Update 31 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2.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...
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 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 8 for Microsoft Dynamics NAV 2016 (Build 46045)
Cumulative Update 8 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.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 7 for Microsoft Dynamics NAV 2016 (Build 45834)
Cumulative Update 7 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.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...
Sunday, May 1, 2016
Dynamics NAV Cumulative Update Download Links
Microsoft releases cumulative update every month for NAV 2013, NAV 2013 R2, NAV 2015 and NAV 2016. I always have to find the links for the downloads when I want to update, below are the quick links to find the cumulative updates for these releases and to download them. You need to have partner or customer source login to download them.FOR NAV 2013Released Cumulative Updates for Microsoft Dynamics NAV 2013FOR NAV 2013 R2Released Cumulative Updates for Microsoft Dynamics NAV 2013 R2FOR NAV 2015Released Cumulative Updates for Microsoft Dynamics NAV...
Tuesday, April 26, 2016
Ctrl + Alt + F1 Shortcut Key is not working in RTC to Zoom
As I explained in my last post , the shortcut key (Ctrl + Alt + F1) is used in RTC for About this Page function, which will allow us to view all fields of a record. This Shortcut Key is very important to view the fields on the subpage as it does not have the Menu option to see Help –> About this Page.On some computers, this shortcut key does not work and it even happened on my laptop, the reason is because of the conflict of having the same shortcut key on another application. These days most of the computers come with an application...
Sunday, April 24, 2016
How to view all fields of a record (Zoom on Record)
In the older version i.e. in classic client version of NAV, to view all the fields for the a record you use the function zoom (Ctrl + F8) which will allow us to see all the fields of the record, it is very useful function to see other field values which are not on the form and it is easy to find a particular field by selecting the first letter of the field. For example in below fig. 1 by using zoom i can see all the field values of the selected customer record.Fig 1 : Customer Card FormYou can use the same function even on the subform, for...
Monday, April 11, 2016
Cumulative Update 6 for Microsoft Dynamics NAV 2016 (Build 45480)
Cumulative Update 6 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.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 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...