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

Announcements

No record found.

News and Announcements icon
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

I have the same question (0)
  • Verified answer
    Mahendar Pal Profile Picture
    45,095 on at

    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

  • Mick_4711 Profile Picture
    552 on at

    Many thx!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans