Delete Duplicate Customer addresses and update SO Lines with primary AddressLocationID

(0) Share

Report

Posted on by MYGz

2,240

Hi,

While importing Sales Order Lines through DMF, there were multiple duplicate Customer Postal Addresses were created for each customer.

Now I want to just keep the primary addresss on each customer and delete the duplicate addresss. And then update the address on the Sales Order header and line.

I manually deleted some of the duplicate addresses, due to which some of the sales orders have the confirm button disabled. Also when I manually update the line address, the status becomes cancelled. How to avoid this? I want to update the existing line with the line status being "Open Order" and not becoming "Cancelled".

Appreciate any tips.

Thanks.

Categories:

Dynamics 365 Finance

I have the same question (0)