We need to import customer addresses to D365 F&O, but we finded there have different behaviors between importing in DIXF and user infterface.
Users may create multiple customer address records, these address records have same address and different purpose, i.e. I could create 2 customer address records (address 1 and address 2) associated with customer A, the countries of the address records are all USA, state/city/district are all empty, the streets are all "No. 123 Street test". The purpose of address 1 is Business. The purpose of address 2 is Delivery.
But when I tried to import customer address records in DIXF like act on page, it was failed. I imported a customer address into D365 with purpose "Business", succeed. When I tried to import the second customer address record with purpose "Delivery", I found that instead of creating a new record to save the address with purpose "Delivery" like I expected, system updated the record with purpose "Business" imported before, set the purpose to "Delivery". Then finally I could find only 1 address record, even through I imported many times.
Did any one meet same scenario? How could I resolve it?
Or is it a limit of DIXF?
Compared 2 records, besides "ADDRESSLOCATIONID", other fields are all same. I tried to generete an ID mannually before imported, then import succeed. It means that if I wanted to do so again, I need to filter all duplicated addresses and generate IDs for those all, then I could import those as I expected.
My suggestion will be create a record with same address and different purpose from UI - And then export the "Customer postal addresses" from data management and you can compare the two records which you created from UI. Find out which field values are different from two records.
Thanks,
Girish S.
I used entity named "Customer postal addresses" for import customer address.
Hi Roger,
Which entity you used for importing customer address through data management?
Thanks,
Girish S
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156