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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

What is the best way to deal with item numbers that are too long?

(0) ShareShare
ReportReport
Posted on by

We are trying to understand the best way to deal with the vendor and customer item numbers, serial number, and potentially our own. 

To give a bit of context, in our previous program we were using our vendor part numbers as our own, these could range anywhere from 12-36 characters. This would replace our "item number" in Dynamics. However, we have come to realize that we are not allowed this many characters in the item number. 

What makes the most sense to keep track of all of these numbers - we want them to show up on the Sales Order, Purchase Order, and Invoice documents as well. 

Is there a way to extend these characters somehow in the item number field? Could we add additional fields through an app that would still allow us to use them in the documents? And if so, would we be able to search them so we do not accidentally create duplicates?

I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

    You cannot extend the standard primary key of the Item table. You can reach your goal with a customization (extension) that adds a new field ("Internal Item Number for example) with the length you want. In the OnAfterValidate event of the No. field of the Sales Line and Purchase Line table you can show this field where you want (or simply by adding a flowfield to that tables with a tableextension object).

  • Community Member Profile Picture
    on at

    Hi Stefano,

    If we wanted to keep the item number as our own - as there are instances where the vendor does not provide a part/item number - what would you suggest is the best plan of action? We want to be sure that all numbers (vendor, client, internal, and serial number) are included in the documents. Additionally, when we create our own item numbers for the vendor numbers - we want to ensure that there is a way to ensure that we are not creating the same item again... Is there a way to make this happen?

    We also want to be able to cross-reference, so that all of the numbers are shown to be related to one another. I realize that cross-reference numbers achieve this, but again we have reached a limitation due to the number of characters allowed in those fields.

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at

    Yes, cross-reference has the same limitation on size.

    I suggest (as said in my previous response) to add a custom field on the Item table and then use this field (as a flowfield or as a real field moved in the OnAfterValidate event) on the lines tables (Sales and Purchase).

    For avoid duplication, on this new field you (in the OnValidate trigger) you can add your logic to avoid conflicts (for example you can check if there's an Item with the same value and if yes throw an error).

  • Community Member Profile Picture
    on at

    Thank you.

    Which applications/extensions would you recommend to use for this? Would they be fairly straightforward to use and apply the OnAfterValidate and such without a developer background?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,804 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,103 Super User 2026 Season 1

#3
Kamal Khakhkhar Profile Picture

Kamal Khakhkhar 695

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans