Hello!
Our customers are connected through EDI. For a single product number, they buy an Each, a Carton, and a Case. They have a different external ID number for each of these units of measure. In D365, we can only add one external ID number per item per customer. This means that we either have to do extensive manual work-arounds for every external ID number we can't list to get the order into the system, or we have to set up conversions in external platforms and convert all of their orders into the smallest unit they order, which then translates to our order pullers pulling eaches instead of cases, which exponentially increases time and errors.
How can we get the External Item Descriptions tables on the Released Product to accept more than one customer external ID for each unit of measure without throwing the error "Cannot create a record in External item descriptions (CustVendExternalItem). Item number: XXXXX, Customer group. The record already exists." ?
This seems like it should be a very simple solution, to add multiple lines that reference our item number, the customer, the external ID number, AND the UOM, but we can't find any information that doesn't delve into creating external tables, and even that information is developer-focused, so it's very untranslatable to the lay-person.
Has anybody found a solution to this order-killing issue?