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:

 

Cumulative Update 7 for Microsoft Dynamics NAV 2015 has been released

Click Here for Cumulative Update 7 for Microsoft Dynamics NAV 2015

Cumulative Update 19 for Microsoft Dynamics NAV 2013 R2 has been released

Click Here for Cumulative Update 19 for Microsoft Dynamics NAV 2013 R2

Exception Info: Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLFieldNotFoundException

Some times client will crash when we convert from NAV2009 R2 to NAV2013.

We may get the following error when we check the Event Viewer

Application: Microsoft.Dynamics.Nav.Client.exe

Framework Version: v4.0.30319

Description: The process was terminated due to an unhandled exception.

Exception Info: Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLFieldNotFoundException

Stack:

   at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSessionInitializer.Initialize()

   at Microsoft.Dynamics.Framework.UI.Builder.Initialize()

   at Microsoft.Dynamics.Framework.UI.UISession.Initialize()

   at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.InitializeUISession()

   at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.SetupSessions()

   at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.InitCore()

   at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.InitCore()

   at Microsoft.Dynamics.Framework.UI.ClientSessionCore.Init()

   at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.Run()

   at Microsoft.Dynamics.Nav.Client.WinClient.NavClientErrorHandler.ExecuteAndCatchExceptions(System.Func`1<Int32>)

   at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.DoExecute(System.Func`1<Int32>)

   at Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.RunCore()

   at Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.Run(Boolean)

   at Microsoft.Dynamics.Nav.Client.WinClient.StartWinFormsClient.RunAndDispose()

   at Microsoft.Dynamics.Nav.Client.Program.ExecuteNormally(System.Func`1<Int32>)

   at Microsoft.Dynamics.Nav.Client.Program.Main(System.String[])

Solution : 

 When we get this error ,that means our all the tables are not compiled .So we need to recompile all the  objects.Tables those are having data should be compiled.

Tip : How to import only objects from Navision backup (FBK) files

We can import objects directly  from NAV backup FBK file without restore  

If you have a Navision backup (the FBK file) with the application objects included, then you can import these objects directly without restoring the whole backup.

In the Object designer choose import and select the .FBK file instead of the suggested .FOB or .TXT.

 Navision will then import only the objects.

NAV UPGRADE Error : Invalid object name 'XXXX.dbo.company$xxxxx' The table for which the above error is occurring does not exists in NAV database or could not be found in SQL

We get the below error while converting the  database from NAV2009 to NAV2013.

 
 Invalid object name 'XXXX.dbo.company$xxxxx' The table for which the above error is occurring does not exists in NAV database or could not be found in SQL


Solution :

Object Metadata must have Table Reference in NAV2009  which table object does not exists in the current  database.


We have to remove the record and start upgrade again from the beginning.

NAV Upgrade Error : Login failed error while upgrading from NAV2009 to NAV2015

The following error occur when we try to open the NAV2009 database with NAV2013 client in upgrade process and you can’t open the database in NAV2009 anymore, can’t fix the error and can’t continue further with upgrade process.

---------------------------

Microsoft Dynamics NAV Development Environment

---------------------------

The following SQL Server error or errors occurred:

18456,"28000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'xxxxx'.

4060,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "xxxxxx-xxxx" requested by the login. The login failed.

---------------------------

OK  

---------------------------

Solution:

Restore the NAV2009 backup again and remove all tables which have property “LinkedObject“ Yes before converting the database to NAV2013.

The value of Decimal parameter is outside of the permitted range. The current value is: 1,944,000,000,000,000. The permitted range is: from -999,999,999,999,999.99

We will get the below error while run the step2 process for upgrade from NAV2009 R2  to NAV2015

The value of Decimal parameter  is outside of the permitted range. The current value is: 1,944,000,000,000,000. The permitted range is: from -999,999,999,999,999.99.

The above error will occur due to UpdateProdOrderRoutingLine function in the codeunit 104051. this function is Updating Expected Capacity Need in the Prod. Order Routing Line with Expected Capacity Need with the Time factor of the unit of Measure code which returns the value outside of the decimal range.

An error occurred when opening the report designer. A supported version of Visual Studio could not be found

We will get the below error when visual studio does not exist in our system,But we have report Builder 

An error occurred when opening the report designer. A supported version of Visual Studio could not be found.

How to enable Report Builder : 

steps as below

1. Navigate to Tools - Options.

2. Set Property Use Report Builder as YES.

    

Now open the layout of any report, it will open with Report Builder as shown below.

I

Cumulative Update 5 for Microsoft Dynamics NAV 2015 has been released

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

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
• 
  

Note: You must convert the database if you are upgrading to Cumulative Update 5 from a cumulative update earlier than Cumulative Update 4 (build 39663). For more information, see Converting a Database in Help for Microsoft Dynamics NAV. 

You can download the cumulative update from KB 3039824  – Cumulative Update 5 for Microsoft Dynamics NAV 2015 (Build 40262). 

Upgrading Reports from NAV2013,NAV2013R2 to NAV2015

If you want to use reports from earlier versions of Microsoft Dynamics NAV, you must upgrade the reports before you can run or modify them. The report formats that were supported in Microsoft Dynamics NAV 2013 were client report definition (RDLC) 2008. In Microsoft Dynamics NAV 2013 R2, the report formats are replaced with client report definition (RDLC) 2010.

Typically, upgrading reports is part of upgrading the Microsoft Dynamics NAV application. However, you can also import reports from .txt files or .fob files.

Importing RDLC 2008 Reports

If you import reports that have RDLC 2008 format from Microsoft Dynamics NAV 2013, then you must upgrade the reports to Microsoft Dynamics NAV 2013 R2.

Upgrading reports is part of the Upgrading the Application Code section of the upgrade process. Follow steps 1 through 5d in the Identifying Customized Objects topic to begin the upgrade process. Then export the relevant report objects, and import them into Microsoft Dynamics NAV 2013 R2.

The following illustration shows the upgrade process for the reports.

When you import the report, Microsoft Dynamics NAV automatically upgrades it to RDLC 2010. SQL Server Report Builder first validates that the reports have the correct RDLC 2008 format and then upgrades them to RDLC 2010 format.

In Object Designer, when the upgrade is complete, the Modified flag is set to Yes. All other properties for the report are not changed.

After the upgrade, you can open the layout in Visual Studio. For more information, see How to: Integrate Report Dataset Designer and Visual Studio Report Designer. You must compile the imported report before you can run it.

Importing RDLC 2010 Reports

You can import reports that have RDLC 2010 format to Microsoft Dynamics NAV 2013 R2. Upgrading the reports is an automated process. SQL Server Report Builder first validates that the reports have the correct RDLC 2010 format and then imports them.

In Object Designer, no properties for the report are changed.

Note : You cannot import reports from versions earlier than Microsoft Dynamics NAV 2013 into Microsoft Dynamics NAV 2013 R2. If you want to import a Microsoft Dynamics NAV 2009 report, you must first upgrade the report to Microsoft Dynamics NAV 2013, and then import it into Microsoft Dynamics NAV 2013 R2

How can I Reset the page Number for each group in rdlc reports

Please follow the below steps to get the page n of m for each page

Step 1:  Make sure there's a textbox in the report which contains the group expression

Step 2:  Add shared variables to track the current group and page offset

 Shared offset as Integer
 Shared currentgroup as Object

Step 3:  Add a custom function to set the shared variables and retrieve the group page number

 Public Function GetGroupPageNumber(group as Object, pagenumber as Integer) as Object
  If Not (group = currentgroup)
   offset = pagenumber - 1
   currentgroup = group
  End If
  Return pagenumber - offset
 End Function

Step 4: Use the function in the page header or footer

 =Code.GetGroupPageNumber(ReportItems!Category.Value,Globals!PageNumber)

Note:  Because this uses static variables, if two people run the report at the exact same moment, there's a slim chance one will smash the other's variable state  (In SQL 2000, this could occasionally happen due to two users paginating through the same report at the same time, not just due to exactly simultaneous executions)  If you need to be 100% certain to avoid this, you can make each of the shared variables a hash table based on user ID (Globals!UserID).

Error : while validating RDL content: Value cannot be null

Once you upgrade databse to  NAV2015,we need to create a service for the databse otherwise some times we may get the below error

Microsoft Dyanamics NAV
----------------------------

Error while validating RDL content:
Value cannot be null.

Parameter name: path1
----------------------------

To resolve this issue,we need to create a service name and check the service name effected to our database through file --> database information-> service name

Error: To upgrade reports, you must have Microsoft SQL Server 2014 Report Builder 3.0 installed.

Some times we may get the below error when we upgrade fron NAV2013 to NAV2015

---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
To upgrade reports, you must have Microsoft SQL Server 2014 Report Builder 3.0 installed.
Binary fields can't be upgraded.
---------------------------

Microsoft SQL Server 2014 Report Builder 3.0 will automatically install when you install NAV2015.
Some times  it may un install  by some one then we need to install the Microsoft SQL Server 2014 Report Builder 3.0 .

The history of Dynamics NAV / Navision

Read full story

Error: Form Transformation

While transforming form to pages from NAV2009 or NAV2009R2 we may get the below error

Error: Schema: \ApplicationObjects.xsd

Error: Form -2: The validation for file:///C:/Users/xxx/Desktop/NAV2009/TransformationTool/ApplicationObjects.xsd.tmp.xml failed. Detailed Information: LineNumber=69, LinePosition=14

Error: Form -2: The element 'Properties' in namespace 'urn:schemas-microsoft-com:dynamics:NAV:ApplicationObjects' has invalid child element 'Style' in namespace 'urn:schemas-microsoft-com:dynamics:NAV:ApplicationObjects'. List of possible elements expected: 'IndentationColumnName, Editable, ShowAsTree, InstructionalTextML, Visible, Enabled, GroupType, IndentationControls, Description, Name' in namespace 'urn:schemas-microsoft-com:dynamics:NAV:ApplicationObjects'.

Error: Some input file can’t be validated by schema. Please, correct it and rerun tool again

Solution:Transformation tool won't support form control properties like FontBold,FontItalic. so we need to remove before form transformation.

Test and fix dimensions before upgrading to NAV 2013

Please go through this link  from Gunnar's Blog

Virtual Tables in to NAV 2015

Virtual Tables in  to NAV 2015

Table No.	Table Name
2000000001	Object
2000000007	Date
2000000009	Session
2000000020	Drive
2000000022	File
2000000024	Monitor
2000000026	Integer
2000000028	Table Information
2000000029	System Object
2000000038	AIIObj
2000000039	Printer
2000000040	License Information
2000000041	Field
2000000042	OLE Control
2000000043	License Permission
2000000044	Permission Range
2000000045	Windows Language
2000000046	Automation Servers
2000000047	Server
2000000048	Database
2000000049	Code Coverage
2000000055	SID - Account ID
2000000058	AllObjWithCaption
2000000063	Key
2000000070	Error List
2000000101	Debugger Call Stack
2000000102	Debugger Variable
2000000103	Debugger Watch Value
2000000135	Table Synch. Setup

How to Find Currently Running Queries in SQL Server

Some time Navision will take more time when execute an activity like data up gradation etc. We are not sure the particular activity is going on or not,in this case the following script find out which are the queries running currently on your server and the status of our activity.

SELECT sqltext.TEXT,req.session_id,req.status,req.command,req.cpu_time,req.total_elapsed_timeFROM sys.dm_exec_requests reqCROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

  

 the output will shown like below

NAV 2015 - Cumulative update 4 Released

Microsoft Dynamics NAV 2015 Cumulative Update 4 has been released .Please find the link below


Build No. - 39663
Release Date - February, 2015
Local Version are AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK.

Download

Thanks

NAV2009 Reporting Error

Sometimes the following error may occur while designing RDLC Report

     “The provided metadata is not valid”

This error can happen when the following conditions are true:

You are using Windows Vista and User Access Control (UAC) is turned on.

• The executable file that runs the Visual Studio development environment (devenv.exe) is set to run as an administrator.
• The executable file that runs the Classic client with Microsoft SQL Server (finsql.exe) is not set to run as an administrator.
• To resolve this issue, either turn off UAC or set both finsql.exe and devenv.exe to run as an administrator.

To turn off UAC

• In Control Panel, select User Accounts.
• In User Accounts, click Turn User Account Control On or Off.
• Clear the Use User Account Control (UAC) to help protect your computer check box.
• To set a program to run as an administrator
• Right-click the .exe file, and then select Properties.

In the Properties window, on the Compatibility tab, in the Privilege Level section, selectRun this program as an administrator.

List of Eliminated or ObsoleteTables in NAV 2013

Table number	Table name
88	BOM Journal Template
89	BOM Journal Line
234	BOM Journal Batch
355	Ledger Entry Dimension
356	Journal Line Dimension
357	Document Dimension
358	Production Document Dimension
359	Posted Document Dimension
361	G/L Budget Dimension
389	Service Contract Dimension
473	Job Queue Response
700	BA Database
701	BA Db. Company
702	BA Db. Schedule
703	BA Db. Overview Line
704	BA Db. Numbered List
705	BA Db. Numbered List Value
706	BA Db. Dimension
707	BA Db. Dimension Relation
708	BA Db. Dimension Level
709	BA Db. Cube
710	BA Db. Cube Table Relation
711	BA Db. Cube Measure
712	BA Db. Cube Function
713	BA Db. Cube Dimension
714	BA Db. Virtual Cube
715	BA Db. Virtual Cube Member
716	BA Db. Virtual Cube Calc.
720	BA Advanced Setup
5106	Document Dimension Archive
5112	E-Mail Logging Semaphore
5113	Search Result
5114	Search Delimiter
5115	Search Detail
5116	Search Result Detail
5117	Search Word
5118	Search Word Detail
5500	Production Schedule Setup
5648	FA Allocation Dimension
6800	Employee Portal Setup
6804	EP Group
6805	EP Web Part Request
6806	EP WP Request Table Tab
6807	EP WP Request Tab Field
6809	EP WP Request Table Action
6810	EP WPR Table Edit Criteria
6811	EP WP Request Table
6813	EP WPR Table Action Filter
6815	EP WPR Header/Line Connection
6822	EP WP Request Table Sort Key
6824	EP WPR Header Create Criterion
6825	EP Temporary Filter
6827	EP WPR Field Lookup
6828	EP WPR Field Lookup Condition
6829	EP WPR Field Lookup Mapping
6832	EP WPR Table Filter Field
6833	EP WPR Table Filter Key
6835	EP SharePoint Image Path
6836	EP Search Table
6837	EP Search Field
6838	EP Search Display Field
6839	EP Search Configuration
6840	EP Group/User
6841	EP User Login
6842	EP User
6843	EP Search Result
6850	EP Caption
6870	EP Appln. Server Setup
6872	EP Trusted Site
7135	Item Budget Dimension
8000	Notification Setup
8001	Notification
8002	Notification Worksheet Batch
8003	Notification Worksheet Line
8004	Notification Line
8005	Notification Log Entry
8700	Mobile User
8701	Mobile Group
8702	Mobile Group User
8703	Mobile Document Group
8704	Mobile Document Type
8705	Mobile Document Queue
8706	Mobile Language
8707	Mobile User Windows Login
8708	Mobile Option Field Setup
8709	Mobile Option Field Caption
8710	Mobile Document Schema
8711	Mobile Document Type Schedule
8725	Mobile Sales Setup
8726	Mobile Customer Price
8727	Mobile Sales Activity
9801	Property Store
99008500	Inbound Sales Document Header
99008501	Inbound Sales Document Line
99008502	Inbound Purch. Document Header
99008503	Inbound Purchase Document Line
99008504	Inbound Product Catalog Hdr.
99008505	Inbound Product Catalog Line
99008506	Outbound Sales Document Header
99008507	Outbound Sales Document Line
99008508	Outbound Purch. Document Hdr.
99008509	Outbound Purch. Document Line
99008510	Outbound Product Catalog Line
99008511	Outbound Document
99008512	BizTalk Management Setup
99008513	BizTalk Partner Setup Header
99008514	BizTalk Partner Agreement
99008515	BizTalk Comment Line
99008516	BizTalk Partner Setup Line
99008517	BizTalk Request
99008518	BizTalk Suspended Queue
99008519	BizTalk Technical Notification
99008520	Agreement Type
99008521	BizTalk Message Check
99008522	BizTalk Doc. Receipt Check
99008532	BizTalk Partner Currency Map
99008533	BizTalk Reservation Entry
99008534	Outbound Product Catalog Hdr.
2000000002	User
2000000003	Member Of
2000000054	Windows Login
2000000061	User Menu Level