How can i generate an overview with open sales orderlines with ineffective addresses?

(1) Share

Report

Posted on by Henk van Wendel

a known issue in Dynamics 365 supply chain during the release to warehouse of sales order lines, is that the release fails because the address on the line is no longer effective.

Reason: someone has changed the address on the customer and didn't update the open sales orders.

It would be very helpful if there was an option to automatically update the addresses on the open sales order (lines).

But as far as I know there is no such an option available.

So i tried to create an overview of open sales order lines which have an ineffective delivery address.

But on using the advanced filter option and adding an additional join to the LogisticsPostalAddress table, i'm not able to filter on ineffective addresses.

Any other options to create a view with all open sales order lines with an ineffective address?