Wednesday, December 30, 2015

Upgrade To NAV 2013 or Later - Transferring Record Links From 5.0 or 2009 To 2013 or Later.

Hi All,

Today we will discuss an Common Issue which we face during upgrade to NAV 2013 and Later from NAV 2009 or Previous Versions.

After Data Migration All Data come as-is but Due to some Reason the Migration Process did not process Record Links To New Version.

The Table 2000000068 Record Link Which we are discussing in This Article, have different architecture in NAV 5.0, 2009 and 2013 Onwards. That Might be one reason.

All Thanks To +Suman Maharjan , For Raising the Issue To me.

Monday, December 28, 2015

Friday, December 18, 2015

RDLC Report - The tablix ‘Tablix1’ has a detail member with inner members. Detail members can only contain static inner members.

Hi All,

In This article we will discuss how to resolve an Issue that we face During Creation of a RDLC Report.

Applies To - NAV 2009 and Later (RDLC Reports)

Scenario -
You are creating Say a Document Report. There are multiple tables in Body. For Linking these tables you put all these tables inside a List.

When You want to save the Report, You get an Error Message  -
Error while validating RDL content:
The tablix ‘Tablix1’ has a detail member with inner members. Detail members can only contain static inner members.


Friday, December 11, 2015

Add User to Microsoft Dynamics NAV 2016 Database.

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.

Monday, December 7, 2015

NAV 2016 - Cumulative Update 2 Released.

Hi all,

Please find below the details of  Cumulative Update 2 released for Microsoft Dynamics NAV 2016.

Title - Cumulative Update 2 for Microsoft Dynamics NAV 2016


Build No. - 43897

Release Date - Dec, 2015

Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK.

Download Link


Note: Implementing this cumulative update will require a database conversion.

Some Demanded Changes After Release of NAV 2016 are Part of CU 2-

  • The Symbol menu no longer works. (F5 Will Work Now with Intellisense)
  • An extension object cannot be added when a deleted base object had the same ID.
  • NavEventSubscription error when you start the NAV server if a publisher reference is missing.
  • You cannot publish an extension if it contains too many objects.
  • IntelliSense should not show obsoleted methods. (From Clean Up Series)

NAV 2015 - Cumulative Update 14 Released.

Hi all,

Please find below the details of  Cumulative Update 14 released for Microsoft Dynamics NAV 2015.

Title - Cumulative Update 14 for Microsoft Dynamics NAV 2015


Build No. - 43887

Release Date - Dec, 2015

Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK.


Download Link

Note: Implementing this cumulative update will require a database conversion unless you have already implemented cumulative update rollup 9.

NAV 2013 R2 - Cumulative Update 26 Released.

Hi all,

Please find below the details of  Cumulative Update 26 released for Microsoft Dynamics NAV 2013 R2.

Title - Cumulative Update 26 for Microsoft Dynamics NAV 2013 R2


Build No. - 43896


Release Date - Dec, 2015


Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK

Download Link

Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

NAV 2013 - Cumulative Update 33 Released.

Hi all,

Please find below the details of Cumulative Update 33 released for Microsoft Dynamics NAV 2013.

Title - Cumulative update 33 for Microsoft Dynamics NAV 2013 


Build No. - 43894

Release Date - Dec, 2015

Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK

Download Link


Friday, December 4, 2015

NAVTECDAYS - 2015 Material Available to Download.

Hi All,

As most of us know that NAV TechDays 2015 was held last month on 19 & 20 November and with some great session and workshops.


Those Who don't know what is NAV TechDays - 

NAV TechDays is the name of a conference, organized by mibuso.com.

The goal of this conference is to offer 2 days full of – technical only and highly relevant – sessions, related to Microsoft Dynamics™ NAV.


Wednesday, December 2, 2015

Microsoft Dynamics NAV 2016 - Events Subscriptions Window.

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 -

Monday, November 30, 2015

Thursday, November 26, 2015

Microsoft Dynamics NAV 2016 - How To Use Integration Or Business 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?

Monday, November 23, 2015

Microsoft Dynamics NAV 2016 - How to Use Trigger Events - Part 2

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.

Friday, November 20, 2015

Microsoft Dynamics NAV 2016 - How to Use Trigger Events - Part 1

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 function that subscribes to a specific event publisher function and includes the logic for handling the event. When an event is raised, the subscriber function is a called and it code is run.

If you don't understand what above statement says don't worry I will make sure that all doubts get clear when we finish this series about Event, Publisher and Subscribers.

Wednesday, November 18, 2015

Microsoft Dynamics NAV 2016 - What is Events & Subscriptions

Hi All,

As Promised in Earlier Article Let's Start with Understanding Events and subscription In a Simple Manner.

Let's Start with a Simple Example what an Event & Subscriber are in Microsoft Dynamics NAV.

As most of all use Facebook let's take that as Example to understand it -


Microsoft Dynamics NAV 2016 - Table of Contents for Events & Subscriptions.

Hi All,

With Microsoft Dynamics NAV 2016, there is a change in approach of Customizing the standard Microsoft Dynamics NAV Solution Released by Microsoft.

I would suggest to use these approaches during upgrade and implementation of Navision, as they make Next upgrade and Merging of Cumulative Update Very Easy.

There are so many articles published about Events and Subscriptions for Microsoft Dynamics NAV 2016.

Yes its late but I wanted to come up with a good knowledge about Events and Subscriptions.

Monday, November 16, 2015

Thursday, November 12, 2015

Microsoft Dynamics NAV 2016 - Session Of Direction EMEA in Mannheim.

Hi All,

Most of us like me were unable to attend the Direction EMEA.

These were so many things happened during the Event.

We followed it on the Twitter with Hash Tag #DirectionEMEA.

In the Same Event, Dynamics Next Release was announced as we saw yesterday.

But in this article we will discuss how we can  get more details from event.

Wednesday, November 11, 2015

Future - What Next After NAV 2016. Code Name - Madeira...

Hi All,

While Browsing web I came across some article which says about next release of Microsoft Dynamics NAV.

Let's see the History of Code Names Given to Previous Version  -

NAV 2013 - Code Name 'Sicily'

NAV 2015 - Code Name 'CRETE'

NAV 2016 - Code Name 'CORFU'

And as we all know that all these are the Islands.

Tuesday, November 10, 2015

NAV 2015 - Error While Consuming Query Output.

Hi All,

In today article we will discuss how to resolve a issue that I faced during a development.

The Error Occurs when i try to consume the output of a Query in Power BI. The Error can be faced by any application which is trying to Consume the Data From Query.

Below is the Query that I was trying to Consume -


Issue - While Trying to Consume Output of Query, The Navision Service Tier Crashes. 

Monday, November 9, 2015

Microsoft Dynamics NAV 2016 - Availability For Indian Localization.


Hi All,

This article is for the Navision partners and Developers who are still looking for Information of Avilability of Microsoft Dynamics NAV 2016 for India.

As India was not a Part of Microsoft Dynamics NAV 2015, so most of us were eagerly looking for this information on the web.

Wednesday, November 4, 2015

NAV 2015 - Cumulative Update 13 Released.

Hi all,

Please find below the details of  Cumulative Update 13 released for Microsoft Dynamics NAV 2015.

Title - Cumulative Update 13 for Microsoft Dynamics NAV 2015


Build No. - 43389

Release Date - Nov, 2015

Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK.


Download Link


Note: Implementing this cumulative update will require a database conversion unless you have already implemented cumulative update rollup 9.

NAV 2013 R2 - Cumulative Update 25 Released.

Hi all,

Please find below the details of  Cumulative Update 25 released for Microsoft Dynamics NAV 2013 R2.

Title - Cumulative Update 25 for Microsoft Dynamics NAV 2013 R2



Build No. - 43391


Release Date - Nov, 2015


Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK

Download Link


Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

NAV 2013 - Cumulative Update 32 Released.

Hi all,

Please find below the details of Cumulative Update 32 released for Microsoft Dynamics NAV 2013.


Title - Cumulative update 32 for Microsoft Dynamics NAV 2013 


Build No. - 43390

Release Date - Nov, 2015


Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK

Download Link

Microsoft Dynamics NAV 2016 - How to Configure Phone Client.

Hi All,

In this article we will discuss how we can connect Microsoft Dynamics NAV 2016 with New Client Launched i.e. Phone Client.

This Article Contain Steps for a Android Phone as I have Only Android Phone.

I am doing it having all tiers on my windows 8 machine, steps remain same for multiple servers but issues might be different.

What we Need (Other what we discuss in this article) -

 The Service Tier should be on Public IP
. Some of the Data-card does not Provide you Public IP. check it for sure.

Tuesday, November 3, 2015

NAV 2016 - Cumulative Update 1 Released.

Hi all,

Please find below the details of  Cumulative Update 1 released for Microsoft Dynamics NAV 2016.

Title - Cumulative Update 1 for Microsoft Dynamics NAV 2016


Build No. - 43402

Release Date - Nov, 2015

Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK.

Download Link


Note: You must convert the database if you are upgrading to this cumulative update.

Monday, November 2, 2015

Microsoft Dynamics NAV 2016 - Create New Permissions Sets.

Hi All,


In this Article we will see a New Feature Released with Microsoft Dynamics NAV 2016.

The New Feature allow us to create the permission sets for Microsoft Dynamics NAV Users.

If you remember we used to have customized solutions for same before Microsoft Dynamics NAV 2016. There are quite a Few solutions for Classic Versions of Navision.

I Have Released the Same Tool for Microsoft Dynamics NAV 2013 R2 and Microsoft Dynamics NAV 2015, Please Refer Links Below.

FOR NAV 2013 R2 Refer Article.                                   FOR NAV 2015 Refer Article.

So that's all the Old Story, now Lets see What Microsoft Bring in the Standard Microsoft Dynamics NAV 2016 and How it Works.

Monday, October 26, 2015

Microsoft Dynamics NAV 2016 - Data Migration.

Hi All,

As With Release of New Version of Microsoft Dynamics NAV 2016, we also need to look into possibility of Upgrade Our Customer Base to it.


In this article I will share my experience from a Mock Migration From 2013 R2 To NAV 2016.

So if something that you would be interested in Reading Please go Ahead.

Read Already Published Article About NAV 2016 Here.

Friday, October 23, 2015

Microsoft Power BI - October Updated Released.

Hi All,

Today Microsoft Have Released the Update for October with 23 Significant enhancements.

Let's see what are the Updates and from where we can download the Updated Product.

For Downloading Latest Product Click here.

With Latest Update you can import Custom Visualization in Power BI Desktop.

For Downloading Custom Visualization Click here.

If you are a Developer and want to Create and Submit the Custom Visualization for Power BI, you can submit that using the above link.

Wednesday, October 21, 2015

Microsoft Dynamics NAV 2016 - Navision List of Virtual / Hidden Tables.

Hi All,

As I always release the list of Virtual Tables in Every New Version of Navision.

Here I am with the List of Hidden / Virtual Tables in Microsoft Dynamics NAV 2016.

For NAV 2009 Virtual Table List Click Here.

For NAV 2015 Virtual Table List Click Here.

For Already Published Article about  NAV 2016 Click Here.

Below is the List of Virtual Table In Microsoft Dynamics NAV 2016. The New Tables are Highlighted in Yellow.

Tuesday, October 20, 2015

Microsoft Power BI - Links To Remember.

Hi All,

As we are discussing & learning about Power BI together.

One of the Blog reader who is interested with this series of articles requested to have a article of the website links which we should visit and get information about Power BI.


For Other Articles About Power BI Refer Table of Index.

This page will keep on updating with time, as I explorer more about it. Your addition on the list are welcome.

Below are Some Links Related to PowerBI, which will help you.


Please suggest other Web Site Links if you find any.

Stay Connected.

Regards,
+saurav dhyani 
saurav-nav.blogspot.com

Thursday, October 15, 2015

Microsoft Dynamics NAV 2016 - Trending Links

Hi All,

Below are some Links to the articles which are trending on Social Media for NAV 2016.


The Links are related to Issue Resolutions and New Addon's Released for NAV 2016.

Please refer below links to know more.


For Already Published Article about  NAV 2016 Click Here.

Wednesday, October 14, 2015

NAV 2015 - Cumulative Update 12 Released.

Hi all,

Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2015.

Title - Cumulative Update 12 for Microsoft Dynamics NAV 2015


Build No. - 42951

Release Date - Oct, 2015

Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK.


With this cumulative update, Microsoft Dynamics NAV 2015 is compatible with Windows 10 and Office 2016.

Download Link

Note: Implementing this cumulative update will require a database conversion unless you have already implemented cumulative update rollup 9.

NAV 2013 R2 - Cumulative Update 24 Released.

Hi all,

Please find below the details of  Cumulative Update 24 released for Microsoft Dynamics NAV 2013 R2.

Title - Cumulative Update 24 for Microsoft Dynamics NAV 2013 R2



Build No. - 42950


Release Date - Oct, 2015


Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK

With this cumulative update, Microsoft Dynamics NAV 2013 R2 is compatible with Windows 10 and Office 2016.

Download Link

Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

NAV 2013 - Cumulative Update 31 Released.

Hi all,

Please find below the details of Cumulative Update 31 released for Microsoft Dynamics NAV 2013.


Title - Cumulative update 31 for Microsoft Dynamics NAV 2013 



Build No. - 42948

Release Date - Oct, 2015



Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK

With this cumulative update, Microsoft Dynamics NAV 2013 is compatible with Office 2016.

Download Link

Microsoft Dynamics NAV 2016 - New Updates from Microsoft Team Blog.

Hi All,

There are some new articles released for Microsoft Dynamics NAV 2016 on Microsoft Team Blog.

Please Visit Microsoft Team Blog From Below Links -

Approval Types in Workflow for Microsoft Dynamics NAV 2016

Upgrade Considerations for Document Approvals

Introducing Extensions in Microsoft Dynamics NAV 2016

For Already Published Article about  NAV 2016 Click Here.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/



Tuesday, October 13, 2015

Microsoft Dynamics NAV 2016 - Articles From Other Great Bloggers.

Hi All,

As most of know that there are so many news being shared now a days for Microsoft Dynamics NAV 2016 on the Internet.

Below is the summary of Websites where you can read everyone views whom I am already following for Microsoft Dynamics NAV 2016.

Go Visit below Blogs to read others views and new information available. Do let me know if I missed someone.

Microsoft Dynamics NAV 2016 - Power BI.

Hi All,

In this article I will share with you all the Links available for Power BI in Microsoft Dynamics NAV 2016.


For Already Published Article about  NAV 2016 Click Here.

If you are regularly Following then you might have noticed that we have already started discussion related to Power BI.
For Already Published Article about Power BI Click Here.


Microsoft Dynamics NAV 2016 - WorkFlow

Hi All,

In this article I will share with you -

  • What Have been Removed With Introduction of WorkFlow.
  • Available Workflow Templates in Microsoft Dynamics NAV 2016. 
  • All the Links available for WorkFlow in Microsoft Dynamics NAV 2016.


For Already Published Article about  NAV 2016 Click Here.

Monday, October 12, 2015

Friday, October 9, 2015

Microsoft Dynamics NAV 2016 - Links For Universal App

Hi All,

In this article I will share with you all the Links available for Universal App in Microsoft Dynamics NAV 2016.

For Already Published Article about  NAV 2016 Click Here.


Links Related to Universal App -



Experience - 


Design and Develop - 




Stay for More, I will come back with more articles about Microsoft Dynamics NAV 2016.

Regards,
Saurav Dhyani

Microsoft Dynamics NAV 2016 - CRM & Enhancements in Web Client.

Hi All,

As promised I am back with New Features in NAV 2016.

In This article we will discuss list down New Features in NAV 2016 related to Enhancements in Web Client and CRM Integration.

For Already Published Article about  NAV 2016 Click Here.


Microsoft Dynamics NAV 2016 - Contents on Dynamics Learning Portal (DLP) for Partners.

Hi All,

In this article We will see the content related to Microsoft Dynamics NAV 2016 of Dynamics Learning Portal accessible for Microsoft Dynamics Partners.


For Already Published Article about  NAV 2016 Click Here.


Microsoft Dynamics NAV 2016 - What is Brick?

Hi All,

While Trying to Identifying Changes in Microsoft Dynamics NAV 2016 Table I came across a Property that have been changed with Microsoft Dynamics NAV 2016.

Let's see what is that and what is the use of It.

For Already Published Article about  NAV 2016 Click Here.

Thursday, October 8, 2015

Microsoft Dynamics NAV 2016 - New Features Part 4

Hi All,

As promised I am back with New Features in NAV 2016. This time its related to New Feature Called Extensions & Events.


For Already Published Article about  NAV 2016 Click Here.

Below are the Links of How Do I Series, How To Demo and Documents released by Microsoft for This Feature.

Microsoft Dynamics NAV 2016 - New Features Part 3

Hi All,

In this article Let's talk about a New Feature Released with Microsoft Dynamics NAV 2016.

Preview Posting

We will Cover - 
  • How to use Preview Posting With Microsoft Dynamics NAV 2016.
  • Technical aspect of Preview Posting.
  • Where all we can find Preview Posting in Base Microsoft Dynamics NAV 2016.

Microsoft Dynamics NAV 2016 - Reports Do we need to Upgrade From NAV 2015?

Hi All,

Whenever there is a Release for Microsoft Dynamics NAV, the partners worry about changes in RDLC Layout.

If you remember there were changes in usage of Set-data and Get-data from NAV 2009 to NAV 2013 which in some cases causes issues when we use the standard Microsoft Upgrade report Action.

For Already Published Article about  NAV 2016 Click Here.

In this article we will try to identify the answer of a common Query.

"If My Customer is Already Upgrade to Microsoft Dynamics NAV 2015, Do I Need to Upgrade Report Again?"


Microsoft Dynamics NAV 2016 - New Features Part 2


Hi All,

As promised I am back with New Features in NAV 2016. 

This time its related to Enhancements related to Finance, based on a request or order from a blog reader which says -

"Why you keep posting New Technical features, Are there no functional improvements?"


For Already Published Article about  NAV 2016 Click Here.

In this article I will list down changes Related to Finance.

Wednesday, October 7, 2015

Microsoft Dynamics NAV 2016 - Updates from Team Blog

Hi All,

I agree there are so many articles floating for NAV 2016, but that is what happened when we get a New Version.

Everyone in Navision World is so excited about new release and always try to get hold on any new details that there on web.

Below are some recent happenings in Microsoft Team Blog -


Microsoft Dynamics NAV 2016 - ClickLearn

Hi All,

Just Getting Updated From Directions EMEA using Twitter (#DirectionsEMEA).

As most of us spent so much time during documentation for our customers for the Changes that we did for the Customer In Standard Microsoft Dynamics NAV Product.

It Involves Multiple Task -

  • Take Screen Shot.
  • Paste it in Word.
  • Write the Description about the Screen Shot what it does.
  • Formatting the Document.
It takes quite a huge amount of time in doing all this for every project, and the story remain same for every another project.

In Directions EMEA, ClickLearn introduce a High End Training Documentation for ISV Partner.
  • Support Multiple Language.
  • User Interactive Recording.
  • Video recording.
  • Written Instructions.
  • Hands on Lab.
  • Virtual Assistance.

Regards,
Saurav Dhyani

Microsoft Dynamics NAV 2016 - New Features Part 1

Hi All,

Today's article is to list down some New Features which I came across as of now.

So Let's Start with basic features -

1. New Icons
Yeah I know that's not a feature but it looks a bit cool to me having new Icons for Navision Clients as shown below.


Tuesday, October 6, 2015

Microsoft Dynamics NAV 2016 - Released.

Hi All,

So Now its finally official and Microsoft Dynamics NAV 2016 (a.k.a Corfu) is now available to download on Microsoft Partner Source.

It Happened Last Late Night (I.S.T), so a bit delay in the article, but I hope everyone is excited to get Hands on the product and Explore What's new that we were hearing from Quite a some time.

 As of Now NAV 2016 available for 21 Localized Versions and W1 i.e Total of 22 Product Version have been Released.

AU-Austr​alia​
FI-Finland
NL-Netherlands
CH-Switzerland
AT-Austria
FR-France
​NZ-New Zealand
UK-​United Kingdom
BE-Belgium
DE-Germany
NO-Norway
US-United States
CA-Canada
IS-Iceland
ES-Spain
RU-Russia
CZ-Czech Republic
IT-Italy
SE-Sweden
W1
DK-Denmark
MX-Mexico




Monday, October 5, 2015

Table Information In NAV 2013 R2 & NAV 2015.

Hi all,

If you remember my old article where we discussed how we can achieve Table Information Page for Role Tailored Client in NAV 2013 R2.

Old Article

From NAV 2013 R2, with introduction of Multitenancy the table Information feature was removed from Developer Environment.

But still the table Table Information still exist in the database.

In this article we will discuss a requirement from one of my Blog Reader +Bhushan Teredesai. At the same time I will share the objects for Table Information in NAV 2013 R2 and NAV 2015.

Thursday, October 1, 2015

Microsoft MVP Again, Year Two!

Hi All,

MVP Again!, 1st October has a very special meaning to me, this day starts with full of expectations and fast heartbeats which lasts until the moment of receiving email from Microsoft.

Once again Microsoft awarded me with the MVP (Most Valuable Professional) award for the 2nd time in a row in the Microsoft Dynamics NAV category. I'm honoured to be the part of Microsoft MVP Program, this is one of the most prestigious award to me.The award recognises the things that people like myself have gotten up to over the previous year as it relates to community contributions and of course, doing really useful stuff with Microsoft things.

Here is the body of the mail that I received:

Microsoft Power BI - Installation.

Hi All,

As Promised in earlier article, I am back with some more stuff related to Power (*) tools.

In This article we will list down where all Power Components can be found and Downloaded.  All these components are easy to install, so we will not go in details of installation.

You can download any or all of these based on your Need, but the series will focused on Power BI.

For Other Articles About Power BI Refer Table of Index.

Friday, September 25, 2015

Microsoft - New Links Worth To Look

Hi All,



As there are so many products updated Version are being released for so many Microsoft products.

Below are some Links which are worth to have a look with respect to NAV Ecosystem.

These links are part of the ecosystem that we use for Microsoft Dynamics NAV like Visual Studio, Azure...

With Every New Microsoft Dynamics NAV release we are getting strongly tied up with other technologies like discussed below.


Monday, September 21, 2015

Upgrade From Classic To RTC - Issue with Line Feed and Horizontal Tab.

Hi All,

Today I would like to discuss a issue that we have during upgrade from Navision Classic Client to Navision RTC Client.

What is the issue ?

The Issue is with the data having Line Feed & Horizontal Tab.

On Which Fields the issue is?

The major issue is with the Primary key field. On Fields other than primary key it dosent make much of the difference.

Sunday, September 13, 2015

Microsoft Power BI - Introdcution

Hi All,

Today I would like to introduce a Tool Released by Microsoft Called as "POWER BI". 

As per my understanding its a combination of four tools which were released by Microsoft -



  • Power Pivot.
  • Power Query.
  • Power View.
  • Power Map.

I would be exploring the Product and will be sharing the Information as per my learnings and understanding. 

Microsoft Power BI - Table of Content

Hi All,

We will be discussing Microsoft Power BI in a series of articles.


As I am assuming there will be so many articles that I will be coming up related to Microsoft Power BI.

This page will act as Table of Contents, where you can find link of all the articles released for Power BI. List will keep on appending as we keep on discussing New Things.

Stay Tuned for update and Book Mark the article to remain updated.

  1. Microsoft Power BI - Introduction
  2. Microsoft Power BI - Installation
  3. Microsoft Power BI - Links To Remember


Regards,
Saurav Dhyani
saurav-nav.blogspot.com

Tuesday, September 8, 2015

NAV 2013 - Cumulative Update 30 Released.

Hi all,

Please find below the details of Cumulative Update 30 released for Microsoft Dynamics NAV 2013.


Title - Cumulative update 30 for Microsoft Dynamics NAV 2013 


Build No. - 42591

Release Date - Sep, 2015


Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK


Download Link

NAV 2013 R2 - Cumulative Update 23 Released.

Hi all,

Please find below the details of  Cumulative Update 23 released for Microsoft Dynamics NAV 2013 R2.

Title - Cumulative Update 23 for Microsoft Dynamics NAV 2013 R2


Build No. - 42610


Release Date - Sep, 2015


Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK

Download Link

Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

NAV 2015 - Cumulative Update 11 Released.

Hi all,

Please find below the details of  Cumulative Update 11 released for Microsoft Dynamics NAV 2015.

Title - Cumulative Update 11 for Microsoft Dynamics NAV 2015


Build No. - 42603

Release Date - Sep, 2015

Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK.


Download Link


Note: Implementing this cumulative update will require a database conversion unless you have already implemented cumulative update rollup 9.

Monday, September 7, 2015

How to Use - Job Queue Parameter String?

Hi All,

Today we will discuss about the Parameter String Field in Navision Job Queue Entry Page / Form. The Functionality is still same, so the steps below can be replicated and used in NAV Classic also. For Demo Purpose We will be using NAV 2013 R2.

Why we need to have a Parameter?

Consider a Scenario where you want to does multiple things with a single objects in NAS based on parameter you pass. Example - There should be different action on the sales Header Table based on Parameter that I Pass.

So Let's see how to use the Parameter String in Job Queue.

For the Demo, I have created the Job Queue & Job Queue Category List as DEMO.

Monday, August 31, 2015

NAV 2013 & Later - How to Run a Batch File From NAV.

Hi All,

In Back Old Days we used to Run a Batch File From Navision Using Shell Command. The Shell Command is now discontinued with Release of Role Tailored Client.


Today we will discuss the possibility of same using Dotnet Command.

For the Demo i have create a .bat file named as autonav.bat. The bat file used in demo just rename a text file placed in C:\NAVDemo\.

The File Placed at above location is named as "agic ile". On Right Hand Side you can see  image shows the code in bat file and the files.


Monday, August 24, 2015

NAV 2013 R2 / NAV 2015 - Role & Permission Wizard Updated


Hi All,


This article list down the updates done based on comment on the article "NAV 2013 R2 - Roles & Permission Wizard".

I had received request from some of my readers for minor changes in the tool. I have incorporated all the changes in the tool.

If you haven't went to the article till now please visit the article from the hyper-link
Roles & Permission Wizard Version 1.


Update 22/08/2015:

- Increased the Size of Role ID to 20 (as of Standard Microsoft Field Size).

- NAV 2015 Compatibility.

- Ability to Save New Role or Update Existing Role.
If Any Permission Set Already Created with Same Name, then the Update process will happen otherwise a new Role Will be Created.

You can download the updated tool from below links -

SkyDrive                Mibuso              

File Name - SauravNavRP.NAVW17.01.02.rar

Regards,
Saurav Dhyani
saurav-nav.blogspot.in

Monday, August 17, 2015

NAV 2013 R2 - Conditional Colouring in Matrix Page

Hi all,

In the following post we will try to conditional colour the values appearing on the matrix Page.

For the Demo Purpose we will use the Page "Items by Location Matrix".


The Article is based on request of Mr. Thiyagarajan M. All thanks to him if you find the article useful.

A standard Item By location Matrix Page Look Like as shown in Right.

For Conditional colouring a Non Matrix Page,please Refer the Article
Conditional Colouring in NAV 2013 Pages


Thursday, August 13, 2015

NAV 2013 - cumulative update 29 Released.

Hi all,

Please find below the details of Cumulative Update 29 released for Microsoft Dynamics NAV 2013.


Title - Cumulative update 29 for Microsoft Dynamics NAV 2013 



Build No. - 42219

Release Date - Aug, 2015


Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK


Download Link

NAV 2013 R2 - Cumulative Update 22 Released.

Hi all,

Please find below the details of  Cumulative Update 22 released for Microsoft Dynamics NAV 2013 R2.

Title - Cumulative Update 22 for Microsoft Dynamics NAV 2013 R2


Build No. - 42221

Release Date - Aug, 2015

Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK

Download Link

Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.