This chapter is $Revision: 1.1 $ $Date: 2003/01/05 00:00:30 $.
(TODO) This section has a lot of stuff that really should be in the warehouse module.
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.
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.
Reconcile annual or ad hoc physical inventory counts (does not include cycle counting). Print count tags and reconcile inventory.
Maintain standard cost of inventory items.
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.
Maintain alternate part numbers.
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.
Annotate items with resale status, product-resale, internal use, or service-resale.
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.
The following items will be implemented in future version of this module. They may be implemented in the base module or be added via an industry specific add on.
Cycle counting. Cycle counting is a method of issues a random count list on a daily, weekly or monthly basis with the item code and location (but now quantity), having the stock room staff count the number on hand. The computer then compares the number counted with the number expected and if they agree great. If not, then the item is counted again. If they still dont agree then the quantity is adjusted if approved by a supervisor.
ABC analysis and reports. Divide inventory by cost and throughput such that high impact items can be focused on.
Inventory performance analysis.
Lot tracking. Track an incoming lot of material and maintain enough information to trace the lot through manufacturing, assembly and distribution.
Serial number tracking. Inventory management that tracks individual items based on their serial numbers.
Shelf-life management. This functionality will include management of items that have an expiration date and therefore need to be removed after the expiration date and also the ability to dispense the oldest items first.
The following Business Objects are defined and maintained by this module.
Item
Enter results from physical count.
Inventory Look-up. This forms will allow look-up of inventory by description, part number, type, or location. For the group of items found it will display part number, location, location status (if more than one is defined), and quantity.
Inventory report. List of inventory items sorted in various ways. Contains item number, description, inventory types, quantity on-hand, location, cost, last receipt date, and last dispersement date. Sort by part number, description, or location.
Standard Cost. Standard cost is set manually by someone.
# $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 }; };