Supply chain | Supply Chain Management, Commerce

Delivery address not imported during sales order header import

(0) Share

Report

Posted on by Karsten Rasch

Hi,

When importing sales order header using data entity 'Sales order headers V2' the delivery address on the imported SO is not set to the delivery address provided in the file.

Instead the SO delivery address is set to the primary delivery address specified on the customer.

The file is generated by exporting an existing SO (in the same application and company) to Excel using the same data entity.

Step-by-step:

Create an non-primary delivery address for a customer.
Create a sales order for the customer using the non-primary delivery address.
Export the sales order.
Delete the sales order.
Delete the non-primary delivery address on the customer.
Import the sales order.

Result:

The sales order is created with the primary (standard) delivery address.

The non-primary delivery address is not created on the customer.

I have tried debugging but without locating the root cause yet. The field mapping is ok and regenerating it has no effect.

Any ideas?

All responses (6)

Answers (0)

Suggested answer

Karsten Rasch 10 on at

Like (0)

Report

RE: Delivery address not imported during sales order header import

The answer from MS is that it is by design.

My solution was to extend the insert-method on the SalesTable datasource in the entity to create the delivery address and then set the address-reference from SalesTable.
Suggested answer

Rahul Mohta 21,024 on at

Like (0)

Report

RE: Delivery address not imported during sales order header import

these fields gets the delivery address

DELIVERYADDRESSCITY DELIVERYADDRESSCOUNTRYREGIONISOCODE DELIVERYADDRESSCOUNTYID DELIVERYADDRESSDESCRIPTION DELIVERYADDRESSNAME DELIVERYADDRESSSTATEID DELIVERYADDRESSSTREET DELIVERYADDRESSZIPCODE

it is working , which env/version r u using?
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Delivery address not imported during sales order header import

moved to the d365 forum
Suggested answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: Delivery address not imported during sales order header import

Ok, thanks for the info. Do you expect to have same name in many addresses in your real business scenario?

If you feel it's a bug, you can report it to MS by support request.
Karsten Rasch 10 on at

Like (0)

Report

RE: Delivery address not imported during sales order header import

It is D365.

Further testing shows that:

- D365 will copy an existing delivery address from the CUSTOMER to the created/updated SO if the import file in field DELIVERYADDRESSNAME has a value which matches an existing delivery address name on the customer.

- As the address is copied from the CUSTOMER and not from the FILE any differences - say, another street name in the file - is not imported.

The DELIVERYADDRESS* fields from the test file:
nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: Delivery address not imported during sales order header import

Are you using Dynamics AX (2012) or Dynamics 365 for Finance & Operations?

Can you share the file that you are importing, at least the delivery address section.

Also, I don't think that SO import should/will create delivery addresses for the customer. But of course the provided delivery address should appear on the order.