About Setting Up Inventory Items

Item records contain the information you need to manage your inventory. You must add inventory item records to Inventory Control before you can enter inventory transactions.

This topic provides an overview of the item setup process. For detailed instructions on adding item records to Inventory Control, see the following topics:

Adding Inventory Items Using the Items Wizard

Adding Item Records

Note: Before you can add item records to Inventory Control, you must set up item number formats, account sets, categories, and locations.

You follow these general steps to set up item records in Inventory Control:

1. Add the item information from your existing inventory system to Inventory Control, selecting the options you want to use. More...

   Adding item records to Inventory Control involves transferring your existing item information to Sage 300, and selecting options that help you process inventory data effectively.

   When you add an item, you record the following information on the I/C Items screen:

   • The item number you use to identify the item.
   • A description of the item.
   • The item number structure (the code you use to identify the item number format).
   • The category to which the item belongs.
   • The account set the item uses.

     You assign an account set to define the costing method and general ledger balance-sheet accounts for the item.

   • The default price list from which you want the I/C Shipments screen to display the item’s price.

     You can override this price list when you enter shipments.

   • The picking sequence / bin number so items can easily be found in the warehouse.
   • Whether the item is active, sellable, allowed in a Web store, a stock item, serialized, lotted, or is a kitting item.
   • A commodity number, if your company reports a value-added tax (VAT). (Optional)
   • The unit weight and the weight unit of measure.
   • An alternative item that can be used if this item is out of stock.
   • Comments.
   • The units of measure used for stocking, shipping, and receiving the item.
   • Tax authorities used when selling the item through Order Entry.
   • Entries for optional fields that have been added to the item records.
2. Add minimum and maximum desired stock quantities for items so you can print reports to identify understocked and overstocked items in your inventory. (Optional)

   Purchase Orders uses reorder information to generate purchase orders automatically for understocked items.

3. If you have already set up your inventory locations, assign items to the locations where you want to stock them, or you can do this later. (Optional)

   Note: If the Allow Items At All Locations option is selected on the Options screen, Inventory Control assigns all items to all locations.

4. If you repackage or assemble items before selling them, add bills of material to define master items that you make from component items. (Optional)
5. Use the Manufacturers' Items screen to associate bar codes with your item numbers. (Optional)