web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Ship-to data adding in...
Small and medium business | Business Central, N...
Suggested Answer

Ship-to data adding in as Bill-to data - Shipping Address API (Sales Order import)

(0) ShareShare
ReportReport
Posted on by BCgs 470

We are sending the data via an API we have built using microsoft odata. All of the order info is sending correctly, however the "Ship-to" information is adding in under the "Bill-to" information column.

it really doesn't make any sense as under the billing column things like "Shipment Date", "Shipping Advice", "Whse. Handling Time", "Shipping Time" are all nested under the billing info which are all related to "Ship-to"?


[View:/cfs-file/__key/communityserver-discussions-components-files/758/media.mp4:320:240]

So you have...

  • Sell-to (at the top) we just need the default address
  • Ship-to (bottom) Either pick address or add custom
  • Bill-to (bottom) this just needs to be set as the default which is the same as the Sell-to address

Thanks in advance for any suggestions on where we are going wrong!

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • BCgs Profile Picture
    BCgs 470 on at

    Does anyone have any suggestions on this as we are due to go live with Business Central this week and it's the main thing holding us up.

    It must be fairly common to select a custom shipping address for a customer, but nothing in the way of guides/documentation to work out this behaviour?

    Any help would be really appreciated!

  • BCgs Profile Picture
    BCgs 470 on at

    Really struggling with this one as it seems that the ship-to is not editable via Microsoft odata on Business Central cloud?

    The closest solution i have found is this - www.eonesolutions.com/.../

    However the extension does not seem to work on the latest 5.2 version we are on.

    Basically the ship-to address is just not editable and we have no idea how we can solve this before going live?

    Our other solution was to try and create the address under the account first and then select it when you process the order but you can't select a shipping address under the account either.

    If any one has any idea i would hugely appreciate it. All we can do is modify the sell to address and that messes up all the invoicing!

    Many thanks

  • Suggested answer
    keoma Profile Picture
    keoma 32,729 on at

    are there any customisations/extensions in e.g. table sales header, page sales order or in other obects, which are used in the import process?

    also check your external source code, whoch calls the odata service, if there are failures.

    best you develope a new test environment, new odata reference, start over.

  • BCgs Profile Picture
    BCgs 470 on at

    Hi Franz, thanks again for the help!

    What i think i'll look into is the possibility of our Warehouse management extension Warehouse Insight causing some sort of conflict as that modifies a button in the General Sales header and some other parts that may be causing a conflict.

    I also have a test environment with the pre-filled microsoft data however the warehouse parts are copied across all the environments within the production so may try it in the Sandbox?

    At least that gives me something to go on, are you aware if the ship-to is directly editable via odata as it seems it's not?

  • BCgs Profile Picture
    BCgs 470 on at

    Reading up on it it seems the Ship-to information is not directly editable via the web services on a sales order but is for a sales invoice. What we are thinking of doing as a workaround is to modify the default "ship-to" on the account before the order is submitted so it takes this address by default.

    Modifying the sell-to so it changes everything which doesn't make sense as the billing is usually something completely different to where the item is being shipped so it messes up the invoicing.

    So it seems this is something not considered at the moment in Business Central and the only viable workaround is to modify the account before importing the order or updating all of the Sell-to, Ship-to, Bill-to so it is all the same which doesn't really make sense.

    docs.microsoft.com/.../dynamics_salesorder

  • BCgs Profile Picture
    BCgs 470 on at

    It seems like this is the solution - https://www.eonesolutions.com/help-article/failed-to-create-record-property-editable-for-ship-to-address-is-invalid/ However we are getting an issue using this on Business Central cloud v15.2.39558.40612.

    When sending a PUT request to the /ShippingAddress endpoint, we are getting a Request_EntityChanged error message. We are passing through the IF-Match header with the ETag of the order we want to update.

    This works with the standard Sales_Order endpoint. We have checked and the ETag on the order does match what we're passing through. How can we fix this?

    Possibly an update is needed for v15.2 but not sure where to find documentation to sort this issue.

    Our request is:

    URL: {{baseurl}}/Company('MyCompany')/ShippingAddress('Order','S-000001')

    Raw Body:

    {

"ShipToOptions": "Custom Address",

"ShipToName": "My Company",

"ShipToAddress": "My Address",

"ShipToAddress2": "Address 2",

"ShipToCity": "My City",

"ShipToCounty": "My County",

"ShipToPostCode": "My Postcode"

}

    Headers:

    Authorization: Basic {redacted}

Content-Type: application/json

IF-Match: W/"JzQ0O3JxWndQVE1objFQRjVCRFA4akloWFR2UkR3S1dqenNHdzh0MjZaOEtyajA9MTswMDsn"

    Here is the full response:

    {

   "error": {

       "code": "Request_EntityChanged",

       "message": "Another user has already changed the record.  CorrelationId:  bf5c6b13-96ee-4fca-af3c-932faf73f0bd."

   }

}

    Any help would be appreciated.

  • Suggested answer
    keoma Profile Picture
    keoma 32,729 on at

    try with soap instead.

  • Suggested answer
    Ethan-Sorenson Profile Picture
    Ethan-Sorenson 225 on at

    I corrected the issue so the extension should work on newer versions of BC.

    github.com/.../EditShipToBillTo

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans