It would be highly appriciated to have the possiblity to allow for "not- Exists-Joins" in the Advanced filter/Sort. This would allow us to filter for products without inventory transactions. Vendors with no purchase orders or sales orders with no salesorder lines. I did a blog post about this a few years ago, that is available here https://kurthatlevik.com/2014/11/19/dynamics-ax-2012-r3-to-exist-or-not-that-is-the-question/ Feel free to incorporate this into the platform product backlog.
Comments
You got my vote Kurt - I just had a case where this was needed to optimise a process,
Category: User Experience
Agree it would helpful! Another example: Packing slips with no tracking information.
Category: User Experience
Applaud the idea!
Category: User Experience
Would be a great addition 👍
Category: User Experience
Indeed, this would have a great added value to involve in many relevant queries (where in addition tiles / working lists can be built on)!
Category: User Experience
Completely agree. Would be great.
Category: User Experience
Great idea!
Category: User Experience
This would be a great addition. We have add this following Kurt's blog, but having this as a standard feature adds a lot of flexibility.
Category: User Experience
Jason Green (administrator) on 12/17/2021 6:53:39 PM
Advanced filter or sort supports adding "Not exists" joins.