Inventory report columns
I realise that the Item name can only be 30 characters but the description can be 255. However, I want to produce a report of our inventory that shows the Item code, Name or Description, Quantity of stock on hand, Orders in the system and available stock. There is no option to use the Description instead of name. Our staff have asked me to show our unique code for each item, but the only way I see to add another column is to add a custom list which is a drop down box. We have about 300 unique codes so I can't set up a drop down box. Any ideas on how to show our code since the field length is not long enough to add it there?
