Duplicate Items with Different Names, Quantities, and Prices

(0) Share

Report

Posted on by Abdulla Magdy

112

In an existing Dynamics 365 environment, we are facing a large number of duplicate items created with different names, units, quantities, and purchase prices for essentially the same products.

What is the recommended approach to clean up and consolidate these items, enforce proper item governance, and prevent future duplication while maintaining accurate inventory and purchasing history

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 302,194 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Abdulla,

If the names are different, how do you know that these are duplicates? I start with this question as you didn't provide details how you found out these are duplicates. Is it e.g. based on GTIN number or an external item ID?

You should think of a proper master data team responsible for product creation and maintenance. They can perform duplicate checks before creating a new item. There are also ISV solutions available where you can setup duplicate checks based on rules. E.g. Staedean has a solution for master data management, also having a strong focus on data quality and data entry.

Cleaning up will be not possible in case the items do have transactions. In that case, you can use inventory journals to move all on-hand to a single item record. Other duplicate products can be stopped for purchase, sales, and inventory actions. The history will remain on the stopped items.

Was this reply helpful? Yes No