Skip to main content



No record found.

Supply Chain Management forum

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

Posted on by 68
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?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans