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.

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.

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: 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.