Construction Information Systems, Inc.



Home
Up
Who is CIS
Global Features
List of Modules
Sample Screens
Request a Demo
FAQ's
Contact Us
Newsletter

Inventory

Design Objectives

The Inventory module is an essential component of the Material Control system that also includes the Purchasing, Receiving, and Accounts Payable modules. Inventory's design incorporates data from Material Receiving reports; maintains details on the quantity, value and physical location of every inventory item; and controls the issuance of inventory to either the Equipment, Work Order, Payroll, Cost Accounting or Accounts Receivable modules.  The Order Entry functions of the Inventory module record customer orders, generate picking and packing lists, and subsequently creates accounts receivable invoices.

Features

bulletDaily transaction reports provide a continuous record of inventory activity and an audit trail.
bulletSimultaneous processing available for most functions.
bulletSecurity locks protect database from concurrent, but conflicting processes.
bulletMultiple warehouses with on-line status of the inventory of any item in all warehouses.
bulletBoth on-line updating and batch processing.
bulletMultiple recording methods for receiving materials into inventory:  Direct Shipment, Material in Transit, Transfer, and Refurbished Parts.
bulletInventory valuation, using the average cost, standard cost, FIFO or LIFO methods.
bulletActual cost, standard cost, and sales prices can be maintained for each inventory item.
bulletSurcharges are selectively and automatically added for freight, warehouse overhead, etc., on the receipt, transfer between warehouses, and issuance of materials.
bulletEasy access to the inventory system by inventory code, supplier part number, user part number or customer part number.
bulletOn-line Activity Inquiry maintains historical data by warehouse code and inventory code.
bulletInventory Activity Selection Screen
bulletTransaction Inquiry by period
bulletInventory Reserved/Locked Detail
bulletInventory On Order Detail
bulletKeyword capability facilitates data entry, processing and reporting functions.
bulletMaterial Safety Data Sheet facility, which includes multiple detail screens for information maintenance on inventoried and non-inventoried items.
bulletProduct Review Entry (Approvals)
bulletSite Specific Data
bulletProduct Identification Data
bulletHazardous Components
bulletPhysical Properties
bulletFire and Explosion Hazards
bulletHealth Hazards
bulletReactivity Data
bulletSpill and Disposal Procedures
bulletProtective Equipment Requirements
bulletStorage and Handling Procedures
bulletTransportation Procedures
bulletSimple transfer of inventoried items between warehouses utilizing picking and packing lists.
bulletAlternate methods for adjustment of physical inventory shelf count and differences (shorts).
bulletDetails of material-in-transit from the supplier to the warehouse.
bulletTool issues and returns facility to record inventoried warehouse items issued to and returned by employees.
bulletInventory reservations for placing inventoried items in a reserved or locked status.
bulletInventory items can be issued to a specified cost account in the Cost Accounting module, work order in the Work Order module, unit of equipment in the Equipment module, or employee in the Payroll module.
bulletReorder and purchase requisitions are generated based on user-defined algorithm of inventory consumption to maintain stock at optimum levels.
bulletPurchase orders can be generated for non-stock items originating from a customer order in the order entry functions.
bulletOrder Entry function permits the recording of customer orders, selective generation of picking lists, printing of packing lists, and generation of accounts receivable invoices.
bulletCustomer Quotation Facility allows you to input, track and print quotes made to customers of inventory in stock.

Module Interface

The following System 20/20 modules send ( Þ ) transactions to and receive ( Ü ) transactions from the Inventory module.

Module Transactions Sent and Received
Accounts Payable Þ Purchase invoices
Purchasing Þ "On order" transactions
Receiving Þ Material receipts
Work Order Þ Inventory locks and reservations
Accounts Receivable Ü Customer order sales invoices,  credit memos for returned goods
Cost Accounting Ü Inventory issues
Equipment Ü Inventory issues
General Ledger Ü Material receipts, issues, transfers, surcharges, physical inventory adjustments
Payroll Ü Inventory issues (deductions for employee purchases)
Purchasing Ü Reorder requisitions
Work Order Ü Inventory issues

Reports

All standard reports provide multiple selection options.

Control File Section Listings Physical Inventory Worksheet
Material Master Physical Inventory Differences
Warehouse Master Negative Quantity Listing
Warehouse Master Catalog On Order Status
Warehouse Bin Labels Receiver Analysis
Warehouse Search Listing Inventory Investment reports
Inventory Code - Supplier Part Tool Issues Status
Supplier Part - Inventory Code Delivery Request
Inventory Code - Customer Part Warehouse Reorder
Customer Part - Inventory Code Inventory Stockout
Alternate Inventory Codes Sales Price Catalog
Inventory Code Components Confirming Order
Inventory Transaction Listing Customer Open Orders
Inventory Subledger Customer Backorders
Keyword Table Customer Completed Orders
Pending Transfers Customer Sales Analysis
Transfers Print Customer Quotations
Picking List Salesman Commissions
Packing List  

Construction Information Systems, Inc.

 
Copyright (c) 2001 Construction Information Systems, Inc.
P.O. Box 484
Mill Valley, CA  94942
415-332-5073
info@system2020.com