Welcome Home
The Stream V Business Accounting Software - Integrated Inventory Control, Integrated Inventory Management
The Stream V Business Accounting Software - Integrated Inventory Control, Integrate Inventory Management by Cove Systems Inc.
Inventory Control, Inventory Managemetn in Stream V Business Accounting Software, Accurate, Real-Time & Multi-Location is Essential to Decrease Inventory Investment

Integrated Inventory control or Integrated Inventory Management is the cornerstone of any distribution, reseller and retail business and is essential to profitable operations. The ability to analyze data quickly and efficiently is critical to managing inventory levels in order to control your company's budget and resources. The Stream V Inventory Management module maintains the most accurate, easy to access, real-time inventory available today.
Timely Inventory Information = Profits
Inventory control is the cornerstone of any distribution, reseller and retail business and is essential to profitable operations. The ability to analyze data quickly and efficiently is critical to managing inventory levels in order to control your company's budget and resources. The Stream V Inventory/Warehousing module maintains the most accurate, easy to access, real-time inventory available today.
Multi-location Functionality
The Stream V Inventory module allows the use of unlimited warehouse locations. Multiple operators can update inventory information in multiple locations simultaneously. Transferring inventory among warehouses takes place on-line to assure immediate availability at the destination warehouse. Companies shipping to remote warehouses can easily implement the Inter-Facility Transfer System to more accurately reflect inventory availability.
Transactional Processing
The Stream V Inventory Control module 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'.
Vendor Link
Vendor Link allows customers with online access to their vendors' order processing systems to check real-time inventory price and availability (P&A) with the vendor(s). The primary purpose of this system is to recoup the significant amount of time spent checking P&A by the sales staff in a brokerage environment. The vendor provided interfaces checked to date also allow purchase order placement automatically. This would allow for an even higher degree of automation with primary vendors and further reduce costs.
Multi-location Inventory
  • Multi-location Inventory
  • Multiple warehouse locations both logical and physical.
  • Create a new inventory location automatically generating all items based on any existing location. Pick and choose the location in which individual items will be created.
  • Automatically "normalize" selected attributes of items at different locations.
  • Easily transfer items between locations and bins.
WIP Transactions
  • All shop order transactions are accounted for by WIP quantity.
  • WIP valuation based on open shop orders.
  • WIP system respects BIN locations and physical warehouse locations.
Serialized/Lot Number Inventory
  • Allows for completely automated tracking of serialized items.
  • Track each serialized item by owner, buyer and location.
  • Tracks serial numbers in and out based on parameter settings.
  • Serialize on receipt or sale.
16 Character Item Number
  • Alternate item number.
  • Exchange item number.
  • Manufacturer's item number.
  • Xref Item Number.
Complete Inventory Data Record
  • Over 130 data items per record.Default file allows for ease of data entry.
  • Standard, last, and average cost.
  • Last PO price, Last Received price.
  • Interstat compliant for EU reporting.
  • Extensive on-line statistics.
  • Indicate items as taxable or non-taxable.
  • Automatically tracks quantity in stock, reserved in the "scheduling window," total reserved, and on order for each item.
  • Automatically tracks month-, quarter- and year-to-date sales, receipts, revenue, and cost for each item.
  • Multiple unit of measure levels; pack, carton, case, pallet and truck.
  • Weight, volume (cube) and carton count.
  • Shipping Code.
  • Product line/group/class codes.
  • ABC tracking.
  • Default bin location or random bin selection.
  • Commission rate by item.
  • Cycle count period.
Physical Count Processing
  • Print count tags and cycle count worksheets.
  • Physical count entry screen.
  • Count variance report.
  • Multiple recounts allowed.
  • Count variance report includes bin information for easy recount.
  • Count discrepancies are easily corrected on line.
  • Set up programs allow for cycle count by bin, range of item numbers, or range of descriptions.
  • Automatically create inventory adjustment transactions and General Ledger entries to account for variances.
  • Actual vs. physical discrepancy report.
Inventory Transactions
  • All inventory activity from any module writes a record to the inventory transaction file completely describing the activity.
  • Transaction lookup screen allows for quick review of inventory activity by item.
  • Transaction report lists all changes to inventory quantities for transaction types for a range of dates for any or all locations.
Pending Transactions
  • Track inventory you own but don't have possession of. Including loaners, samples, and items returned to vendor.
  • Select from multiple disposition options when inventory is returned.
  • Create A/R Invoice, Create A/P Credit, Return to inventory, Write Off.
Bin Management
  • Tracks unlimited BIN locations per item.
  • Automatic default of bin location if specified in item master.
  • BIN management tracks:
  • Unit of measure.
  • Quantity committed.
  • Quantity on hand.
  • Quantity free.
  • Last activity.
  • Last movement.
Inventory Inquiry Screens
  • Option to sequence the panel by Item number, manufacturer item number, manufacturer, vendor, UPC item number, description, or product line.
  • View alternate location information.
  • View PO's on highlighted part number.
  • BOM can be viewed if manufactured number.
Expanded Information
  • Extensive information is stored about each inventory item to provide the maximum amount of flexibility and integration with other Stream II modules.
  • Information provided includes, but isn't limited to: XX
  • Alternate item number, Color, Size, Version
  • Extensive item notes unlimited length
  • Extended item description
  • Shipping information tracked through various data fields
  • Cycle count information
  • Over 130 pieces of information are stored for each inventory item.
  • Other Features
  • Extensive on-line lookup screens. XXX
  • Reporting facilities.
  • The Mass Price Updater allows you to set or change prices across a wide range of items based on various criteria.
Reports
  • Print, display or send to a disk file.
  • Inventory master listing.
  • Inventory valuation, by warehouse, vendor, product line, manufacturer, pending items, and many more options.
  • Aged inventory valuation.
  • Inventory transactions reports by all transaction types.
  • Internal and external price sheets.
Costs and Prices
  • Average weighted cost.
  • Last cost.
  • Standard cost.
  • Last PO price paid.
  • Commission cost.
  • Retail price.
  • See Special Pricing document for more extensive pricing options.
  • Multiple Price Lists based on any combination of retail, the 10 price levels and 3 costs.
  • Print in sequence of Item number, Description, or Manufacturer.
End of Month Rollover
  • Continue updating inventory while reconciling count.
  • Update inventory with count Delta.
Mass Price Updater
  • Updates prices using flexible selections based on Standard, Last, Average Cost, or Retail.
Extensive Price Options
  • Retail plus 10 price levels for each item.
  • Optional Special Pricing Module allows for custom prices based on Customer/Quantity/Date Range.
  • Optional Contract Pricing allows multiple customers to be assigned to a contract for special pricing.
Inventory Comments
  • Unlimited comments to each item.
  • Attach extended descriptions to each item for use by quotation and invoicing systems.
Lot Number Tracking
  • Items can be flagged as requiring "lot numbers".
  • A "lot number" indicator can be used to default a lot number by item during invoicing and other consumption activities.
Extensive Reports
  • Reports may be displayed on the screen, sent to the printer, or routed to a file.
  • Select items by Product Line, Group, Class, Type, Sales Category, and many other criteria.
Inventory Valuation
  • Based on Standard, Last, or Average Cost for any or all Locations.
  • By product line or by Vendor.

Recent Features and Enhancements to this Module
  • Inventory Management: 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 lot number field to pick record, and code to prompt for lot during picking.
  • Inventory Management: Alphabetized Menus.
  • Inventory Valuation Report: Converted to Grid Output.
  • Inventory Valuation Report with 2 Breaks: Removed from system since Inventory Valuation Report can be run in Body Only mode and exported to Excel.
  • Inventory Adjustment: Modified to not require bin for support of RF bin system.
  • Inventory: Enhanced warehouse pick system.
  • Inventory: Added Daily Demand bucket reconciler to Reconciliation view off System Admin reconciliation menu.
  • Added Weekly/Monthly bucket reconciler to Reconciliation view off System Admin reconciliation menu.
  • Added Daily Demand refresh button to Item Detail. See Inventory Replenishment application note.
  • Added Daily_Demand, Max_qty and SeasonalCode to Inventory Detail Panel.
  • Inventory Management: Updated code to refresh screen after allocating inventory.
  • Inventory Management: Enhanced context menu option to allocate available inventory to an item.
  • Inventory Adjust: Fixed timestamp in comment.