96

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.

Category: User Experience
STATUS DETAILS
Completed
Ideas Administrator

Advanced filter or sort supports adding "Not exists" joins. 

Comments

K

You got my vote Kurt - I just had a case where this was needed to optimise a process,

Category: User Experience

K

Agree it would helpful! Another example: Packing slips with no tracking information.

Category: User Experience

K

Applaud the idea!

Category: User Experience

K

Would be a great addition 👍

Category: User Experience

K

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

K

Completely agree. Would be great.

Category: User Experience

K

Great idea!

Category: User Experience

K

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