Cumulative Update 42 for Microsoft Dynamics NAV 2013 has been released (Build 46772)

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013, including hotfixes and regulatory features that were released in previous cumulative updates.

This cumulative update replaces previously released cumulative updates. You should always install the latest cumulative update.

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For a list of cumulative updates released for Microsoft Dynamics NAV 2013, see released cumulative updates for Microsoft Dynamics NAV 2013  . For a complete list of all hotfixes released in cumulative updates for Microsoft Dynamics NAV 2013, view the following CustomerSource and PartnerSource pages:

CustomerSource

Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013

Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

PartnerSource

Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013

Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2013.

Important

We recommend that you contact your Microsoft Dynamics Partner before you install hotfixes or updates. It is important to verify that your environment is compatible with the hotfixes or updates being installed. A hotfix or update may cause interoperability issues with customizations and third-party products that work with your Microsoft Dynamics NAV solution.

New and updated capabilities in the August update of Project "Madeira"

The latest update of Project "Madeira" adds new capabilities as

Smart notifications give you advice and recommendations

With this update, we'll notice such notifications display when we create a sales invoice for a customer that has an overdue balance, or when the amount in the sales document exceeds the credit limit specified for the customer.

 For more information, see Smart Notifications

 

Introducing the new Sales and Inventory Forecast extension

In this update, MS introduced the new Sales and Inventory Forecast extension that gives us insights about potential sales and a clear overview of expected stock-outs. The extension uses Cortana Intelligence to predict future sales based on our sales history to help us avoid inventory shortage.

 For more information, see Sales and Inventory Forecast.

Smarter sales and purchase documents

MS had made several small but important improvements to sales and purchase documents:

 

We can cancel posted credit memos.

Sales invoices include Package Tracking No. and Shipping Agent Code.

We can cross reference items.

We can substitute items.

Error while Importing Contoso Data in AX 2012 R3

Description:

Getting below error while importing the Contoso Demo Data to Dynamics AX 2012 R3 with "Dynamics AX 2012 Test Data Transfer Tool (Beta)".

Command used as per below link is

https://ax.help.dynamics.com/en/wiki/walkthrough-import-demo-data-for-ax-2012-r3-by-using-the-test-data-transfer-tool/


[DP.exe IMPORT D:\DynamicsAXR3DemoData MicrosoftDynamicsAx]


Error message is:


A connection with the  Server=GGK-DYN-001 cannot be established. Please check the Server is accessible

Unhandled Exception: System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.

   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

   at Microsoft.Dynamics.AX.Dataport.Extensions.<ExecuteLater>d__10`1.MoveNext()

 in e:\bt\110700\Source\DataPort\Dataport\Library\Extensions.cs:line 230

   at Microsoft.Dynamics.AX.Dataport.SqlHelper.<GetAllDatabases>d__22.MoveNext()

 in e:\bt\110700\Source\DataPort\Dataport\Library\SqlHelper.cs:line 846

   at Microsoft.Dynamics.AX.Dataport.SqlHelper.<GetAllConnections>d__18.MoveNext

() in e:\bt\110700\Source\DataPort\Dataport\Library\SqlHelper.cs:line 800

   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()

   at Microsoft.Dynamics.AX.Dataport.DataportApplication..ctor(String server) in

 e:\bt\110700\Source\DataPort\Dataport\Model\DataportApplication.cs:line 38

   at DP.Program.Execute(String currentDirectory, DataportDirection direction, String directory, String database, String server, DataportAction action) in e:\bt\110700\Source\DataPort\DP\Program.cs:line 108

   at DP.Program.Main(String[] args) in e:\bt\110700\Source\DataPort\DP\Program.cs:line 82


and the Data Transfer Tool stopped with below screenshot.

Solution:

Add Server name (instance name also if you have) to DP command like


[DP.exe IMPORT D:\DynamicsAXR3DemoData MicrosoftDynamicsAx GGK-DYN-001\MSDYAX]


Where GGK-DYN-001 is Server name and MSDYAX is Instance name

 And it starts importing

Item Inventory Posting in Project Madeira

We may need to add inventory to item in many cases. How do we add Inventory to Item?

By posting Purchase order or Item journal.

Now, we have a smart way to add inventory in Project Madeira.

Go to Item List and Create a New Item

1001 – Test

Check the Quantity on hand and Item Ledger Entries for the Item

Now click on the arrow > of field Quantity on Hand

It will open a new page “Edit – Adjust Inventory”

Enter value in New Inventory (ex: 10)

Click OK

If there are any errors in posting the inventory then it will show error as below

Correct the error and redo the process

Now Inventory is available as shown in field “Quantity on Hand”

Open Item ledger entries and there will be an entry with positive adjustment

Now go back to same “Edit – Adjust Inventory” and reduce the quantity (ex: 7)

Click OK

Now the inventory is become 7

Open Item Ledger entries and we have new negative adjustment entry with Quantity 3

Error compiling dynamic control expression

We are getting below error while opening a page like customer card in Navision

Description:

 

Error compiling dynamic control expression: ‘GS45Active or GS48Active’ at index ‘11’. The error is: End of expression expected.

 

 

Reason: 

 

If we add multiple Booleans  in visible or any other property of any field in page like (GS45Active or GS48Active)  or (GS45Active and GS48Active) then we will get this error

Solution:

 

Make sure that operation characters are in capital like

(GS45Active OR GS48Active)  or (GS45Active AND GS48Active)

Interne fout 3 opgetreden in module 9 (ENU=Internal error 3 in Module 9)

While Converting the Microsoft Dynamics NAV 2009 R2 or SP1 database to a Microsoft Dynamics NAV 2013 database we are getting the below mentioned error message

Description:

Interne fout 3 opgetreden in module 9(ENU=Internal error 3 in Module 9)

Problem signature:

Problem Event Name: NavisionInternalError

Problem Signature 01: Dynamics NAV Development Environment

Problem Signature 02: 7.0.44969.0

Problem Signature 03: 3

Problem Signature 04: 9

OS Version: 6.1.7601.2.1.0.272.7

Locale ID: 1043

Reason: 

It is related to the binary format saved in the field type RecordID

some binary values in the field type ‘RecordID’ are causing a buffer overflow while reading them, most probably while storing these values in the older version the validation did not run properly, and we got some wrong values in that field.

Solution:

Export the data 

Fix the wrong data 

Import the data

Run the conversion again.

Congratulations 2016 Microsoft MVP!

Just got my MVP Award for the fifth time.. Thanks Microsoft!!!