Alphanumeric Serials

[phanover]

Hello,

I have an inventory system set up with portal relations to orders. Every item has a unique barcode assigned to it that is a string of 4 numbers (i.e. 0001, 0002, etc.). However certain items cannot be barcoded due to their size/shape/material. Also these items do not need to have unique codes. An example would be extension cords, I want that to be a generic id that can be added to a portal row, then adjusted for quantity. Currently if I type my id for extension cords, ACEX, into the portal row, the related record is not displayed. Another id with out a numeric barcode is CXLR10, for a 10' xlr cable. However the portal row reads only the 10 and displays the record for 0010 instead. Is there a way to allow for a variety of id codes will not losing the one to many relationship from the inventory table to the line items table (auto entering a numeric serial is the only way I have figured out to establish this relationship).

 

 

[phanover]

Ignore this post, solved issue, barcode was a number field and not a text field