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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How to create multiple customer address records with same address and different purpose by importing in DIXF

(0) ShareShare
ReportReport
Posted on by

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?

I have the same question (0)
  • Roger Lou Profile Picture
    on at

    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.

  • Verified answer
    GirishS Profile Picture
    27,829 Moderator on at

    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.

  • Roger Lou Profile Picture
    on at

    I used entity named "Customer postal addresses" for import customer address.

  • GirishS Profile Picture
    27,829 Moderator on at

    Hi Roger,

    Which entity you used for importing customer address through data management?

    Thanks,

    Girish S

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

News and Announcements

Season of Giving Solutions is Here!

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 843 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 338 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans