Building the Inventory File Home | FAQs & Troubleshooting

 

 Show/Hide All

Item codes that identify your inventory items can contain up to 30 characters. Generally, you can use your existing numbering method, as long as it does not exceed the limit.

An item's product line code can be used as the leading four characters of the item code; however, because all reports can be sorted by product line, the product line code should not be included in the item code, unless duplicate item codes exist in different product lines.

If you use numbers as part of your item codes, you must enter leading zeros, so that each number has the same number of characters (digits and letters). If leading zeros are not entered, items will not be correctly sorted on reports.

 Example - Sorting with Leading Zeros

The following table illustrates how numeric item codes, with and without leading zeros, are sorted.

Without Leading Zeros	With Leading Zeros
110010	000650
23401	009100
650	023401
9100	110010

 

For more information, see Item Maintenance.