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 :
Small and medium business | Business Central, N...
Suggested Answer

Merge Duplicates - Permission Set

(1) ShareShare
ReportReport
Posted on by 289
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
I have the same question (0)
  • Jritz Profile Picture
    289 on at
    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!
  • Jun Wang Profile Picture
    8,202 Super User 2025 Season 2 on at
    you are doing the right thing. not sure why the out of box permission set fails to work. 
     
    Jun Wang
  • Suggested answer
    Jun Wang Profile Picture
    8,202 Super User 2025 Season 2 on at
    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
  • Maylon Perez Profile Picture
    84 on at
    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.

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,630

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 800 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 789 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans