Dynamics NAVAX

This is only my opinion but I feel Advanced bank reconciliation has caused a lot of confusion. This is because Microsoft has made it very technical (very cool but a bit painful first time). Also, I feel some of the documentation is lacking in detail. Below is my quick summary for anyone who wants to start with this topic. To import a statement file: Official Microsoft Links http://blogs.msdn.com/b/axsupport/archive/2014/05/20/advanced-bank-reconciliation-setup-in-ax-2012-r2.aspx Supported formats are very limited. But the big one is the BAI2 is very common but not all banks use it. Good non Microsoft Links Same as the Microsoft one but with screenshots. http://andym62.blogspot.com.au/2014/06/ax2012-r2-import-bai2-bank-statement_30.html For developers who want to support different file formats. I would recommend using transformation class, rather than xslt. Follow this step by step in detail. You will want to extend on it to include additional fields etc but a very good start....

I still see code around that uses the Index Hint. We have to remember that it has been deprecated for a long time now and is ignored. http://technet.microsoft.com/en-us/library/dn507158.aspx Item Description Reason for deprecation This feature was rarely used. This feature began to create complications in the evolving development environment, so the feature was removed. Replaced by another feature No. There is no supported replacement for this feature. Modules affected This feature was not particular to any application module. Changes to installation This change does not affect application installation. Changes to upgrade Any legacy custom X++ code that uses the index hint clause still compiles and runs in Microsoft Dynamics AX 2012.

I will start backward. Show what the result is and then will go into what I did to achieve this. Lets say you want to filter the customer records based on the department dimensions that are assigned to the user logged in. This might include restricting the sales orders too based on those customers. Result Setup Create a new Organization hierarchy with the Security purpose assigned. Edit the hierarchy and add the departments you plan on using. Create a new security role and assigned organizations by specifically granting access to the departments. Technical Now for the technical aspects of this. I used security policies to achieve this result. xds temp table which I have a the code to build (explode) the departments into the temp table. Query which joins the customer table to the dimension tables so we can specifically get the Department dimension Class created a method to retrieve the Department dimension attribute recId New role which is a main driver of the roles...

This is an Idea and not something inside standard. Most people have used Data Import/Export Framework for importing journals. It has been a big help and in this post I will discuss an idea that I think Microsoft should consider to develop. I leverage the DIXF framework for importing a general journal and making it flexible. Below is a screenshot of how simple it looks. I got dialog front end that has been created to run DIXF entities both import from source to staging, then staging to target in one shot.  These are some additional considerations here for this to work: Default journal name  - this can be done by configuring the mapping from source to staging Default journal number – this is something to be done in code Default line number – this is something to be done in code Default currency from the company – this is something to be done in code or configuration. I prefer to do it in code. Default the dimensions – this is something to be done in code Clean up per...

Data Import/Export Framework (DIXF) is more than just initial data load tool. We have seen in the recent R3 release that Microsoft has extended the capability to include Master Data Management (MDM). Now I will talk about a common request. Request: CSV file is generated every day and saved to a directory. We need to process these files by importing them into AX. If it is successful move it to the Success folder, if it fails move it to the failed folder. Old solution without DIXF: Create a class that is batchable that reads from the folder and do all the coding for moving the file around etc. New solution with DIXF: Create a new DIXF entity to process the file. Make sure the Source and Staging fields line up.   In your staging to target – do all the work in the Generate method.   Then when you process the entity you can configure it to run on a directory. Lastly, schedule the staging clean up job. This ensures the staging tables are cleared up and it doesn't grow...

If you subscribe to the LCS blog you would have notices their recent release notes. http://blogs.msdn.com/b/lcs/archive/2014/08/08/august-release-notes.aspx One thing that caught my attention was the release of the 5 new vm deployments which are primarily around retail.

Dynamics AX 2012 has introduced the ability to transform an xml message using xslt. Refer to the technet article for more information on transformation of inbound ports http://technet.microsoft.com/en-us/library/hh352243.aspx Also see this nice blog post on importing bank reconciliation files using standard BAI formats  http://blogs.msdn.com/b/axsupport/archive/2014/05/20/advanced-bank-reconciliation-setup-in-ax-2012-r2.aspx Back to the topic - In this post I will show you how to debug and run the transformation in visual studio 2010. First thing you do is open up the xslt file with Visual Studio. You will see the xml editor tools on the toolbar. If you dont see it, then just right click the toolbar and add it by selecting the “XML Editor”. Now you can place a breakpoint in the document and click the start xslt debugging button (Alt +F5). First time you run it you will get to choose the input file. If you have run it before this will be defaulted. You can change it by goi...