We have already discussed How to Merge Customer Records in Dynamics 365 Business Central in our previous post. In this article, we’ll explore how to merge vendor records — a process that’s quite similar but specifically focused on vendor data.

Sometimes, you may find duplicate vendor entries in your system — for example, when the same vendor has been created more than once under slightly different names or codes. Merging these records ensures your purchasing and financial data stays clean and consistent.

 Steps to Merge Vendor Records

Search for Vendor List. In the global search bar, type “Vendors” and select the Vendors page.

Select the Vendor to Keep. From the list, choose the main vendor record you want to keep (this will be your primary vendor).

Select Actions → Home → Merge with.

The system will show both records side by side so you can review them easily.

The Fields section shows all the data fields where the two customer records have different values. If you see only a few differences — like spelling mistakes or minor entry errors — it’s likely that both records belong to the same customer. But if many fields are different, they’re probably two separate customers.

The Related Tables section lists all tables where both customer records appear, such as sales orders or invoices. The Current Count and Duplicate Count show how many times each record is used. This section is just for reference. If any conflicts are found during the merge, you can fix them easily on the Merge Duplicate Conflicts page.

Review and Adjust Data

On the Merge Duplicate page, you’ll see two main sections:

• Fields with Different Values — highlights where the two records differ (like spelling errors or address variations).
• Related Tables — shows where both customers are used (like sales orders or ledger entries).

If you prefer to use a value from the duplicate record instead of the current one, simply select the Override checkbox. That value will replace the existing one once the merge is complete.

Handling Conflicts While Merging Vendor Records

After you specify which values to keep or override, select the Merge action.

Business Central will now check if there are any conflicts between the two vendor records.
A conflict occurs when at least one primary-key field (for example, a code or unique ID) has the same value in both records, but the Vendor No. is different.

If no conflicts are found, simply click Yes in the confirmation message.
Business Central will then rename the duplicate vendor so that every place where its old Vendor No. was used (in purchase orders, ledger entries, etc.) will now be replaced by the Vendor No. of the primary vendor.

If conflicts exist, you’ll see a Conflicts FastTab appear.
Choose Resolve (xx) Conflicts Before Merge to review and fix them.

On the Merge Duplicate Conflicts page:

1. Select the line for the related table that has a conflict.
2. Choose View Details to see the exact fields causing the issue.

Here, you’ll notice that at least one primary-key field has the same value in both vendor records, while the Vendor No. values are different — this is what blocks the merge.

You have two options:

• 🗑 Remove Duplicate:
  If you don’t want to keep the duplicate vendor record, select Remove Duplicate, then click Close.
  The identical field values (except Vendor No.) are removed from the duplicate and merged into the main record.
• ✏️ Rename Duplicate:
  If you want to keep both vendor records, choose Rename Duplicate.
  For fields (other than Vendor No.) that have the same value in both records, update the Alternate Value field, and then click Close.
  This updates the conflicting field value on the duplicate so that it can be merged without error. The duplicate record will remain in the system.

Repeat this process until all conflicts are resolved — the Conflicts FastTab will disappear once everything is clear.

Finally, on the Merge Duplicate page, select Merge again and click Yes in the confirmation message to complete the process.

Note: 

When merging, two records are combined into one.

Before merging, review which field values you want to keep or override. The merge action cannot be undone.

Thanks For Reading...!!😊😊

Regards,

Khushbu Rajvi