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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / External Item Number i...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

External Item Number in Sales Order Line

(6) ShareShare
ReportReport
Posted on by LK-25071715-0 56
Hi D365 Community, 
 
My client is looking for a way to automatically populate the Item Number based on the External Item Number in Dynamics 365, similar to how it works in NAV for them now. Are there any possible alternative of having this requirement achieved without customization? I was trying to to find a solution but the table does not seems to be able..
 
 
Thank you,
Luiza
Categories:
Dynamics 365 Supply Chain Management
I have the same question (1)
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,530 Super User 2025 Season 2 on at
    Hi there! Good morning, evening, or afternoon - depending on where you are :) Hope you are well today! 
     
    In Dynamics 365 Supply Chain Management, there isn't a direct out-of-the-box feature to automatically populate the Item Number based on the External Item Number in the Sales Order Line, as it works in Dynamics NAV. However, there are a few alternative approaches you can consider without heavy customization:
     
    1. Use Cross-Reference Numbers
    • Dynamics 365 allows you to set up Cross-Reference Numbers for items, which can act as external item numbers.
    • To configure:
      • Navigate to Product Information Management > Products > Released Products.
      • Select the product and go to Cross-References.
      • Add the external item number and associate it with the product.
    • When entering the external item number in the Sales Order Line, the system can automatically resolve it to the corresponding Item Number.
    2. Enable Product Search by External Item Number
    • You can enable the Search Name or External Item Number fields to make it easier for users to find and select the correct item.
    • To configure:
      • Go to Product Information Management > Setup > Product Search.
      • Ensure that the external item number is included in the search criteria.
    3. Data Import with External Item Numbers
    • If you're importing sales orders, you can use the Data Management Framework to map external item numbers to internal item numbers during the import process.
    • Create a mapping in the data entity to translate external item numbers to the corresponding internal item numbers.
    4. Leverage Power Automate
    • If manual entry is still required, you can use Power Automate to create a flow that checks the external item number entered in the Sales Order Line and automatically updates the Item Number field.
    5. Consider Minimal Customization
    • If none of the above options fully meet your needs, a small customization might be required. For example:
      • Create a plugin or workflow that triggers when an external item number is entered in the Sales Order Line.
      • The plugin can look up the corresponding Item Number and populate it automatically.
     
    While these approaches can help achieve your requirement, the Cross-Reference Numbers method is the closest alternative to the NAV functionality and requires no customization.
  • Suggested answer
    P Jackson Profile Picture
    P Jackson 1,614 on at
    This would be a simple customisation
  • Vahid Ghafarpour Profile Picture
    Vahid Ghafarpour 12,133 Super User 2025 Season 2 on at
    If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

    To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

    Thanks for being an active part of the Dynamics 365 Community! 😊

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 284 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 178 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans