Thursday, 25 August 2016

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

 



Monday, 1 August 2016

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


Tuesday, 19 July 2016

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)

Monday, 4 July 2016

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.


Thursday, 5 May 2016

Why Switch to the Microsoft Dynamics NAV 2016 Web Client?




Did you know that with Microsoft Dynamics NAV 2016 Microsoft has begun the journey of transforming the Web client into a first-class interface for desktop users?

Read the complete post here




Tuesday, 3 May 2016