Friday, January 20, 2017

Dynamics 365 for Operations Filtering grid changes from AX 2012

Those who have used Dynamics AX for years may be experts in the ways to filter data via a grid and export to excel for ad hoc reporting. Its a significant value add process which many cannot live without. Then you jump to Dynamics 365 for Operations and its likely blank stares when it comes to filtering...

The client experience has changed dramatically from AX 2012 to Dynamics 365 for Operations (use #D3FO on twitter for this name). From a 32-bit desktop client to embedded web client. That transition required form controls to change and thus how filtering occurs.

So the ultimate question: How do you filter grids in Dynamics 365 for Operations?

Refer to the following documentation for these changes: https://ax.help.dynamics.com/en/wiki/filtering-in-dynamics-ax-7/

This documentation is fluid so please check it out for the latest information. The below is reposted and summarized for point in time reference and quick reference (for me).

Here are the operations for using a the Filter Operator vs the AX Query Syntax method (e.g. "advanced query" or "Crtl+G on grid and 'X..Z'").

Figure 1 - Filter expressions 'Filter Operator' vs 'Dynamics AX query syntax'

Its very important to note that '*' will literally look for an asterisk in the name. So you don't need that. The commands are more literal and in a natural language rather than syntax. It may seem to take longer to adapt but you'll adapt quicker than you think if you go into it with an open mind.

Hopefully that helps!

Saturday, January 14, 2017

Dynamics 365 and you for 2017: Helpful hints, insights, and resources

Dynamics ERP friends,

Microsoft is on the move quickly with their ERP systems. Time is changing and so is the Dynamics world. Here are just a few things I want to note for this year. This is my informal, full of information/opinions/suggestions/humor note for 2017. 

Big Milestone
First and foremost, I greatly appreciate everyone who reads my blog even in passing. Its a fun and creative outlet for me to grow and the fact it helps people helps motivate me to keep it going.

I recently hit 1 million page views on my blog. Yay! [smiley face with party hat]. No clue what I'll hit next year but I'm excited to find out.

New Roadmap Portal
For roadmaps in the past, there would be an image that Microsoft would often show at keynotes at Convergence which would get passed around and reposted. It was a static image with Microsoft working being a veil of mystery.

While the above still exists, there is now an interactive roadmap that shows more than just concepts; it provides deep insights into the entire Dynamics 365 suite. https://roadmap.dynamics.com/ You'll want to bookmark this site and keep up to date on what all is going on.

It breaks down 'What's New', 'In Development', and 'Previously Released' features for all of the Dynamics 365 products and modules within those products. Keep in mind there are two editions now: Dynamics 365 Enterprise (D365 for Sales, D365 for Customer Service, D365 for Field Service, D365 for Project Service Automation, D365 for Operations) and Dynamics 365 for Business (Dynamics 365 for Financials [SMB]). The Enterprise/Business is just a way to bundle the products between Enterprise level solutions and solutions for the SMB market.

Searching for things via search engines
Culturally, we have adopted 'Google' for searching much like asking for a 'Kleenex' for a tissue or a 'Coke' for a soda. 'Did you Google it' is significantly more common that 'Did you Bing it?'. I use 'Bing' in my demos and people snicker with the fan boy jokes flying. For better or worse, that's just how it is.   
Rumor has it, you will find more data on Dynamics 365 using Bing vs other search engines due to how Microsoft optimized the search engine and metadata or something. I don't know the details but its what I've heard from multiple people in different departments at Microsoft. My experience over the past 6 months verifies these claims. Maybe I do a side by side analysis post later this year??

Product education resources
While we're on the topic of search results, MSDN and TechNet were great resources for the Dynamics AX products. Give https://ax.help.dynamics.com/ a look. It is where all the newest information is going to be found and maintained. LCS is also a great spot to research potential issues without opening a ticket while also providing valuable tools for the lifecycle of your implementation.

One interesting note is its 'ax.help...' but AX is not the branding anymore, even though it does still cover AX products. I'm ok with that since my alias is DAX Dude and a number of companies have AX embedded in the name. I refuse to become D3FO Dude (pronounced as 'Dee-foh Dude'?). I'm officially DAX Dude, who works on D3FO.

Mobility and resource development
Mobility will be so important going forward. We are already seeing the beginning pushings for it in the Dynamics space. Cloud/browser based ERPs add significantly more value with mobile applications to supplement functionality. 

I'd recommend getting up to speed on how/why companies will use mobility and what technologies to start growing resources for. You can buy great resources for a premium, but if your company wants homegrown experts, the one thing you can't buy is time. Invest in your employees. Give them the resources to grow with the technology and innovate. Its one of the things I really love about the company I work for. Its not cheap but its worth it. Blue Horseshoe is hiring top talent btw ;-) Inquire within

Product Specific naming
Make a resolution to only refer to the products by the full name ('Dynamics 365 for Operations' or some abbreviation like 'Operations', 'D3FO', 'D3 for Ops', 'Ops 1611 (the version)', etc. Just saying Dynamics 365 will not fly. I talked to a sales person last year who really want to talk to me about a great ISV add-in for 'my Dynamics solution'. The conversation was literally: "Great! Which products is it for?" "Y'know, Dynamics... the Microsoft product?" [Looks at me all sketched out] "I'm good thanks! I'll check it out online" [Grabbed branded pen, product flyer, and walked away].

Also, the product should not be called AX 7 or AX when referring to the new version. This is the same transition as from Axapta to Dynamics AX. Now its Dynamics 365 for Operations. All the cool kids are calling it by the new name. You don't want to be the dude who says Axapta 2012 do you? Coincidentally, that's the same guy who orders the gluten-free wine or a gin and root beer with a celery stick at the bar... Don't those sound yummy? Don't be that guy :-)

Thanks everyone and have a wonderful start to 2017!!!

Look forward to seeing old friends and making new ones!


Friday, January 13, 2017

D3FO/AX 2012 Password field display control encryption explanation

I was in an internal meeting where new consultants were discussing functionality in the Dynamics 365 for Operations. One of the 'off the cuff' topics was that they were not sure why the password entered, which was three digits, looked like way more characters. Everyone in the room was assured that the password was saved correctly behind the scenes.

Its important to know why the system is functioning the way it is. Thought I share some info.

The reason why this is the case is that form object masks the password and encrypts it when its entered. The presentation of the field is a generic 'mask' as to not give any indication about what characters there are on the field.

Certain pieces of information can make things easier to hack such as:

  • Number of characters
  • Valid alpha-numeric characters
  • Valid special characters
  • Personal information about the user (birthday, street address, full name, pets, first date location, etc). 
  • Does the person care about security (will have a bad password more than likely...)
To prevent giving any information on the password, its a best practice, which is reflected in the control, to provide as little data as possible to the end user. If the field masked only the characters which were entered, I would know exactly how many characters I need to guess. Now its like playing a more complicated version of Wheel of Fortune with no characters revealed.

Also, you can't just go into the AX DB and pull the data out. Its stored encrypted. Nice try.


Figure 1- Password entered before it is saved into the DB
Figure 2 - Password entered after it is saved into the DB (field is not showing anything about data)

Thursday, December 15, 2016

AX Retail - Require the user to enter in a price for a zero priced item

In the event you have a zero priced item (intentionally or unintentionally), you may want the user to key in the price if its zero. This can be setup store by store and is located in the POS Functionality Profiles record.

Requiring the zero priced item to have a new price can be helpful at the beginning of a project, but can also create a lot of headaches so make sure you have a process in place to identify zero priced items rather than rely on this setting. It shouldn't be used as a catch all magic button for those issues.

I always struggle to remember where the setting is so I'm posting about it for next time I put it in the search engine.



Friday, November 11, 2016

Personal Windows OS toolbar overlaying full screen RDP session issue

This is a basic one folks but addressed something that was driving me NUTS.

I was using Remote Desktop Connection (RDP) and had the bottom of the screen cutoff by my actual physical desktop toolbar even when in full screen (Figure 1 below).

The fix, for me at least, was to go into the RDP settings, move the sizing from full screen to a fixed size, then move the slider back to the full screen setting (Figure 2 below)

I literally was doing all sorts of things before this to fix the issue with no success. It was the only thing that consistently addressed the issue.

Figure 1 - My desktop toolbar overlaying the RDP full screen session

Figure 2 - Adjust the display configuration

Wednesday, October 26, 2016

A guide to debugging the Microsoft Dynamics AX Debugger

Debugging the AX Debugger can be a little bugger'. Here are a few things to check for as to why you aren't able to debug some code.
  • Make sure your user is added to the Debugger group on the instance your in
    • IMPORTANT: You'll want to log out and back into your instance. This means actually logging out and not just close and reopen AX and/or the RDP session. 
    • This might be the issue if the debugger pops up but is greyed out and AX seems to have acknowledged the breakpoint but breezed right past it
  • Make sure your breakpoints are set and enabled and not 'disabled'. 
    • There is a button next to the set breakpoints in the toolbar that allow enable/disable
  • Assure the code where your breakpoint is is actually being hit.
    • This is a make sure its plugged in type response but you'd be surprised how common it is...
  • In your user options under Development tab, make sure the 'Debug mode' is set to 'When Breakpoint'
  • The breakpoint might be set in a spot that the debugger can't hit. For example, the clicked method on a button.
    • adding a line of code for 'breakpoint;' rather than using the red dot breakpoints will allow you to debug these methods
  • If the code is running in the CIL, you may need to make the code run on the client. 
    • Go to your user options > 'Development' tab and uncheck 'Execute business operations in CIL'. 
  • If the code is running in batch, you'll need to debug this process via Visual Studio. The breakpoints in AX are for client processes only generally. 
  • You may need to adjust the breakpoint check boxes in the Dynamics AX Configuration Utility under the Developer tab. There are two settings there: 'Enable user breakpoints to debug code in the business connector' and 'Enable global breakpoints to debug code running in the Business Connector or client'
  • Check the AOS debugger settings. Dont remember what this check box(es) are called but there is something on the AX AOS config that can be a factor. 

Friday, September 9, 2016

AXUG Summit 2016

This years Dynamics AX User Group (AXUG) Summit http://www.axugsummit.com/home in Tampa, FL from October 11th-14th will be great!

I'm presenting the below sessions there.

This year will be a vastly different experience for the presenters. ConferenceHarvester.com is being used and its pretty cool. It assures that all presenters are well prepared. There are even training videos about how to present. They'll also assist in sending out tweets during your presentation.

For the AX users, there will be significantly more speakers from Microsoft and AX customers over previous years, which tended to be partner heavy.

All in all, very impressed! Hope to see you there!