“I need a report for that” – maybe not! Please see installment 2 of Five Good Minutes with Dynamics AX. I learned on this filtering, and even attempted to use it on a request I got! đ
Â
Five Good Minutes – Dynamics AX 2012 Grids, Filters, and Role Center Cues
Happy DAXing!
I’m so excited to share word of my colleague Chad Carnes’ new video series “Five Good Minutes in Microsoft Dynamics AX.”
Chad shows AX users how to make things they do or need to do, easy! With my years of AX, I’m even learning some pointers.
The first in the series is about PowerPivot, SharePoint, and Role Centers – but my advice – don’t try the SQL at home! Leave that to us developers to muck up! đ
Thank you for making AX easier, Chad!
Happy DAXing!
I recently had the opportunity to introduce the “inside team” at my client to the new Data Import/Export Framework (released on InformationSource), and we were all very pleased with the results.
The class consisted of a Project Manager, production consultant, and technical lead. I spent Tuesday morning instructing them, then told them to go try it. They divvied up the work and long before end of day Wednesday, they had successfully migrated customers, vendors, and items!
We added custom fields to existing entities. We learned lots of troubleshooting. One of us created a custom entity, but someone forgot to teach the PM to compile his code. đ
We are very, very hopeful for the possibilities of this tool! Can’t wait to start doing header/detail (read: transactional) data, and adding setup tables.
Happy DAXing!
Our application consultant came to me wanting to update custom fields which had been added to the InventSerial table.
He could pull the data down to Excel, but couldn’t push it back up to AX.
The first step (with thanks to http://dynamicsuser.net/forums/p/57272/307667.aspx#307667) was to add parm methods to the AxBC table class.
Yet that didn’t solve it, so I researched further and found that InventSerial table is part of the InventASNService.
Then I added an inbound port using that serviceâs operations (click screenshot) and activated the port.
Then I published data from excel to ax.
Happy DAXing!
A client had reported this issue to me, but it magically self-resolved. Time constraints being what they are, I didn’t get back to it. But this morning, a second client reported it. I was sure it was data. Close. It was setup. Here is the solution I sent my functional consultants.
Itâs a setup issue.
Make sure this box is unchecked at the time of PO creation and it wonât be doubled.
PO 84 in test is an example of a doubling:
So I unchecked the box (in both test and prod so we donât get bit later), created PO 104 with the same items, and it prints fine:
Whereas (itâs important to note) 84 still prints badly:
If the images don’t come out well; I apologize; click on the pictures. Way too many balls in the air to debug blogging!
Happy DAXing!
Janet
Blogging this so that I don’t forget it yet again.
The users logged into a new AX 2012 CU3 environment, and got this error when they tried to run the Purchase Order, the bane of 2012, it would seem!
“Exception has been thrown by the target of an invocation.”
The fix is simple – for every user, go to “Tools > Options > Development > General” and UNCHECK the “Execute business operations in CIL” box.
Presto.
Happy DAXing!
Sitting at the airport, waiting for a late incoming plane, thought I would put these together.
Â
2012 professional lessons learned
Â
–Â Â Â Â Â Â Â Â Â Life is fluid; flexibility is key
–Â Â Â Â Â Â Â Â Â Software release = new bugs (we already knew that, but this year emphasized that, did it not?)
–Â Â Â Â Â Â Â Â Â There are some really cool tools out there (for example, just a start, https://informationsource.dynamics.com/RFPServicesOnline/RfpServicesOnline.aspx )
–Â Â Â Â Â Â Â Â Â The business is tailored to the go-getter (unlike other softwares out there)
–Â Â Â Â Â Â Â Â Â If youâre smart, youâll learn from othersâ mistakes (example http://www.computerworld.com/s/article/9235213/Avanade_sued_over_alleged_ERP_project_failure )
–Â Â Â Â Â Â Â Â Â RF is a headache even with MS support (same reference)
–Â Â Â Â Â Â Â Â Â True geeks love sharing their knowledge (evidence the number of quality blogs out there)
–Â Â Â Â Â Â Â Â Â OTOH, people will wh_re themselves over a Dynamics AX 2012 book (youâll have to find that yourself)
–Â Â Â Â Â Â Â Â Â âPurchase order stack trace errorâ â themâs fighting words!
Â
Happy DAXing!
Up till now, when I did a full CIL generate and it didn’t work, I knew I had an error in my AOT compile. But that takes forever. Found a GREAT shortcut today.
Â
http://axfaq.blogspot.com/2012/07/cil-generation-ax-2012-error-when.html
Â
Thanks to Julian!
Â
Happy DAX’ing!
Just a quick note on a problem I just worked around.
My grid fields wouldn’t sort. You click the gray heading bar, and they pretend they sort, but they don’t.
My main form data source was table A. I also had table B joining to A, table C joining to B, and table D joining to C. The grid datasource was A. Only the fields in the grid which were from datasource A would sort – and it took me a while to realize this, because I’m not really displaying fields from that table.
Once I figured out they must be on A to sort, I tried putting methods on table A to retrieve the data from B, C, D – but those didn’t sort either. Had to actually be fields. (Hm, I wonder if methods on the datasource would work?)
Not a big deal to me to add fields, since A is a temp table. But I can see this being problematic in other situations. I welcome input.
Happy DAXing!
janeteblake 