web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Difference in sorting ...
Microsoft Dynamics AX (Archived)

Difference in sorting using advanced filter query between On-hand stock and On-hand

(0) ShareShare
ReportReport
Posted on by Community Member

I want to add to a query a sort order, in Stock management > common > on-hand stock, when I Ctrl F3 I can go to the Sorting tab and add in further sorting criteria, just like adding more fields in the range tab. However in Stock management > inquiries > on-hand, I can only add extra fields to the range tab not the sort tab. I want to be able to create filters and cues on this data to access quickly and wanted to use the on-hand option as it opens in a new window and can remain open when doing other things.

Any advice?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 237,878 Most Valuable Professional on at

    You can't add sorting if the query already uses grouping (on-hand stocked is grouped by dimensions).

  • Community Member Profile Picture
    Community Member on at

    Hi Martin,

    I thought that but you can also group by dimension in the On-hand stock screen from the common menu and the advanced filter allows multiple sort criteria in that screen

    Here is the sorting screen from that option

    here the add and remove are active - and this filter works fine in this screen

    this is the sorting screen from the on-hand option

    its strange its not consistent - any ideas??

    thanks

    Julie

  • Community Member Profile Picture
    Community Member on at

    sorry no idea why the screen prints are not showing on here???

  • Martin Dráb Profile Picture
    Martin Dráb 237,878 Most Valuable Professional on at

    I actually created an extremely simple form with group by to prove the point - I suggest you to do the same to see it.

    I don't remember the implementation of "On-hand stock" form, but it may use a temporary table, for example. I'll take a look tomorrow, if needed.

  • Martin Dráb Profile Picture
    Martin Dráb 237,878 Most Valuable Professional on at

    In my version of AX, I'm unable to add sorting to Inventory and warehouse management  > Common > On-hand inventory either.

  • Community Member Profile Picture
    Community Member on at

    Hi Martin,

    thanks for the help - my version does allow sorting so I am going to do a bit more investigation into speed etc and if all checks out will point the users into that option if they need the sorting function.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans