Wednesday 31 August 2016

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.

Thursday 25 August 2016

Error while Importing Contoso Data in AX 2012 R3


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

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


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