Chapter 2. Inventory Module

2.1. Requirements

This chapter is $Revision: 1.1 $ $Date: 2003/01/05 00:00:30 $.

2.1.1. Inventory Module Business Requirements

(TODO) This section has a lot of stuff that really should be in the warehouse module.

  1. Each quantity can be designated with a definable status like good stock, reserved stock, waiting for quality approval, not-usable or etc. Each quanitity also has a definable storge location.

  2. Provide capability to generate pick list from open sales orders. Pick list will have item names, quantity and warehouse locations and have a place to denote which items and quantity have actually been picked from inventory.

  3. Reconcile annual or ad hoc physical inventory counts (does not include cycle counting). Print count tags and reconcile inventory.

  4. Maintain standard cost of inventory items.

  5. Inventory transactions. Each inventory movement will create a log entry that keeps track of the source of the transaction, (i.e. vendor receipt, customer receipt, scrap, lost, inventory adjustment, etc.) date, time, login user, item code, and quantity.

  6. Maintain alternate part numbers.

  7. Annotate items with stock replenishment scheme as stock (default, manual reorder) or non-stock status (special order). The Demand Management Module may add additional rules to the replenishment scheme.

  8. Annotate items with resale status, product-resale, internal use, or service-resale.

  9. Annotate items with MSDS information. MSDS stands for Material Safety Data Sheet. The point here is not to duplicate the MSDS, but rather to reference the correct MSDS for the item. This information will be available for printing on pick lists, purchase orders etc.

2.1.7. Business Object Definition

					
# $RCSfile: inventory.html,v $: Inventory item definition.
#                  
# Copyright (C) 2001 Free Software Foundation, Inc.
#
# This file is part of GNU Enterprise.
#
# GNU Enterprise is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2, or (at your option)
# any later version.
# 
# GNU Enterprise is distributed in the hope that it will be useful, but
# WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
# General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with GNU Enterprise; see the file COPYING.  If not, write to the
# Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
# 02111-1307 USA.
#
# This file originally written by Neil Tiffin (neilt@gnue.org).
#
# $Revision: 1.1 $ $Date: 2003/01/05 00:00:30 $ $Author: psu_gnue $
#

module inv
{
  # -------------------------------------------------------------------------
  # type - Type of quantity
  # -------------------------------------------------------------------------
  class i_type
  {
    char name<20>;
    char descr<70>;
  };
  
  # -------------------------------------------------------------------------
  # stock_quantity - Quantity tracked.
  # -------------------------------------------------------------------------
  class stock_quantity
  {
    unit::quantity   quantity; # various types of quantities
    inv::i_type     *i_type;   # on-hand, scrap, on order etc.
    whse::storage   *location; # in this one location.
  };
  
  # -------------------------------------------------------------------------
  # stock_item -
  # -------------------------------------------------------------------------
  class stock_item : base_item::item
  {
         
    inv::stock_quantity   [] quantity;   # various types of quantities
         
    unit::quantity    weight;
    unit::quantity    volume;
    
    char              msds_reference<100>;  # material data safety sheet reference
    text              inventory_notes;      # inventory handling note
    
  };

};