Update Bill-to Address when Sell-to Address Updated

Stuart Hardman on 7/10/2019 2:45:05 PM

When a Sell-to Address is updated on a Sales Order (or invoice) there is a prompt to ask if you want to update the Customer, if you say yes the Customer is updated, the Ship-to Address is also updated (if Ship-to is set to Default) but not the Bill-to Address on the Sales Order. This then means when you invoice the order the address at the top is incorrect, plus it adds a Ship-to Address at the bottom (with the incorrect address on it).

The Bill-to Address should be updated at the same time (if the Bill-to Customer is the same).

There is also no way of manually changing the Bill-to Address unless the Bill-to Customer is changed (at which point for some reason the address becomes editable) this means there is no way of updating address details on a cash non-account Sales Order.

STATUS DETAILS

Needs Votes

Business Central Team (administrator)

Thank you for your feedback. Currently this is not in our roadmap; however, we are tracking it and if we get more feedback and votes, we may consider it in the future. Sincerely, Business Central Team

Comments

RE: Update Bill-to Address when Sell-to Address Updated

Thomas Brodkorb on 7/2/2020 6:24:38 AM

Of course the complete address needs to update, just changing the name and not the post code or city makes no sense.

The same is valid for the "Ship-to Address", this needs to be in sync with the Sell-to Address as well.

Category: Sales

RE: Update Bill-to Address when Sell-to Address Updated

Rainer Kuhnlein on 7/2/2020 5:36:50 AM

I think not the whole Bill-to Address should be updated automatically but only the parts of the address where the old value of the "Sell-to Address" field corresponds to the value of the "Bill-to Address" field.

E.g.
IF xRec."Sell-to Name" = "Bill-to Name" THEN
"Bill-to Name" = "Sell-To Name"

Category: Sales