Hi Everyone! Hoping someone can provide a formula or an idea on how to tackle the two issues below.

Some of our customers (most often EDI customers) order with their specific customer material numbers. Customer material numbers are entered in their CMIR table under their customer number (or payer .

Issue 1:

Customers who have been set up on EDI for years with no issues are now having orders fail resulting in an IDOC. This is because of mass uploads to update CMIRs (several without checking duplicates first by mistake). We need a way to identify these errors and remove the duplicates without having to pull reports for hundreds of customers out of SAP one-by-one to identify the errors. Also, we need a way to monitor moving forward to avoid duplicates.

Issue 2:

EDI orders are failing because multiple customer material #s have been entered into the customer's CMIR table tied to only one of our part #s.