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?

I have the same question (0)

All responses (6)

Answers (0)

nmaenpaa 101,162 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Karsten Rasch 10 on at

Like (0)

Report

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:

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

moved to the d365 forum

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

these fields gets the delivery address

DELIVERYADDRESSCITY DELIVERYADDRESSCOUNTRYREGIONISOCODE DELIVERYADDRESSCOUNTYID DELIVERYADDRESSDESCRIPTION DELIVERYADDRESSNAME DELIVERYADDRESSSTATEID DELIVERYADDRESSSTREET DELIVERYADDRESSZIPCODE

it is working , which env/version r u using?

Was this reply helpful? Yes No
Suggested answer

Karsten Rasch 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No