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?