web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Item with different customer external item descriptions for each UOM - Solving for EDI

(0) ShareShare
ReportReport
Posted on by
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?
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 85 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 57 Most Valuable Professional

#3
Satyam Prakash Profile Picture

Satyam Prakash 49

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans