Dynamics 365 Business Central (Dynamics NAV)

Everyone would have installed NAV 2016 and would have faced the same problem, i.e, you couldn't able to run NAV 2015 administration tool if you have installed NAV 2016 One way to use the services of NAV is using powershell. But, many people might not be familiar with commands of power shell. So, its better go first identify where is the problem and what's the solution for a problem. The problem is mainly because of registry key. NAV 2015 and NAV 2016 is pointing to the same registry key in registry editor. If you go to the following path “C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client\Microsoft Dynamics NAV Server.msc” and open Services.msc using notepad as shown below both NAV 2015 and NAV 2016 will point to same key, There are 2 ways to fix this above problem, 1. Download the registry file You can download the registry file here in my dropbox in the below link,           https://www.dropbox.com/s/b...

As we all know, Microsoft will be releasing new cumulative updates often to fix various bugs in NAV. So, again there's a release of new Cumulative updates in NAV. In NAV 2016, CU1 - Build 43402 has been released. In NAV 2015, CU13 Build - 43389 has been released. In NAV 2013, R2 CU25 Build - 43391 has been released. In NAV 2013, CU32 Build - 43390 has been released.

Virtual tables : They're created by the system at runtime. The tables are read-only, information present in these tables cannot be changed. It do not store physical information in database. You cannot insert, modify, delete information in virtual tables. You cannot view the virtual table or run it from table object designer. But, however you can create a page with source table view property as any virtual table name and run it. Example: Consider a date virtual table, Its existence is virtual not visible in object designer. But when we create a page with source table view as "Date" table. We can see the values of Date virtual table in role centered page. fig. below explains the virtual table in detail. Create a page with a name 'Date virtual list' and give a source table view as "Date". when you run the above page you can see the following data's inside the "Date table" Temporary Tables: (Memory-based table...

This is a very simple approach but most of the beginners get confused on these things often while designing page. If we go to any container with cuegroup. We can see in "View" toolbar -  page actions and control actions. Always, page actions and control actions behave same at the last line ( 1st empty line). However, Page Actions : page actions can be seen when you navigate through different areas as shown below. The design of page is simple select any page and go to design -> view -> page actions as shown below. Control Actions: Control actions can be seen on role-centered page.  Control actions appear only in Cue group as shown in screenshot below. You can view the design of control action by selecting the cuegroup and choosing the control actions in -> view -> control actions. fig. below would express the design in a better way. As shown in the fig. below go to design of Cuegroup page, select the cuegroup, go...

Technically its very important to know when to use for, while and repeat-until loop while we are coding based on the requirement. Since all the 3 loops are used to perform incremental task. Developers must be properly knowing when to use For loop, while loop and repeat-until loop. So, the major reason between these three loops is: 1. For loop: For loop is used if we know the number of times the statement needs to be executed. FOR var := 1 TO 5 DO BEGIN  //statement END; output : //statement //statement //statement //statement //statement In this case the statement is executed 5 times. 2. While loop: While loop will not execute if the condition is false. var := 0; WHILE var <> 0 DO BEGIN   var := var - 1;  //statement END; output : In this case the condition is failed. So while loop never gets executed. 3. Repeat-Until loop: var := 0; REPEAT   var := var - 1;   //statement UNTIL var <> 0; Output: //...

Usually we will be working on different add-ons and we also update the license depending upon the add-ons of different customer. As we all know, We update the license by going to NAV IDE, Tools - > License Information. In License Information window we see 3 tabs Upload, Change and Help. Everyone will often get confused between choosing Upload / Change while updating the license information. So, its better to know the difference before messing up with assumption. When you choose Upload , the license will get loads into Master database of SQL Server. Whenever  you open any NAV database of the server you are working on it will use the same license. When you choose Change , the license gets loaded for active session only. When ever you close the current session and open a new client. It will be restored with its earlier license.

As you all know NAV 2016 was made generally available since october 5th world wide. So, its better to know the added features in NAV 2016 before using its actual environment. Image source is from Microsoft website Earlier NAV was available only in Desktop, Tablet and web client but now it is also available in phone .  Power BI - A new tool was introduced recently from microsoft to analyze and organize data. In NAV 2016 it is possible to analyze NAV data since there's an improved integration with office 365. You can bring the NAV 2016 Databases into effective action by using azure SQL Server. It has introduced new functionalities such as posting preview, deferrals and positive pay(only for U.S) Third parties can add their own data sources using NAV 2016.  As you saw the additional features in NAV 2016 it is quick to implement and easy to use. 

Its a very good new to all Dynamics NAV workers to know that Dynamics NAV 2016 has been released world wide and its now available in following countries. AU-Austr​alia​ AT-Austria BE-Belgium CA-Canada CZ-Czech Republic DK-Denmark FI-Finland FR-France DE-Germany IS-Iceland IT-Italy MX-Mexico NL-Netherlands ​NZ-New Zealand NO-Norway ES-Spain SE-Sweden CH-Switzerland UK-​United Kingdom US-United States RU-Russia W1 You can be redirected to download link of Dynamics NAV world wide as below: https://mbs2.microsoft.com/fileexchange/?fileID=70f6f135-6769-40df-82cd-92e77e5c02e9

I was facing a problem while working on one of the addons i.e I couldn't see any data in NAV 2009 R2 database. But I wanted to test it so I asked my colleagues about how to get data.  They guided me many approaches. But one of the simple approach which I felt easy and which I couldn't find anywhere in rest of the blog posts is to restore the data using its earlier fdb file. So, I decided to write this blog so that it might be useful to others also. Firstly, Open NAV 2005 fdb file in 2009 IDE. This can be done by just double clicking on database.fdb file in the below path. (DVD_Folder\CsideClient\program files\Microsoft Dynamics NAV\CSIDE Client\database.fdb) Once you double-click that folder, the following dialog box will appear in 2009 NAV IDE. Specify your User ID and Password(blank).  Specify the .fdb backup file pathname in the Database Name field. Following are the steps you need to follow while setting up the 2005 database in...

1. FINDSET : Retrieves set of records. Transaction begins with FINDSET Command.  2. FINDFIRST :  It will retrieve the first record Retrieves only 1 record, the last one within filter, sorted accordingly. Transactions begins when a call to update the database. (Insert, modify, delete). Opens the connection with database fetches the record from database closes the connection Example: IF EmployeeVar.FINDFIRST THEN       MESSAGE('employee no. %1',EmployeeVar."Employee No."); Since we are not repeating the process its better to use FINDFIRST if you're fetching only one time from the database. 3. FIND('-') : It will also retrieve the first record Retrieves only 1 record, the last one within filter, sorted accordingly. Transactions begins when a call to update the database. (Insert, modify, delete). Opens the connection with database fetches the record from database doesn't close the connection until the c...

I have browsed through lots of blogs and I nowhere found the proper example on how to use RUNMODAL Function. So, I taught of writing this blog so that it might be useful other NAV Developers. RUN Function : The page is opened and you can still go back to what you were doing on previous page. We can switch to other page which is shown. RUNMODAL Function: The page is opened and you cannot go back to previous page until MODAL Page is closed. We cannot switch to any other page until current page is closed. Example : Scenario : Assume I want to filter a Customer table who has balance between 10,000 to 1,00000 and to display the filtered values in the Customer list page. You can do the following in the coding part. Customer.CALCFIELDS(Balance);//Calculates flowfield values Customer.SETRANGE(Balance,10000,100000);//apply filter range IF Customer.FINDSET THEN     PAGE.RUNMODAL(PAGE :: "Customer List",Customer);//opens the filtered list. Fig. a...

As a programmer everyone knows what is function..!! A function is nothing but a subprogram or a subroutine mainly used for code re usability. In CAL programming we call the code of a function as Trigger code. Function call is written as same as in C programming- result := add(a,2); or result := add(a+2*3,b); Pass by value Change i.e. made in function trigger if it doesn't affect the variables in calling trigger then it 's call by value. If a change in function trigger affects the variables in calling trigger then it' s call by reference. You cannot use constants for pass by reference. actual parameter is used in a calling function trigger. Formal parameter is used in called function trigger. 5 commonly used built-in functions are: MESSAGE - D isplays message on the screen STRLEN - returns no. of characters used. MAXSTRLEN - returns the defined length of  the string variable. COPYSTR - Returns a part or whole of a string. CLEAR - clears the passe...

Always it is necessary to create a table with your own scenario because that will improve your creativity mind and will also give you a deep knowledge of how to learn things quickly. So, Now I'm going to show a scenario based on movie list. I'm going to explain how to create a table along with how to create a report linking two tables .  1.        Create table with name MovieMakingTable with fields including (Serial no., movie name, sensor certification,audience rating, production cost) 2.       Set Serial no. and production cost as primary key, because you need to relate two tables based on serial no. and movie name can be repeated with  d/f serial no. based on different productions. In order to repeat names for same serial no. we also take sum of productions as primary key. 3.       Let the properties of this table be not disturbed. 1.        Create...

To know which version of MS Dynamics you are using - Click on Help and select ‘about Microsoft dynamics NAV development environment’ A window appears which shows the latest version you have been upgraded and the product is licensed to Microsoft and some more information. Difference b/w version and version list in MS Dynamics NAV Version Version List It displays the latest version i.e. being used in MS Dynamics NAV (upgraded version) It displays the version of various objects which were added some extra features. It differs from 1 object to another or from 1 field to another. It shows licensed information It doesn’t show any such things We can’t edit in version window We can edit in version list column It is used to know the details of which version we’re using It used mainly to update the changed information. Ex. Suppose developer ‘A’ will ch...