Dynamics NAVAX

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

I had to prove a concept the other day to embed google maps in a form. A big of googling and some ideas that had to mash up. Create a form with an ActiveX control “Microsoft Web Browser”. On the init method after super call. Add this line. ctrlactiveX.Navigate(' https://maps.google.com.au/maps?q=1 St Georges Terrace, PERTH WA 6000+(This is a random place)&output=embed' ); Final result looks like this. Reference: Thanks to this blog. http://microsoft-dynamics-ax-erp.blogspot.com.au/2012/01/integrate-google-map-in-dynamics-ax.html Minor change I had to make was to figure out the URL parameters. By passing the output=embed, you get a pretty good result.

Product attributes is a great piece of functionality that was introduced in AX 2012. It allows you to set up and capture additional information against a product. I recently have taken it one step further to make it more visible and user friendly. At the moment it is hidden away on a form you have to open. In a similar fashion to the way financial dimensions work, where the controls dynamically show up on a fast tab. The attribute controls do the same. Here is a quick screenshot to show how powerful it can be. I got the field groups to work by using attribute groups (which is part of retail key). If you are looking for some info on product attributes have look at these links. http://technet.microsoft.com/en-us/library/hh227548.aspx http://www.slideshare.net/murrayfife/using-product-attributes-to-record-nutritional-information-part-1 http://dynamicscare.com/blog/product-attributes-in-ax-2012 This is one of many pieces of frameworks that AX 2012 provides. Its up to us to make ...