Welcome Home

Warehouse Management - Stream V - Integrated Business Software

The Stream V Business Accounting Software Suite - Warehouse Management
Warehouse Management, Stream V Integrated Business Accounting Software Suite module with Stream V by Cove Systems Inc.
The Stream V Business Accounting Software Suite - Warehouse Management - The Most Accurate, Easy to Access, Real-Time Warehouse Option Available

 The Stream V Business Accounting Software Suite - Warehouse Management is completely integrated with the other modules in the Stream V Accounting System

Essential to profitable Distribution, Assembly, Manufacturing, and Wholesale operations

Inventory control is the cornerstone of any distribution business and it is essential to profitable Distribution, Assembly, Manufacturing, and Wholesale operations. Critical in managing inventory levels to control your company's budget and resources, is the ability to analyze data quickly and efficiently. To do this, the Stream V Warehouse Management System (WMS) maintains the most accurate, easy to access, real-time inventory available today.
Inventory control is the cornerstone of any distribution business and it is essential to profitable Distribution, Assembly, Manufacturing, and Wholesale operations.
(Warehouse Management Operations window)

Track inventory in multiple locations

Stream V Warehouse Management System has the ability to track inventory in multiple locations, either local or remote. The Stream V Warehouse Management System supports retail, distribution, and manufacturing environments for companies that prepare for future growth and need cutting-edge efficiency today. Inventory information in multiple locations can be updated by multiple operators simultaneously. Transferring inventory among warehouses takes place on-line to assure immediate availability at the destination warehouse.
Stream V Warehouse Management System has the ability to track inventory in multiple locations, either local or remote.
(It's so easy to track inventory)
More accurately reflect inventory availability
Companies shipping to remote warehouses can easily implement one or more "in-transit" warehouses to more accurately reflect inventory availability. A unique "normalizing" procedure synchronizes data (user definable) at multiple locations whenever an item record is modified in one location.

On-line, Real-time Inventory

The Stream V Warehouse Management System is an on-line, real-time, transactional system with activity pertaining to inventory recorded in an inventory transaction file. This provides management with the audit trail necessary to ensure correct product flow. Extensive reports can be produced from the inventory activity file for in-depth management analysis of stocking levels and usage requirements.

Tracking of on-hand, reserved (orders in house from customers), on order (orders placed with vendors), and work in process (WIP) is a simple and straightforward process. Quantities on order from customers are tracked both as "total reserved" and the quantity reserved for shipment in the current "scheduling window".
The Stream V Warehouse Management System is an on-line, real-time, transactional system with activity pertaining to inventory recorded in an inventory transaction file.
(Transferring inventory window)

Maximum amount of Flexibility and Integration

Extensive information is stored about each inventory item to provide the maximum amount of flexibility and integration with other Stream V modules. This inventory item information includes an alternate item number, color, size, version, extensive item notes, an unlimited length extended item description, numerous bits of shipping information, cycle count information and more. Over one hundred and thirty pieces of inventory information are stored for each inventory item.
Extensive information is stored about each inventory item to provide the maximum amount of flexibility and integration with other Stream V modules
(Extensive detail is stored for Inventory items)
Easy and fast access to your inventory data
Extensive on-line look-up screens and reporting facilities provide easy and fast access to your inventory data. Inventory reports include multiple inventory valuation reports, multiple price lists, and transaction reports. A "Mass Price Updater" allows you to set or change prices across a wide range of items based on various criteria.

Flexible enough to support your organization's unique needs, the Stream V Product Management Module tracks average weighed cost, last cost, and standard cost as well as retail and 10 price levels. Additional pricing flexibility is also available using the features provided in the Special Pricing System.
Efficiently manage warehouse operations in one or more inventory locations
The Stream V Warehouse Management System (WMS) allows you to efficiently manage warehouse operations in one or more inventory locations. The Warehouse Management System includes several different applications that are completely integrated with the entire Stream V Enterprise System. These applications streamline warehouse operations, improve accuracy, and provide your company with powerful tools:
  • Inventory Management
  • Inventory/PO Receiving
  • Bin Management
  • Inventory Allocation
  • Inventory Adjustment
  • Inventory Transfers
  • Inventory Counting
  • Safety Stock Management
Inventory Management
The Inventory Management programs allow you to create, maintain, and view Inventory Master records. Inventory Master records are used to define the items that you process in each of your warehouse locations. Each Inventory Master record stores the on hand, reserved, allocated and on order quantities for the item in the selected location as well as pricing and cost information about the item. You may not sell or purchase an inventory item until records for the item have been set up in both the Catalog Master and the Inventory Master files.
Inventory / Purchase Order Receiving
The Purchase Order / Inventory Receiving System is used to receive inventory quantities into the system and to post the value of the receipts to the appropriate general ledger accounts. The Inventory / Purchase Order Receiving system also records the serial numbers and bar codes of the items being received when appropriate. The Purchase Order / Inventory Receiving programs allow you to process receipts against existing vendor purchase orders, or to receive inventory that is not associated with a purchase order.
Bin Management
The Bin Management programs are used to identify and track the physical locations of the inventory items in your warehouse. The Bin management system maintains a record of each item/bin combination in the "BinLoc" or Bin Master file. The Bin Master records store the current on hand quantity of the item in the bin, and the quantity in the bin that is committed or reserved for the printed and unprocessed sales order pick tickets and shop order pull tickets for the item. As inventory transactions are processed, the bin management system updates the bin quantities (both the on hand and committed quantities) and it writes warehouse transactions to support the changes to each bin quantity.
Inventory Allocation
The Stream V Integrated Business system allocates available inventory quantities to the sales and shop order lines that are entered into the system and it tracks the allocated quantity of each item in the Inventory Master file. The allocated quantity for an item is the on hand quantity of the item that has been assigned or allocated to specific sales or shop order line items. Stream V automatically allocates inventory quantities as items are received into inventory and as shop and sales orders are entered into the system.

Stream V also allows you to manually allocate and de-allocate inventory as required. The Manual Allocation program is used to view and manage the allocated quantity for a specific inventory item. The Manual Allocation program displays the open and back ordered sales and shop order lines that have been entered into the system for the selected item, and the inventory quantity that has been allocated to each sales or shop order line. The Manual Allocation program also allows you to manually allocate and de-allocate the inventory quantity to and from the sales and shop order lines that have been entered for the item
Inventory Adjustment
The Inventory Adjustment program is used to adjust the on hand quantity of an inventory item and to post the value of the adjustment to the General Ledger. As each adjustment is processed, the operator is required to identify the bin in which the adjustment should be made, and the adjustment code that should be used for the transaction. The adjustment code is used to identify the type of adjustment being made and the general ledger account that the adjustment should be posted to. The Inventory Adjustment program only allows the quantity of an item to be adjusted if the quantity is available.

The adjustment program will not allow you to adjust an item quantity that is allocated to a sales order or shop order. The adjustment program will also not allow you to adjust a bin quantity that is committed to a pick or a pull ticket. The adjustment program can be used for situations in which an item has become obsolete and is being scrapped, or is damaged and needs to be written off. The adjustment program can also be used to adjust items for physical inventory count variances, but the Inventory Counting System is normally used to process these adjustments.
Inventory Transfers
The Inventory Transfer Program is used to process immediate transfers of inventory on hand quantities between inventory locations. The Inventory Transfer program allows the operator to select a source and destination warehouse and to select the items and quantities being transferred. As each item quantity is selected, the system prompts for the bin that the transferred inventory is being pulled from and transferred to.

Bin records can be created on the fly in the transfer program as required. As each inventory transfer is saved, the inventory in the destination warehouse is immediately available for use.

Note: If you are processing a non-immediate inventory transfer, and the goods will not actually arrive at the destination for a substantial amount of time, the Inter-Facility Transfer system should probably be used to process the transaction. The IFT system is documented as part of the PO or Purchasing System.
Inventory Counting
The Inventory Count System is used to perform complete or partial counts of the inventory in your warehouses and to create count records for quantities counted. The inventory count information is then used to identify items which have variances between the counted quantity and the on hand quantity stored in the system.

The Count System allows you to produce variance reports which list the items with differences and it also allows you to adjust the on hand quantities of the items to match the actual quantity counted.
Safety Stock Management
The Safety Stock Management System allows you to reserve specific inventory items and quantities for allocation to specific customers. The records that are created and maintained in the SAFETY file (File 214) define the items and quantities that are reserved in each warehouse for each customer. The total of the safety stock quantity for each warehouse/item combination is also stored in the Inventory Master record for each item.

If safety stock has been defined for a specific item, the system will not automatically allocate below the defined safety stock level for the item. When the on hand quantity of an item is not sufficient to fill the customer requirements from stock , and the order is a warehouse shipment (i.e. not a vendor shipment, or special order), the system backorders the sales order line for the item.

If the customer for the order has safety stock available for the item, the Manual Allocation program can be used to allocate the safety stock to any backordered sales orders for the item.
Seamless Integration
Seamless Integration with the rest of the Stream V Integrated Business Software
Online, Real Time Database Updates
Online, Real Time Database Updates in Warehouse Management for Stream V Integrated Business Software
Inventory Management System Features List
  • Allows you to quickly create Inventory or warehouse records from Catalog information. Records can be created automatically in a specified list of locations as each new catalog record is saved, or as required

  • Automatic Normalization. Changes to catalog records are automatically copied down to the warehouse records for the item as appropriate. A Normalization file allows you to specify which fields are maintained at the Catalog level and which fields are maintained at the Inventory level (when the field can be maintained at either level).

  • Automatic loading of user-definable default information into new inventory records. This option speeds up data entry for new items. The default information from the Catalog file is copied down to any fields in the new inventory record that are named the same, then the inventory default information is applied (allowing you to add additional default info for fields that are not maintained at the catalog level).

  • Field Level security can be used to control access to specific fields in each Catalog, Inventory or Warehouse record. Fields that are maintained in the Catalog file are automatically blocked in the Inventory Manager and fields maintained in the Inventory Manager are blocked in the Catalog Manager.

  • PO/ Inventory Receiving Program

  • The PO/Inventory Receiving program allows you to quickly receive against an existing open purchase order, or to receive inventory without using a purchase order.

  • The PO Receiving program requires the operator to enter the serial numbers for any serialized items being received, and it verifies that the correct number of serial numbers are specified for each item, and that the serial numbers being entered are not duplicates.

  • As each transaction is processed, the system automatically updates the inventory quantities for the item, it posts each receipt to the general ledger, and it allocates the items received to any sales or shop orders that are waiting for the product

  • Supplemental costs such as freight, duty and customs fees can be added to the cost of the items being received. Options allow pre-defined freight adder amounts to be automatically added to the item cost during receiving, or the system can be configured to allow the user to specify supplemental costs manually during the receiving process

  • The cost of the items received is used along with the current on hand quantities for the item to calculate a new average cost for the item. This average cost is normalized across any inventory locations that are in the same division being processed

  • Inventory Activity records are automatically created by the system to record the changes to the cost and quantity of each item from the receiving transaction, and to allow matching of the receiving detail to the vendor invoices for the items (this option is referred to as Three Way Matching and it is discussed in detail in the documentation for the Accounts Payable System).
Bin Management System Features List
  • Multiple bins can be created and maintained for a single item in a single warehouse

  • Bin records can be created on the fly as required when processing bin transfers, inventory transfers, or inventory adjustments

  • A default bin can be defined for each inventory item in each warehouse location, and the system can be configured to automatically use this default bin during operations

  • If the system is being run in "default bin mode" the default bin is automatically suggested if it does not already exist when you create a bin for the item. The default bin for the item can also be created automatically if required (without operator intervention during receiving and other operations).

  • A Bin "Committed" quantity ensures that the bin on hand quantity cannot be reduced below the amount committed to printed documents such as sales order pick tickets and shop order pull tickets

  • Bin Reconciliation programs identify items with on hand quantities that do not agree with the bin quantities, or items which have a committed quantity not equal to the printed and unprocessed documents for the bin. These reconciliation programs can be run manually or automatically in the Job Processor
Inventory Allocation/Manual Allocation Program Features List
  • Items can be set up to automatically allocate available quantities, or to require manual allocation

  • Sales and Shop orders are allocated to based on the scheduling window that is maintained for each item

  • The Manual Allocation Program allows you to view the open and backordered sales order lines and the open shop order lines for a specific item, and to manually allocate to or de-allocate from specific sales or shop order lines

  • Stream V blocks allocation changes to any printed shop or sales order lines - forcing you to reset any related documents prior to modifying the allocated quantities for the order

  • Available quantity takes safety stock into consideration

  • An allocation hold can be placed on sales orders when they are allocated to a specified period of time after the scheduled date for the sales order (to allow you to verify if the customer still wishes you to ship the goods
Inventory Adjustment Program Features List
  • Controls prevent users from reducing item quantities that are allocated to open sales or shop orders. If an item quantity needs to be reduced below the un-allocated quantity for the item, the sales orders or shop orders must be de-allocated from first

  • Controls prevent users from reducing a bin quantity below the quantity already committed to printed but un-processed sales order pick tickets or shop order pull tickets

  • A User-defined Inventory Adjustment Code Table allows you to specify the valid adjustment codes that can be used on the system and where these adjustments should be posted in the General Ledger. This allows warehouse personnel to correct quantity errors and the accounting department to control where the adjustments will be posted

  • An Inventory Activity record is created by the program to document the quantity change to each item. This inventory transaction record contains detailed information from the inventory item at the time the adjustment was made, as well as the adjustment code and journal entry used for the transaction

  • A Warehouse Transaction record is created by the program to document the change to the bin being adjusted
Inventory Transfer Program Features List
  • Immediately transfers inventory quantities from one inventory location to another. The Transfer program allows you to select the warehouse and bin from which the transfer quantity will be pulled and the destination warehouse and location that the item will be transferred to

  • Detailed Inventory Activity records are created to record each inventory transfer transaction

  • The Inventory Transfer program blocks the transfer of allocated or committed quantities. You may not transfer inventory quantities that have been allocated to sales or shop orders. You may also not transfer any quantities that have been committed by the Bin Management system. If you wish to transfer allocated or committed quantities, the system forces you to de-allocate the appropriate quantity and or reset any printed documents before processing the transfer

  • Note: The StreamV System also allows you to process Inter-Facility Transfers or IFT's. Inter-facility transfers are transfers between warehouse facilities that are not in the same physical location and IFT transfers allow you to track shipments while they are in transit between warehouses. The IFT system is described in more detail in the documentation
Inventory Count System Features List
  • o Supports complete or partial ("cycle") counts of the inventory in one or multiple inventory locations. Multiple operators can participate in a single count

  • o RF (hand-held radio frequency) device support, and highly efficient data entry programs allow accurate count data to be collected and input into the system with a minimum amount of work

  • o Pre-count Inventory and Bin quantities are stored at the beginning of the count process to minimize disruption to other warehouse operations such as invoicing and receiving

  • o Count adjustment transactions are written to both the Inventory Activity and the Warehouse Transaction files to document the changes made to each item and bin. Count transactions are included in the comprehensive history that is maintained for each item in your inventory
  • o Completely integrated with General Ledger and other Stream V applications. Count adjustments are posted to the general ledger automatically as they are processed
Warehouse Management Operations List
Some of the primary tasks or business processes that can be performed using the Warehouse Management Operations programs include.
  • Viewing Inventory quantities, costs and other related information
  • Editing the Inventory Information for existing items
  • Receiving Inventory against the purchase orders that have been issued to your vendors
  • Creating and Maintaining Bin records
  • Processing Inventory Quantity Adjustments
  • Processing Bin Transfers
  • Processing Inventory Transfers
  • Processing Inventory Cost Adjustments
  • Processing Inventory Counts
  • Processing Pending records - The Pending Management program allows you to track and process the open Pending items that are used created when customer loaners, ticket billing invoices, vendor returns, and inter-facility transfers are processed
  • Inventory Management
  • Inventory Detail
  • Pending Management
  • PO Receipt
  • Bin Management
  • Bin Detail Panel
  • Bin Transfer
  • Inventory Adjustment
  • Inventory Transfer
  • Inventory Average Cost Adjustment
Warehouse Management Lookup Programs List
The programs on the WMS Lookup Menu are primarily used to view Inventory, Bin and Catalog information. The WMS Lookup menu also includes some programs that can be used to view open customer sales orders and vendor purchase orders.
  • "drill down" through transaction activity
  • Bin Lookup
  • Picks for a Bin Lookup
  • Inventory Transaction Detail Panel
  • Warehouse Activity Lookup
  • Pending Detail Panel
  • Loaner Detail Panel
  • Item Demand
  • Receipts Lookup
Warehouse Management Report Programs List
Generate Inventory Valuation reports that can be used to view current inventory quantity and cost information. Generate Inventory Valuation and Activity reports that can be used to proof the changes to each of your Inventory Subledgers and to verify or proof the inventory control account balance in the general ledger.
  • Inventory Valuation
  • Inventory Valuation Aged
  • Inventory Valuation with Two Breaks
  • Inventory Listing
  • Inventory Transactions by Date
  • Inventory Transactions with Two Breaks
  • Aged Pending Inventory

Recent Features and Enhancements to this Module
  • Warehouse Management: Updated to set above pick list queries.
  • Warehouse Dashboard: Added two required Gencode tables: WMSMANGR & WMSTAFF.
  • Warehouse Dashboard: Released new version.
  • Added warehouse activity lookup to context menu.
  • Added new Waretran Query to Warehouse Management Lookup Menu.
  • Improved Waretran information by adding previous quantity and new quantities to Waretran record and modifying code in RF system to load.
  • Added options on the Warehouse Dashboard to select current SQL queries for RF picking.
  • Inventory: Enhanced warehouse pick system.
  • Routing: Added routing option to More Menu on AR Query.
  • Added code to show originating warehouse on the maps
  • Added options to Zipcode Management to load zip code records with warehouse location based on zip code or state, and to load Tax codes based on Zip code or State.
  • Picklist Management: Renamed object from oOnDemandPicklist to oPicklistManagement for consistency.
  • Picklist Management: Converted from Browse to SQL Query.
  • Bin Management: Modified Bin Detail to update qty_free on save.
  • Pick List Processing: Enhanced pick list processing.
  • Pick List Processing: Added support to handle cart full, short quantities at bin pick time giving the operator the choice of short picking, and/or picking from alternate bins.
  • Pick List Processing: Converted ready picklist queue, batch order sequence and bin select to SQL queries in the RF module.
  • Pick List Processing: Added code to allow dropping a full cart/pallet and staying in the same batch.
  • Pick List Processing: Added code to create box records from the Pick file instead of the Soline file and to carry the tote number through the staging area and into the manifest (box) records for use by EDI 856 Advanced Shipment Notice.
  • Pick List Processing: Modified code to automatically restrict batches to a single order for LTL shipments based on the carrier-type in the Shipvia record.
  • Pick List Processing: Added options on the Warehouse Dashboard to select current SQL queries for RF picking.
  • Pick List Processing: Added code to cause pick lines be for no more than a pallet of goods based on the std_pallet field in the catalog.
  • Kits: Added code to display kit availability in the Inventory Management Context Menu.
  • Kits: Converted to SQL Query to get grid output.
  • Kits: Added kit availability to the Product Availability Panel; a dialog pops up from order entry.
  • Picking: Changed non-pickable bin name format from RDxxxxx to x-xxxxxx
  • Picking: Policy added: F248:PICKALLF. Which, if set to “Y” will commit items from the first bin that all can be committed from. If impossible, it will start committing from lowest bin quantity up.
  • Bin Detail: Fixed code to use correct index when reconciling committed on bin detail panel activation.
  • Batch Pick List: Added totals to bottom of pick list.
  • Pick flow: Updated documentation.
  • Pick Query: Added context menu option to see what other bins an item is located.
  • Pick Query: Added an option to change the bin for a pick line.
  • Pick Query: Code to change a bin will split the line if the quantity changed is less than the pick line quantity.
  • Pick List Management: Added “Reset All” option to reset pick list; it is only available to sysops.
  • Routing: Added routing option to More Menu on AR Query.
  • Routing: Added code to show originating warehouse on the maps.
  • Truck Routing: Added option to invoice lookup to select multiple invoices and output an optimized truck route. Process is to tag invoices to route.
  • Truck Routing: The system displays a map of the Google route and the user can change the sequence and reproduce the map.
  • Truck Routing: The system generates a reverse sequence truck loading list.
  • Print Pick List: Added text advising operator
  • Shop Floor: Modified code to set shop line printed flag to "N" when resetting a pull ticket.
  • Shop Manager: Enhanced index 4 and index 5 to show highest shop order or sales order number first (descending sequence).
  • Shop Manager: Enhanced Browse search logic.