Product ID - number or text

Discussion created by larsheise on Oct 29, 2013
Latest reply on Oct 29, 2013 by taylorsharpe

I have a standard Invoicing solution, where products are defined as auto-enter serials with unique numbers. This field is on several locations in the Relationsship graph connected to an orderlines table - that also has a numerical number field for the match. Pretty standard I guess.


One customer would now like to be able to have numbers like 245-1/00X ( manufactury number )


Any good suggestions for how to solve this problem would be very appreciated.


Should I say NO - not possible?


Allow entering these "text" strings into a number field ?


Change field format to text in both Products and orderlines ?

( will this break anything ? )