Inventory Management Features and Objectives:
The primary objective of the Inventory Management System (IM System) by Legler Systems
is to process inventory information in an online environment, so specific
online procedures are performed in seconds rather than the hours required by
traditional batch methods of computer processing. This IM system performs the
basic inventory management objectives by providing a complete and accurate
record of all stock transactions affecting each item or product in inventory.
Specific inventory management features and objectives of this business software
application are highlighted below:
- Maintain a separate Product Activity Record on each item in the
inventory reflecting a chronological history of stock transactions -
receipts (ins), transfers and sales (outs).
- Automatically update the inventory from completed sales orders in the
OE System so manual entry of withdrawals (sales) is minimized.
- Print packing lists (IM12) for sales orders to aid in inventory picking
and order processing. Packing Lists are printed on letter-size
paper for direct mailing to customers with the company heading
format specified by System-Option-12 (DB03). This
inventory management feature can be overridden at the time the
Packing List is printed.
- Print management reports, such as Stock Status Report, Product
Activity Report and others, to provide an audit trail of
stock transactions entered into the IM System.
- Maintain Product Master Records on each item in the inventory that is
handled by the company, including description, unit price, list price,
Item-Group code, cost, quantity on-hand and other data fields.
- Handle multiple warehouses by defining a separate Warehouse Code
as Code Definition Records (DB01).
- Calculate the economic order quantity (EOQ) and reorder point based on
actual product sales. The results of these inventory calculations
assist in stock replenishment decisions.
- Calculate inventory value based on actual cost, LIFO (Last In
First Out) or FIFO (First In First Out) method.
- Maintain a separate onhold quantity field to reflect the quantity
sold in the OE System but not yet processed in the IM System by
procedure IM05.
- Provide online inquiry capability to (1) query data elements about
a single product, and (2) display historical information about an
item in inventory.
- Define an Active-Flag to prohibit online entry of inactive customer and
product codes, yet keep those old codes for historical reporting
purposes.
- Provide source document control over stock transactions entered into
the computer by establishing batch numbers.
- Provide the capability to create custom IM reports where the user
defines the data fields to be selected, sorted and printed (DB12).
- Provide auxiliary input capability for initial file creation and the
processing of inventory transactions created by other computerized
applications, including separate data entry operations. Multiple
inventory transactions are processed at one time by procedure IM15.
- Automatically display a detail record (Product Activity Record or
Product Master Record) when function key F7 is pressed from a
data entry procedure (IM01) and an inquiry procedure IM10. This
inventory management objective enables the operator to quickly
drill down to more information.
- Provide import capability (procedure IM17) to read any PC ASCII file of
comma separated values (csv) containing inventory transactions
("ins" and "outs") and create the import Transfer File.
Procedure DB18 also imports inventory data from csv files to the
import Transfer File. This import Transfer File is processed by
procedure IM15 to edit and load inventory transactions into the
IM System.
- Provide export capability (procedure IM17) to create a PC ASCII file of
comma separated values (csv) containing inventory transactions.
Procedure DB18 can be used to export inventory data to a csv file
for use by an external application.
- Automatic item number lookup occurs whenever the item name initials
are entered as the item number for fast item number lookup.
Item name initials are manually or automatically set in the
Product Master Record when it was created to aid in looking-up or
finding an item number. For item number lookup by name, enter the
"#" character as the item number and when prompted, enter the
item name or manufacturer serial number.
- Handle item price discounts at the customer level.
- Create kits or assemblies of a group of products already defined
in the IM System to support customer order processing. Each kit is
assigned its own item or product number.
- Define separate Item-Group codes, as Code Definition Records (DB03)
to group similar items for processing and reporting purposes.
This inventory management objective allows the user to define
multiple Item-Group codes as necessary.
- Print Price Lists (IM16) for a specific customer or all customers
and for a specific Item-Group code or all Item-Groups. Price lists
are printed on letter-size paper.
- Automatically update the Order-Status code as various IM procedures
are completed to reflect the current status of each sales order.
- Provide system options in the Company Control Record to handle
6-digit dates and 8-digit dates for data entry and reporting purposes.
- In addition to online processing, batch job processing is supported where
multiple IM report requests are entered online for later batch processing.
- Easily enter notes or comments on a specific product (IM09) when the
Trans-Code is set to "N" to automatically link to procedure DB17
(General Notes Record) in the DB System.
The Inventory Management System monitors the status of all items in an
inventory, as well as product movements into and out of the inventory. When products
or items are received into inventory, the Enter Product Activity Record
procedure IM01 is executed to manually enter the quantity, cost, bin
location, date and other data about the item received. This same procedure
can be used to enter items taken from inventory, if the Order Entry System
is not installed. If the OE System is installed, then procedure IM05 is
used to automatically process completed sales orders and update the IM System
with items sold (outs).
Based on the inventory activity ("ins" and "outs") for each product, several
types of inventory calculations are performed to control and monitor the
amount of stock to carry:
- Calculate economic order quantity (EOQ):
Based on annual sales, cost of placing an order with a supplier
and the carrying cost, the EOQ is mathematically computed for the
optimum quantity to order.
- Calculate reorder point:
Based on annual sales and safety stock, the reorder point (stock
quantity level) identifies when to order more stock.
- Compute total "ins" and total "outs":
The total quantity received (ins) and sold (outs) is computed for
any time period and stored in the Product Master Record for
subsequent reporting or display.
- Calculate inventory value:
The total value of the inventory can be based on actual cost, LIFO
or FIFO method.
An important design feature of the Inventory Management System and the
Order Entry System is the use of an Order-Status code to track the sales order
through various stages of completion. Order-Status codes are defined by
Code Definition Records, which allow the user to add new codes. The Order-Status
code is automatically changed when various inventory management procedures
are executed as follows:
- Procedure IM12 (Packing List) changes the Order-Status code
from 11 to 13.
- Procedure IM05 (update inventory from filled orders) changes
the Order-Status code from 51 to 55.
- Procedure IM14 (purge) deletes old inventory records with a
Order-Status code greater than 70.
Order Entry System procedures OE01 and OE02 can be used to manually change the
Order-Status code.
The IM System procedures that can be run by the user are identified in the
Inventory Management Menu document.
More Information on the IM Software:
For additional information on this online Inventory Management software,
e-mail Bill Legler in the SF Bay Area, California
or go to the Inventory Management System main page.
Version 11.6 (2024). All rights reserved by Legler Systems Company.