Adding the Update operation to the Inventory Counting Journal Document Service

Hi guys, it has been for a while since last post. The year 2014 is comming to an  end and looking back it could be said that it was a really interesting year. I achieved to improve my German but also took on a new position and now I am working for one of the leading german clothing brands company with Microsoft Dynamics Ax 2012 R3 on the Retail Module.

Let's start with the purporse of this post. How to add the Update operation to the Inventory Counting Journal Document Service.

By default Microsoft has only provided the Create operation and it would be really interesting to have also the Read operation in order to create a Inventory Counting Journal on the system and send it through AIF but also the Update operation so we can receive back this Inventory through AIF in order to update the journal and post it.

The Inventory Counting Journal

We can find the Inventory Counting Journal on Inventory Management, Journals, Invent Counting, Counting. I think I have not to speak too much about it. The purporse of this post is to create manually a Inventory Counting Journal, send it out with AIF (We will add also the find and read operations) and receive the counted Inventory Counting Journal with AIF.

We have to setup the default Inventory Counting Journal for AIF on the Inventory and Warehouse Parametes, AIF Parameters section.

In order to update the standard Document Service Invent Counting Journal with the read, update and additional operations we use the Update document service  Wizard that we can find on Tools, Application Integration Framework, Update document service. 

Here provide we the name of the Service class InventCountingJournalService and we activate the service operations read, update, find, findKeys, getKeys and getChangedKeys. We activate also "Regenerate date object classes" and "Update AxBC classes". We click on OK and the Wizard will update the Document Service classes with the new operations.

We need also to update the Document Service Query AxdCountingJournal and set the "Update" value to "Yes" on the Query Data Sources InventJournalTable and InventJournalTrans because we want to be able to update data.

Also on the JoinMode of the InventDim datasource we change it to "OuterJoin" cause we want to be able to work with XML Messages which contain not info about the InventDim record. If we don't change the property, the Query will return nothing because the InnerJoin with the InventDim table.

Next, we need to add the new operations on the InventCountingJournalService Service. On the InventCountingJournalService, we make right click and in the node Operations we add the new operations.

Then, we have to refresh the service in order to update the new operation definitions. We make right click on the InventCountingJournalService, select Add-Ins and then on Register Service. Select the InventCountingJournalService and then click on Refresh in order to update the new operations on the service so they could be used on the outbound and inbound ports.

Next we need to check on the class Axd<Document> (AxdCountingJournal) and on the service class (InventCountingJournalService) if the corresponding operations methods are implemented.

On the AxdCountingJournal class we check the methods:

1. findEntityKeyList
2. findList
3. getActionList
4. read
5. readList
6. update
7. updateList

On the InventCountingJournalService class we check the methods:

1. find
2. findKeys
3. read
4. update

In all these methods we sure make sure that there is not an error line code with the "Operation not implemented" message and in that case we should modify the code in order to implement a call to the base clase like this:

Next we make some code customizing on the Document Service classes in order to make possible the update operation with the Inventory Counting Journal.

In class AxdCountingJournal class we realice the following updates:

We add a new "createRecord" global variable to be used to control if we are creating a new record or only updating an existing one.

We modify the prepareInventJournalTrans method in order to have a code like the following:

On this code update, we check if the InventJournalTrans record already exists on system. If not, we set tup the createRecord global variable to true. Otherwise, we are updating the record and we take the actual value of the Qty field from the InventJournalTrans record because maybe this line was already counted (the Qty field have the difference between on hand and counted and is the posted qty on the InventTrans) and we also set up the proper InventDimId value on the InventJournalTrans record.

In the class AxdCountingJournal we modify the method prepareForSave with the following code in order to avoid the increase of the total number of lines in the journal. 

Configuration of the Outbound AIF Port

As we have also implemented the methods "Read" and "Find" we could create an outbound port in order to send out a XML message with the content of an inventory counting journal. We could use this message to send the Inventory Counting Journal to an external application which the proper Hash code that we need later when we build the incoming XML message.

Below the configuration of the outbound port

And the generated outbound XML Message:

Configuration of the Inbound AIF Port:

Below the configuration of an Inbound Port in order to be able to process incoming XML messages with the Update operation.

And the corresponding XML message with the Update operation:

Details about the update operation and implications with the Hash Code concept

Within the outbound and inbound messages finds itself the element “_DocumentHash”. When data is updated using AIF, the document hash is required. When data is read, AIF returns the document hash field “_DocumentHash”. This field contains a hash of all the RecId and RecVersion values for each record that is returned. In this example the records that are returned are a Invent Counting Table, the Invent Counting lines but also maybe the Invent Dimensions if we provide them.If the data change before the AIF response, the hash will be different and the response won´t be able to be processed correctly. Below a Microsoft link with an explanation of this concept:

