Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Import accounts and contacts to different BUs

(1) ShareShare
ReportReport
Posted on by 552

Hi there,

I've got question concerning the import of accounts and contacts to different business units.

As you can see in the diagram, I've got several BUs. They are all subsidiary companies using the same CRM.

crmcomm.PNG

To not completely deactivate the custom duplicate filter, I set the filter like this: 

6710.filter.PNG

This worked fine uploading the accounts. The BUs B 2 and the C-BUs got the Accounts. But... When I imported the contacts, the upload failed, because "A duplicate lookup reference was found."

The reason why is that a user in B2 had the same account as a user in C1. 
The error message came even when I assigned the contacts before starting the upload to the user in B2.

How can this problem be solved?

Best regards to you

Mick

*This post is locked for comments

  • Mick_4711 Profile Picture
    Mick_4711 552 on at
    RE: Import accounts and contacts to different BUs

    Many thx!

  • Verified answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: Import accounts and contacts to different BUs

    Hi,

    "A duplicate lookup reference was found" error is due to the duplicate record exists for the lookup you are reference in the records that need to import. To avoid duplicate error either you can use specific GUID of the record to reference it or you can use a combination of the other keys to import data.

    refer: exploringxrm.wordpress.com/.../resolving-duplicate-lookup-references-in-import-process

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans