Error while opening NAV2013 R2 database

Some times we used to get the below error while opening NAV2013 R2 database

Error :

---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
The Object table contains a Microsoft Dynamics NAV Development Environment field data type that is not compatible with the SQL Server data type:

Field: Version List
Type: Text248
SQL type: VARCHAR(80)
---------------------------
OK  
---------------------------

to resolve this error ,Simply run the below command in SQL Server

ALTER TABLE [dbo].[Object]

ALTER COLUMN [Version List] VARCHAR(248) NOT NULL

I hope this will help some one.

Thank you.

Error while running Power shell

Some times we may get the below error while import module in like power shell

'Run only scripts that you while scripts from the internet can be useful ,this script can potentially harm your computer. If you trust this script, use the unblock-file cmdlet to allow to run without this warning message. Do you want to run c:\program files (x86)\microsoft dynamics NAV\90\Role Tailored Client\Microsoft Dynamics.nav.Apps.Tools.Format.ps1xml?'

as shown below

Solutions                                                                                                                                                     

   To resolve this issue,please foollow the below steps,

1.             Right-click on the .ps1 file in question, and select Properties

2.              Click Unblock in the file properties

  3.        OK.

Cumulative Update 1&2 for Microsoft Dynamics NAV 2016 has been released

Cumulative Update 2 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

•   AU – Australia
•   AT – Austria
•   BE – Belgium
•   CH – Switzerland
•   CZ – Czech Republic
•   DE – Germany
•   DK – Denmark
•   ES – Spain
•   FI  – Finland
•   FR – France
•   IS – Iceland
•   IT – Italy
•   NA – North America
•   NL – Netherlands
•   NO – Norway
•   NZ – New Zealand
•   RU – Russia
•   SE – Sweden
•   UK – United Kingdom

Download here
NAV2016-CU3

NAV2016 CU2

NAV2016 CU1

How to Set filters on factbox through code

I would like to set filter on my fact box which is not able to do through page link.

Steps are shown below

I have added below the function in my factbox page and

Set the name for the factbox in our main page.
Now we need to call as shown below in onaftergetRecord trigger

Microsoft Dynamics NAV 2016 System Requirements

You can find the below system requirements

 

Client components

• Microsoft Dynamics NAV Windows Client Requirements 
• Microsoft Dynamics NAV Development Environment Requirements 
• Microsoft Dynamics NAV Web Client Requirements 
• Microsoft Dynamics NAV Tablet Client and Phone Client (in a Browser) Requirements 
• Microsoft Dynamics NAV Universal App Requirements 

Server components

• Microsoft Dynamics NAV Server Requirements 
• Microsoft Dynamics NAV Web Server Components Requirements 
• Microsoft Dynamics NAV Database Components for SQL Server Requirements 
• Microsoft Dynamics NAV Help Server Requirements 

Additional components and features

• Microsoft Dynamics NAV as an App for SharePoint Requirements 
• Automated Data Capture System Requirements 
• Microsoft Office Outlook Add-In Requirements 
• Microsoft Dynamics CRM Integration Requirements 
• Automated Deployment on Microsoft Azure Requirements 

Cumulative Updates for Microsoft Dynamics NAV 2015

Microsoft has released the below cumulative updates includes all application and platform hotfixes and regulatory features t for Microsoft Dynamics NAV 2015. 


Click here for Cumulative Update 8

Click here for Cumulative Update 7

Click here for Cumulative Update 6

Click here for Cumulative Update 5

Click here for Cumulative Update 4

How to add nested sub pages in NAVISION

This is a basic concept of page  designing in NAV.

To add a sub page for another sub page follow below

Add the sub page and properties --> give Provider ID of another sub page,so that we can give the sub page of another sub page.

below example: