web
You’re offline. This is a read only version of the page.
close
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

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

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 > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans