Saurav Dhyani - #MSDynNAV & #MSDyn365bc

Hi All, In this article we will discuss how to resolve an issue that you may find during Upgrade to Microsoft Dynamics NAV 2016 Upgrade Step 2. The Error does not allow you to start the Data Upgrade process and the Complete Error Message is - SessionId : 0 CodeunitId : 104050 FunctionName : CheckPreconditions CompanyName : <Companyname> StartTime : Duration : State : Failed Error : There is no Active Session within the filter. Filters: Server Instance ID: 1024, Session ID: 74

Hi All, It was always been a trouble to calculate Difference Between Two Date Time Variables. With Microsoft Dynamics NAV 2013 R2, Dotnet Variable are available which make life easy in so many situations. Today we will discuss one of the Dotnet Component for calculation Difference between days. This Solution can be implemented on Navision Version  2013 R2 and Later. The Demo Steps are on NAV 2016 W1 Database.

Hi All, This post will provide the Possibility for Export To Excel Feature in Microsoft Dynamics NAV 2016, with Custom Font, Custom Font Colour, and Custom Background Color. I have written this article on NAV 2013 R2, and as per my Blog User Request I am publishing the Same features in Microsoft Dynamics NAV 2016. So without wasting much of the time let's Start. At the End of the article the Objects will be available for Download (Dynamics NAV 2016 W1). If you have a custom database then you can use the text file for merging the changes.

Hi All, Its being a While I have posted something. Let's start with a Small Change that have been released with Microsoft Dynamics NAV 2016. When You are Developing a Report Having Custom Save As Excel Feature, You will find this small Change in Excel Buffer Function. After Entering Data in Excel Buffer Table Either Using Enter Cell Function or AddColumn Function of Excel Buffer Table, you will call a Function i.e CreateBookAndOpenExcel .

Hi All, In Last Two Series of Articles we have Discussed About Event & Subscriptions and Extensions. These Two will change the How we customize the Standard Navision Solution and How we use to Release the Standard Navision Solutions to Customers. I was thinking to Share My First Custom Solution as Event & Subscription, so Here it is one of the Most used tool to Report Usages. If you remember an Article From Mark Brummel For Save Report Usage. In this article We will discuss How we can customize the Change with Events & Subscriptions. How to Customize Solution In Previous Version of Navision Refer Mark Brummel Post Here .

Hi All, Recap - "We covered Most of the Things which we Should know about Extension in Microsoft Dynamics NAV 2016." If you are not following the Extension Series Then Refer the Table of Contents For Extensions. This is the Last Article In This Series, where we will discuss What is Supported and What is Not Supported with Extensions. Within Series It always Look Great, That Wow What a Great Feature and we started Thinking What all I can achieve with Extension. But This Article Will Might Get to Back to Reality, as Extension is not completely Ready for Use. There is Yet some contraints in It. Let's see what are they.

Hi All, Let's start it from where we left in Last Post. Recap - "We have Created Cancel Order Extension. Published It and Installed It on the Cronus Demo Database." If you are not following the Extension Series Then Refer the Table of Contents For Extensions . In This Article we will discuss How can we remove these extension From the Customer Database.

Hi All, Let's start it from where we left in Last Post. Recap - "We understand Concept of Extension Using an Example of Shipping of Jet Report Solutions. Later We did a customization on a Standard NAV 2016 W1 Database For Cancel Order Using Events. After That We Created an Manifest File for our Extension& Create the Navx Package for Our Extension. Later We Published Our Extension on a Cronus Database and then Installed It." If you are not following the Extension Series Then Refer the Table of Contents For Extensions. Now Let's see the Impact of Our Extension on My Database.

Hi All, Let's start it from where we left in Last Post. Recap - "We understand Concept of Extension Using an Example of Shipping of Jet Report Solutions. Later We did a customization on a Standard NAV 2016 W1 Database For Cancel Order Using Events. After That We Created an Manifest File for our Extension. Finally we were able to Create the Navx Package for Our Extension." If you are not following the Extension Series Then Refer the Table of Contents For Extensions . In This Article we will see how we can publish & Install the Extension in our Customer Database, which in this case is a Standard Cronus NAV 2016 W1 Database.

Hi All, Let's start it from where we left in Last Post. Recap - "We understand Concept of Extension Using an Example of Shipping of Jet Report Solutions. Later We did a customization on a Standard NAV 2016 W1 Database For Cancel Order Using Events." If you are not following the Extension Series Then Refer the Table of Contents For Extensions . If you Don't Know How Events Works Refer The Table of Contents for Events & Subscriptions. Pre-Requisites -  Create a Folder in C Drive Named - Extensions In This Article Series We will see How to Create Extension for the Customization That we Did in Extension_Demo1 Database .

Hi All, Recap - "We understand Concept of Extension Using an Example of Shipping of Jet Report Solutions." If you are not following the Extension Series Then Refer the Table of Contents For Extensions . In This Article Series We will see How to Create Extension. Let's see What Microsoft Says About Developing Extensions. Below Image is What Microsoft Says. If you don't understand the Image, don't worry We will discuss all in this article. ** Assumption - For The Extension Demo I am Using Microsoft Dynamics NAV 2016 W1 Initial Build. There are Some Issues Related to Extensions In Cumulative Update 2. If you want to Follow the Steps then Please Install Initial Build of Microsoft Dynamics NAV 2016.

Hi All, In this article Let's See what is the Concept Behind Extension which is Released with Microsoft Dynamics NAV 2016. Consider a Scenario that you are a Developer of your Favourite Software Solution. For Example I will consider Jet Reports, I am a Developer with Jet Reports Team. Now I Start the Software Development of Top of Say Window 8.1. Now Software Development is Over and I need to Pack the Solution and Release it for My Customers and Partners.

Hi All, With Microsoft Dynamics NAV 2016, there is a change in approach for Shipping / Delivering the Customization.  There are Still some more enhancements that Microsoft Will need to do in the Future on the Extensions. In This Series, We will covering How Extensions Works & what are the Limitation with Microsoft Dynamics NAV 2016 Extensions. This Page will acts as Table of Content for Extensions, so Bookmark the Page and keep yourself updated whenever a new article added to this series.

Hi All, Today I would like to Discuss With you an Issue That I Found with a New Feature Released with Microsoft Dynamics NAV 2016. If you remember, with Microsoft Dynamics NAV 2016 a New Feature have been Released Called as Deferral Posting.

Hi All, As New Version Release there are some changes in System Tables and the way how we resolve our issues that we found solution in Previous Versions. With Release of Microsoft Dynamics NAV 2016, our famous issue Get Access to Database Need to be resolved. If You Don't know the issue, here is a simple details - You Receive a Database From Customer or you have a database on your server but you are not part of the Users in the database. When you try to access the Client (Windows / Web / Tablet / Phone) System generates Below Error Message. You do not have access to Microsoft Dynamics NAV. Verify that you have been set up as a valid user in Microsoft Dynamics NAV.

Hi All, Recap Of What we Discussed In The Series. => "We Have seen how to use the Trigger, Business and Integration Events. After that we have discussed the conman Queries related to Events." If you are missing the Story, Refer Table of Index. In This article we will discuss about the New Window that we have for Event Subscriptions. Ways to Access the Event Subscriptions Window -

Hi All, Recap Of What we Discussed In The Series  "We Have seen how to use the Database Trigger, Business and Integration Events."  If you are missing the Story, Refer Table of Index . Let's See What Else we Need to Know about Events.

Hi All, Recap -" We Have seen how to use the Trigger Events. As its a Trigger Event we don't Need to Publish or Declare It. We Just Saw how to Subscribe Trigger based Events." If you are missing the Story, Refer Table of Index . As we already know that there are Three Things Related to Events -   > Publish The Event.    > Raise The Event.   > Subscriber The Event. In This Article We will Discuss Integration / Business Events. First Let's understand Why I Said Integration Or Business Events? Are they same? > If yes Why two names? > IF No Why Saurav is trying to cover them in same article?

Hi All, Let's start it from where we left in Last Post. Recap - "We Created A Custom Table & Page, Linked that to Standard Item Page. Then we Created a Custom Codeunit, Created a Function in Codeunit which Subscribe the OnBeforeDelete Event of Item Table and Called Custom Code in the Subscriber Function." If you are missing the Story, Refer Table of Index . In this article we will try to bring the Value of Last Revision for Item When Item Get Selected in Sales Line Using Trigger Event Subscription. JUST TO CLARIFY - "Some people are getting confused on the new approach of customization using Events. They Feel that everything will be 100% out of standard Code. It's not True. Field Addition and Event Definition are still need to be done on Base Objects." So let's Continue. Create a Field "Latest Revision No." in Sales Line Table and in Sales Order Subform Page.

Hi All, Recap - "Till Now We Have Discussed the Concept of Events and Subscription With an Example". If you are missing the Story, Refer Table of Index For Events & Subscriptions . Let's start it with What Microsoft Says About Events, Publisher and Subscribers. > An event is the declaration of the occurrence or change in the application. An event is declared by a C/AL function, which is referred to as an event publisher function. An event publisher function is comprised of a signature only and does not execute any code. > A publisher is the object that contains event publisher function that declares the event. The publisher exposes an event in the application to subscribers, essentially providing them with a hook-up point in the application. Publishing an event does not actually do anything in the application apart from making the event available for subscription. > A subscriber listens for and handles a published event. A subscriber is a C/AL