http://msdn.microsoft.com/en-us/library/cc639058(v=ax.50).aspx

Using the Microsoft Dynamics Ax Trace Parser to understand and be able to modify correctly the AIF artifacts

Understanding the AIF classes and where to add or modify code is not an easy task. There is not a lot of documentation about. A good source is the document "AIF Stuff" that we cand find here:

http://www.iali.co.uk/download%5Chide%5CAX5%5CAIF%5CAIF%20Stuff.pdf

Another great resource to understand AIF classes is to use the Microsoft Dynamics Ax Trace Parser. We have only to generate a trace when we realice and update operation and study the code to understand what we have to do to properly implement the operation.

The trace could be generated on a Job that calls the AifInboundProcessingService in order to process manually the incoming message with the Update operation.

This generates us a trace file that we can open with the Microsoft Dynamics Trace Parser so we can start researching the executed code.

Possible AIF Exceptions that could appeard while testing the new Update operation on the Inventory Counting Journal

Lastly I want to provide a list of possible AIF Exceptions that could arrise while implementing the Update operation on the Document Service.

Counting journal outbound is not supported.

This message will appear if the corresponding operation (Method findEntityKeyList, findList, getActionList, read, readList, update or updateList in class AxdCountingJournal) is still not implemented on the class AxdCountingJournal (Methods findEntityKeyList, findList, getActionList, read, readList, update or updateList),  or in the class InventCountingJournalService (Methods find, findKeys, read or update)

There is no service with namespace = 'http://schemas.microsoft.com/dynamics/2008/01/services' and external name = 'InventCountingJournalService'.

This message will appear if we have not correctly written the service name on the incoming XML Message. A look on the AIFService table will provide us the correct service name.

Cannot process duplicate message. Message {A8EF6A9C-E84A-4FCB-8813-0DBCB34BE2FA} has already been processed and is different from the new message.

This message will appear if we provide an incoming message with a MessageId with a GUID already provided. We should provide always a new GUID or establishing the EnableIdempotence property of the InventCountingJournalService update operation to “No” if we want to provide repeated values for MessageId.

No default inventory counting journal name is specified in AIF parameters

We should provide a default journal name for inventory counting journal on the AIF parameters on the Inventory Management parameters. Not confuse with the inventory management parameters default inventory counting journal.

Inventory dimension Site is mandatory and must consequently be specified.

This exception happens because the service was only implemented for the “create” operation. On the AIF Document Service classes we should assure that on the update operation the InventJournalTrans get the right InventDim as described on this post.

The request failed with the following error:  The document hash does not match the hash in the XML. The document may have been changed since last read

With the “update” operation we should provide a document Hash on the incoming XML message. This Hash is calculated using the values RecId and RecVersion from all the records that are sent or received through AIF. We must be sure about which records are we sending back (InventJournalTable, InventJournalTrans and maybe also InventDim).

Cannot create a record in Inventory transactions originator (InventTransOrigin). Reference: Counting, 00031. The record already exists.

This error should happen because the service was first implemented only for the “create” operation and when an second incoming XML Message which reference to the same InventJournalTrans record arrives. Then the system tries to create again an InventTrans for the counted quantity. The problem it is solved with a little of code on the AIF Document Classes as stated on this post.

Ok that is it! It remains only to wish you all a Merry Christmas with your family and a happy new year! 2015 seems to be pretty amazing. In Germany lot of companies are moving to Microsoft Dynamics, specially the Retail companies and the next version of Microsoft Dynamics Ax with the exciting new HTML interface will make presence.

Ich wünsche euch Frohe Weihnachten!!!!

Microsoft at CeBIT 2013 (Hannover)

Hi again! Last saturday I visited for first time the trade show CeBIT in Hannover (Germany) and I want to give my short impressions about what I have seem there.

Our company MODUS Consult AG was there as Microsoft Partner and I hope you where there to look for our services with Microsoft Dynamics Ax, Dynamics Nav, Qlikview BI or ELO Document Management Software between others.

Lots of germans companies are using or moving to Microsoft Dynamics ERP products (Nav/Ax). In fact Dynamics Ax 2012 is already finally considered a real alternative to SAP by bigger german companies and not only for the middle sized.

For my experience german companies are very cautious with their ERP selection so this demostrate the confidence of the market in the Microsoft ERP products.


But in this post I am not going to talk to much about about Microsoft Dynamics Ax but on the surrounding products that Microsoft have recently delivered or is going to deliver. That is Windows 8, Windows Mobile 8, Microsoft Office 365, Microsoft Sharepoint 2013 and Windows Azure.

Much have been written about the decadence of Microsoft in the Internet/Mobile/Cloud era but Microsoft have reacted quite well to this wave that was comming. Microsoft have reacted and now is time, for us, as professionals to react as well and use this technology that Microsoft put in our hands.

Windows 8

From my experience as IT Manager in Spain where I had to make the most with the less money possible I am not what we should call a technology geek. I like to use something that works the most time possible so I can save my company's money and time. So I was not really convinced about Windows 8 not even the version Windows RT.

Using the new Windows 8 in the Microsoft Surface Pro tablet is really a good experience and the keyboard is simply cool. I could imagine myself working in the train ICE to Berlin with this tablet. I actually own a Galaxy S Tablet and Microsoft Surface could be used both for working and pleasure and not only the last as I do with my actual tablet.

About Windows RT version tablet there is another story. It is cheaper but the operating system is quite limited. You can only install applications that come from the Windows Store and not normal Windows applications. That could be a limit. But on one of the sessions I have seem a really good use that this tablet can provide.

The fact that you can not install to much applications can make this device more secure and with the use of VDI (Microsoft Virtual Desktop Infraestructure) companies can provide a secure way to provide mobility to their workers. Users can use their normal applications on mobility but as nothing is installed in the device the security is less compromissed. This could be a second life to a device that seemed to be dying before being delivered to market.

 Windows Mobile 8

I am also a mobile developer since the J2ME era and I have developed some applications for general J2ME devices, Blackberry devices and lastly some general sites with JQuery Mobile. So I like to keep up to date with the last mobile technologies. I actually also have a Galaxy S android device and I was also not very much convinced about Windows Mobile 8 before playing with it. I had the opportunity to play with the latest models in the trade show and I was finaly convinced. It is a cool operating system and as I like to develop with .NET so I found this a really good platform. Blackberry new Z10 was also available on the trade show but it not attracted not too much attention so the mobile market remains between the 3 players Apple, Google and Microsoft. On the way Microsoft gave a second opportunity to Nokia.

 Microsoft Office 365

We are heading to the Cloud era and Office 365 is one of the steps of Microsoft in this area. Sooner or later almost everything would be on the Cloud so better that we start getting used to this. It is very cool to have your office documents available to work with from whatever device you have and from whatever place. One of the demostrations I could take place was a video conference between 2 tables using Lync and sharing and working with a sharepoint presentation.

You could try by yourself at Microsoft Office Website.

If you are still not prepared for the cloud Microsoft have released the Microsoft Office 2013 as installables as well.

Windows Azure

 I had the opportunity to attend a MSDN session about developing mobile application with Windows Azure. The cloud solution from Microsoft and I found really cool as easy you can create a new mobile applications on the cloud, setup its database and start coding it on Visual Studio to start producing functionality to your users. We are heading to the cloud world and even probably next versions of Dynamics Ax would be cloud based so better that we get used to the technology. Microsoft lets you try the technology for free and start coding in the cloud.  Here you can see an example video of how creating mobile applications with Windows Azure.

Developing Mobile Solutions with Windows Azure Part I (MSDN Channel9 video)

 Definitedly we are heading to the Cloud but for critical software as an ERP we have still questions to solve like where the data is, security, how I could recover my data if the provider goes bankrupt, etc.

Microsoft Sharepoint 2013

And last something about Sharepoint 2013. Also looks great. Microsoft have continuosly improved its Sharepoint products. I have worked with versions 2007 and 2010 and between both I have seem an improvement and this time Microsoft has also delivered a really good worked product. New features would be a more social intranet, a better workflow module and better mobility providing menues really touch oriented.


As we seen Microsoft have reacted energically in all the fronts with new products. We have also not mentioned SQL Server 2012 and Windows Server 2012. Systems in which we are already working with our last Dynamics Ax 2012 R2 solutions. So there is a new of technology available and now we should start working and apply this technology in our companies or customers to start helping them to move to the new IT era that is just now here where information but also processes are not just on your computer but everywhere. It is indeed a very interesting time as IT professional.


That was all for today! For next time I have something really interesting on mind. Since some time I wanted to develop mobile solutions for Dynamics Ax using JQuery Mobile so what I will do is to create a small project using Microsoft Dynamics Ax 2012, ASP.NET MVC 4 and JQuery Mobile. This will take some time and I will create a CodePlex project so everyone can take a look at the project and I will create several posts as the project advances so you will be able to see how this solution advances from concept to implementation :-)

Last a photo I took also on CeBIT about of one of the reasons one can have to move to germany. Where else you can drive a BMW at 200km/h (124mi/h) on the highway? :-) 

And believe me, it is not dangerous and quite pleasant!