7 Replies Latest reply on Oct 29, 2013 2:35 PM by taylorsharpe

    Product ID - number or text

    larsheise

      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