Blog
Blog

Merging of Customers to Remove Identical Debtors in Business Central

Posted on 13-Sep-2023 by Srushti Salekar

Sometimes, due to some reasons new customers are created which already exists or having the same details as per the old one to overcome this issue Business Central has a solution that we can merge details of the required one with the desired one and the best benefit of this is that the entries which has been done for the new one is also merged with desired one.

Here for instance, in our system new customer is created by user mistakenly which is having same details as the existing customer.

The newly customer created is C00060 which has same details as the C00010. The only difference is in contact details. Now we briefly discuss whole scenario STEP by STEP.

STEP 1: - Search “Customer” in business central.Search Customer in Business central
 

STEP 2: - Customer list will open.
Customer list page in Dynamics 365 Business Central showing customer merge preparation
 

STEP 3: - We see that the C00060 which is newly created by mistake is having basic details same as C00010.
Unified Data Queue Manager screen in Business Central for customer data processing
 

STEP 4: - When we see details it is observed that the contact details in the new one (C00060) are new or updated.

Please see C00010 Contact (Phone No., Mobile Phone No., Email) Details.
Customer data overview before merging duplicate customers in Business Central

In new customer C00060 Contact (Phone No., Mobile Phone No., Email) Details are updated.

Business Central dialog box showing background data processing during customer merge
 

STEP5: - When we see the Ledger details for both customer it is observed that an invoice has been booked for the newly(C00060) created customer.

Unified Data Queue Manager showing completed customer merge log in Business Central
 

STEP6: - Now we have to merge all the updated details of C00060 in C00010 so that duplicate entries from the system will eliminate. For this we go to C00010.

Customer Card> Actions> Functions> Merge with.

Customer ledger entries before merging customers in Dynamics 365 Business Central

**NOTE** Please beware of the fact that we cannot undo the changes of Merging.
 

STEP7: - When we click on “Merge With” a new window will open.

Customer ledger entries after merge process completed in Business Central
 

STEP8: - Here we select the Customer No whose details we want to merge in our case C00060 in “Merge with” field.

Merge duplicate customer confirmation popup in Dynamics 365 Business Central
 

STEP9: - System will show the comparison between the Current (C00010) customer and the merge with customer (C00060).

Final customer master record after successful merge in Business Central

STEP10: - Then we select the which we want to update. Here, Contact (Phone No., Mobile Phone No., Email) Details need to be updated in C00010 so we select same.

Customer card page in Business Central displaying updated merged customer details

STEP11: - Then we click on merge system will populate a message asking for confirmation.

Customer address and contact details after merge in Dynamics 365 Business Central
 

STEP12: - We click on “YES” new message will populate.

Customer transaction list reflecting merged customer entries in Business Central
 

STEP13: - Now we can see that the details of C00060 have been updated in C00010. For that we go to Customer list here we see that the C00060 has been removed and only C00010 is available.

Business Central customer merge validation message during process execution
 

STEP14: - Now when we go to C00010 to view the changes, firstly we go to “Address & Contact” Tab we can see that the details are updated.

Merged customer record with consolidated data in Dynamics 365 Business Central
 

STEP15: - To view the ledger entries got updated or not we go to Ledger entries of C00010 her we can see that the details related to C00060 are merged.

Customer overview list after removing duplicate customers in Business Central


Post a Comment

Your email address will not be published. Required fields are marked (*)

Captcha
can't read? refresh

WhatsApp Now