Filter for Blank Values in D365 F&O OData
A simple question came up recently: which vendors in our environment have no primary address? In SQL this is a five-second job SELECT vendtable WHERE ADDRESSLOCATIONID IS NULL Through the D365 Finance & Operations OData endpoint, it turned into a small investigation. The short version: the OData $filter in F&O cannot express "this field is … Read more