You Follow These General Steps to Setup Item Records in Inventory Control on Sage 300


  1. Add the item information from your existing inventory system to Inventory Control, selecting the options you want to use.  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 balancesheet 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)


If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.