AX2012–Search and you shall find….

I wanted my customers to experience the search powers of Dynamics AX 2012 and Microsoft SQL, and decided to create a very small generic tool for finding items and products.

Suppose a user wishes to find an item, and it does not know its item number but knows few word of description and also has a small information about class, default supplier, location etc……

He can enter this info and at very next moment he would see the list displaying all the items having the various values similar to information he just entered and then he can select the required item out of it easily.

In standard AX 2012 the item lookup looks like this:


When installing the new item lookup (from my kitting solution), the lookup changes to this:


Since the lookup is attached to the itemId extended data types, this works everywhere you have items.

In the lookup form the user can fill inn filter criteria, like item name, colors, barcode, vendors/groups etc.  I can even use the product categories like this :


I see here in the top, that selecting category Accessories, and selected to only show those where I have on-hand, results in 27 records. 

If I then click on the tab “search results”, I see the items (With on-hand values)


And just to “show of” I have sorted the list with the Physical quantity descending Smilefjes, because it is a outer-joined database view.

All filters work “side-by-side” and together.  So I can ask for products like “Find a green phone we have on stock at warehouse 22”.

The way I do this, is to build up the query in the form, based on the selected filter criteria.


And then just execute the query in the form.  (There are off-cause much more to it, but we can take this in private sessions)

With this very small tool the searching for products will be much easier for our customers.  Remembering item numbers is so 90’s.

Happy Daxing

I appreciate that I can be a part of this worldwide blog community—as a consultant working from Norway, the blog lets me share more than 20 years of experience with Microsoft Dynamics 365. Along the way, I participated in developing retail, PDA/RF, barcoding, master data, kitting and WMS-solutions for Dynamics. My blog focuses on my deepest interests and expertise: along with a 360 degree view of digital transformation topics, I welcome opportunities to dive into retail and intercompany supply chain automation, logistics, and production—everything that is moving around in a truly connected enterprise. As Enterprise Architect on Dynamics 365, I specialize in strategic development and planning for corporate vertical solutions and works to build international networks that increase knowledge and understanding for Dynamics 365. As an advocate for both providers and customers, I'm committed to ensure that customers constantly changing needs are meet, and I see community as key for increasing expertise. I welcome you to connect with me.

6 comments on “AX2012–Search and you shall find….

  1. Hi Kurt, at this moment I´m trying to dev an item filter solution and I found your blog. I think that your solution could be a good start point (I need to add item attributtes criteria). I try to fin dit on codeplex, but it seems that is not available at the moment. Is it possible to have it?
    Many thanks and regards


  2. Hi Mr.Kurt Hatlevik,

    this is really amazing doc which you have share.

    we are requesting you to provide the detail coding for the same so we can implement the same in our organization.
    as i am not technical so will require deep understanding for the same if you can help me.

    thanks & regards

    Skype ID:- hacker_ng


  3. OK,thank you very much.


  4. It’s a very useful function,would you mind share the nice code?


Leave a Reply to Kurt Hatlevik Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: