Business Central

Friday, 30 October 2015

Difference between For loop, While loop and Repeat-until loop

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:

//statement

In this case as you see whether the condition is true/false but the statement is executed at least once.




Difference between Upload and Change in License Information

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.

Wednesday, 7 October 2015

New Features in Dynamics NAV 2016

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. 

Tuesday, 6 October 2015

Microsoft Dynamics NAV 2016(Formerly Corfu) has been released world wide

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

Monday, 5 October 2015

To Restore NAV 2009 Missing Data using NAV 2005 FDB file

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 2009 R2.
Go to Tools - > Security - > Windows Logins - > Specify your User ID in the ID field, -> Click on Roles tab and Select Role ID as 'SUPER' as shown in fig. below.

fig: shows USER ID                                                  fig: shows Role ID

Once you are done with this. You can open the database, open the company and start using the data's in various table.