Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Merge Duplicates - Permission Set

(1) ShareShare
ReportReport
Posted on by 287
We recently worked with a client that needed to perform the task of merging duplicate customers in Microsoft Dynamics Business Central. Typically, this process is performed by navigating to a customer card and taking the Merge with option found in the home tab. There is a permission required to perform this action, appropriately named merge duplicates that can be assigned to users.
 
However, even when assigning this permission set to users attempting to perform this task, they were met with an error message!
 
After revisiting configurations and user permission sets and coming up empty, we lodged a support ticket with Microsoft. Their suggested solution after investigating was to assign the SUPER permission set to the users in question. However, you can imagine this suggestion was met with trepidation. This being the case, we decided to make a custom permission set using a somewhat hidden feature of Business Central; the ability to record permissions when performing a task.
 
To do this we created a new empty permission set. Opened a new tab in the same environment. From the previous tab with the permission set, navigated to Actions, Record Permissions, Start. In the new tab we performed the desired actions, navigated to a customer card, took the merge with option, and merged the customer with another. Once this task was completed, we hit the stop button on the permission set. This left us with a custom permission set that has only the permissions required to merge duplicates. Hope this helps.
 
Merge with
 
//
Error
//
 
 
Thanks,

Josh R
  • Maylon Perez Profile Picture
    Maylon Perez 32 on at
    Merge Duplicates - Permission Set
    I am still facing a similar issue. I have SUPER permissions assigned and I am still getting the below permission error message when I click on Merge:


    I have uninstalled all the third-party extensions and even created a custom permission and I have created new permissions set and included this permission (TableData 110) and other ones related to sales shipment.

    The issue persist.
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,604 Super User 2025 Season 1 on at
    Merge Duplicates - Permission Set
    you could check if any customized user permission sets were assigned to the user that exclude the access to tables that are required for the merge. 
    Or you could test in a straight out of box database on a user ideally without customized permissions, I guess it should work.
     
    Jun Wang
  • Jun Wang Profile Picture
    Jun Wang 7,604 Super User 2025 Season 1 on at
    Merge Duplicates - Permission Set
    you are doing the right thing. not sure why the out of box permission set fails to work. 
     
    Jun Wang
  • Jritz Profile Picture
    Jritz 287 on at
    Merge Duplicates - Permission Set
    If anybody has run into this issue or knows of another standard permission set we would've needed to avoid this problem, please let me know! 

    Thanks!

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

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,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans