Big thank you to someone on a Yammer group for spotting that the Advanced filter or sort function in 10.0.9 supports Not Exist Joins:
There’s nothing in the F&O release plan that specifically mentions that this functionality was being added, but it could well have come from a Community Driven Engineering pull request submitted last year.
But does it work? I did a quick test: Customers with no records in CustTrans.
And the result looks very encouraging: