Building the Inventory File

 

Expand/Collapse all 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.

Expand/Collapse item  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.


 

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks