DIEF and missing DLL’s

I recently worked with someone who came from a cut-throat AX environment, and it made me doubly glad for the collaborative team atmosphere here. AX often seems to be trying to do one in as it is; we need all the people in our corner that we can get!

WE just worked an issue where DIEF was erroring out in a multi-server environment; it had never run in that AOS before. It took several of us to knock this ball out of the park. There is not one neat bow to wrap the solution up in, but here is the last piece of the puzzle, the one I am blogging because it might not have occurred to some of us:

If the Data import export framework (DIEF) complains “Could not load file or assembly ‘Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.”, then please consider putting it in the AOS bin folder. Unbelievably, that was the very last thing that got my DIEF working last night.

Happy DAXing! And love where you work!

Posted in AX2012, Data migration, Dynamics AX | 2 Comments

Five Good Minutes – PowerView, Odata, and Fantasy Football

So, does the ability to sell, translate to an ability to pick players for your fantasy football league? That is the burning question addressed by the latest Five Good Minutes With Microsoft Dynamics AX.

Oh, and also, it’s an excellent tutorial on viewing both AX data and data outside of AX, without the need to develop services or other, often costly, interfaces. This six minute video could save you HOURS of instruction and/or HOURS of creating alternate methods.

In short, Chad deftly demonstrates comparing AX data with Excel data, in a very familiar spreadsheet format. Go check it out, it’s the best one yet! And no, I won’t spill on the results!

 

Posted in AX2012, Dynamics AX, Video tutorials | Tagged , , | Leave a comment

Five Good Minutes – Project Module, Project Cubes, and Golf Courses

This week, Chad discusses accounting with projects. The project module is a scary unknown to many AX people, and this post demystifies much of it, and how it relates to fixed assets and budgets.

Chad follows a project through from creation to invoicing and more. Note that with projects, you can track hours and costs, as well as sales prices.

Of course this ends up in a Pivot table! 🙂

Although I am not quite sure when Chad practices golf… he and I have spent many late nights IM’ing work related stuff.

Enjoy!

Happy DAXing!

 

Posted in AX2012, Dynamics AX, Video tutorials | Leave a comment

Data Import Export Framework – using validation in insert/update

While using the DIXF (data import export framework) tool, I noticed that my selection to use business logic upon insert/update was not happening as I had expected it to. There were two reasons for this.

Class method DMFProductEntityClass.insertUpdate has as input parameters, two booleans called _callInsertLogic and _callValidateLogic. This is all well and good until you see that in line 121, super is called without passing those parameters. Super, which is DMFEntityBase.insertUpdate, certainly expects them as input. So, modify line 121 to pass the parameters. I only see this in the Product entity.

Second, there is a second place where you can and probably should select this option, to validate your data. It is under Entity structure, see screenshot:

EntityLogic

I hope you are enjoying the tool. It’s way better than anything we’ve had before!

Happy DAXing!

Posted in AX2012, Bug, Data migration, Dynamics AX | 2 Comments

Data import export framework error around InventTableModule

I’ve been having a blast with the new data import export framework (DIXF) tool. I’ve been making notes called Tips and Tricks in the hopes of sharing them on this blog.

But in the meantime, I encountered a bug today that I wanted to alert everyone to. All InventTableModule information, be it for Purchase, Sales, or Inventory, goes to the Purch record.

The same table occurs three times on the query, so it always gets the first. We wrote a workaround by using the “occurrence” parameter in the QueryRun.get() call. Please see specifics below.

InventTableModuleBugFix

Happy DAXing!

EDIT: Upon investigation, it was found that this error occurs on an update but not an insert.

Posted in AX2012, Bug, Data migration, Dynamics AX | 6 Comments

Five Good Minutes – Cube Data, Power Pivot, Role Centers and Vacation

Chad has released his fourth video blog; this one called
Five Good Minutes – Cube Data, Power Pivot, Role Centers and Vacation

In it, Chad demystifies several scary terms: tables, queries, views, perspectives, cubes. (Well, ok, if “tables” scares you, then maybe you stumbled onto this blog by mistake.) He talks about how to connect to the cube data through Excel, then create a PowerPivot report with the cube data. He then completed the circle by saving the report into a role center. All in just a few minutes.

Chad’s accountant/CFO slip is definitely showing! But don’t let that intimidate you non-bean counters: it shows how easy it can be to vastly extend AX functionality!

 

Enjoy, and happy DAXing!

Posted in AX2012, Dynamics AX, Video tutorials | Leave a comment

Five Good Minutes – “Nerd” Alert Rules in Microsoft Dynamics AX 2012

I’m happy to screen the third installment of “Five Good Minutes” for you!

Chad’s intro:
In this new episode of “Five Good Minutes” consultant Chad Carnes demonstrates the power of alert rules in Microsoft Dynamics AX 2012. Follow along and learn how you can create alert rules to help you proactively manage your business or department.

My take:
Chad is correct that these days, you need to be proactive rather than reactive to run a business. Alerts are an excellent tool for doing this – and they are so easy! There are many options for receiving alerts, and for determining what you should be alerted on. I recently set up an alert for a customer on a direct ship purchase order. The possibilities are endless! Do play with them and see their many benefits. My customers rely on them.

The video:

Happy DAXing!

Posted in AX2012, Dynamics AX, Video tutorials | Leave a comment

New ERDs for AX2012 R2!

Microsoft has heard our pleas!

I think we’ve ALL been working up our own versions of ERDs for the normalized 2012 tables, to try to get a grasp on the total rearchitecture that happened. So I was over the moon to find the below post from Microsoft today!

We’ve launched a new site that hosts 30 database entity relationship diagrams for tables of Microsoft Dynamics AX 2012 R2: AxERD.
Check it out here: http://www.microsoft.com/dynamics/ax/erd/ax2012r2/

Check out the introductory blog post here: http://blogs.msdn.com/b/x/archive/2013/05/23/announcing-the-axerd-website-for-dynamics-ax-2012.aspx

HOORAY to Microsoft for listening to us!

Happy DAXing!

Posted in AX2012, Dynamics AX | Leave a comment

Microsoft Corp. Announces mcaConnect Winner for Industry Partner of the Year Award 2013

I am so thrilled to announce that my company has won Microsoft’s consolidated Dynamics Partner of the Year Award this year! No more breaking it down by industry, vertical, etc. I’ll let mca’s press release speak for itself.

MCACONNECT, LLC LOGO
Microsoft Corp announced mcaConnect WINNER of Dynamics Industry Partner of the Year Award 2013. Check out our official press release at http://www.prnewswire.com/news-releases/microsoft-corp-announces-mcaconnect-winner-for-industry-partner-of-the-year-award-2013-208318461.html or visit our website at http://www.mcaconnect.net/blog/.

Happy DAXing!

Posted in Dynamics AX | Tagged , , , , | Leave a comment

One does not simply… meme for AX development

Happy Friday!

We take a break from our regularly scheduled video posting, to insert a little Friday levity. Our company’s meeting today was around best practices. A coworker was IMing me about memes – he particularly requested the “I can haz” meme, but I just couldn’t do anything with it. Jesse, hope this is satisfactory!

oneDoesNotSimplyBPDeviationDocumented

Happy DAXing!

Posted in Best practices, Dynamics AX, Humor | Leave a comment