larsheise

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 ? )

 

 

Thanks

Lars

Outcomes