Product Management Features

The following are some of the major features included in the StreamV Product Management System.

      Centralized Product Catalog

      The Catalog file contains all items available for sale, regardless of whether the item is in stock or whether the item has been created in a specific warehouse location.

      Catalog information obtained from your vendors can be loaded directly into the system and updated as needed.  Items loaded into the Catalog file do not need to be created in a specific warehouse location unless you decide to sell, purchase, build or consume them.

      Integrated Imagaing and Document Storage

      Images, documents and other files can be created for each of your catalog items, and these documents can quickly be accessed and viewed from the Order Processing and other systems in StreamV.

      Multi-location Inventory

      Multiple Warehouse Locations are supported.

      Tools allow you to create a new Inventory Location with all items automatically generated from an existing Location.

      Automatically "normalize" selected attributes of items at different Locations.

      Transfer items between Locations.

      Online Inventory Lookups

      Transaction processing in StreamV is on-line and real time and the most current information about the item (on hand quantity, reserved, in bound and being built quantities) is always available.

      Complete Inventory Data Record

      Over 130 data items per record.

      Standard, Last, and Average Cost.

      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 and carton count.

      Shipping Code.

      Product Line/Group/Class codes.

      Bin location.

      Commission rate by item.

      Cycle count period.

      Up to 50 Character Item Number (smaller item numbers also supported).

      Alternate Item Number

      Exchange Item Number.

      Manufacturer's Item Number.

      Mass Price Updater

      Automatically updates prices using flexible equations 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.

      Serialized Inventory (optional)

      Allows for completely automated tracking of Serialized Items

      Track each serialized item by number, vendor invoice, your invoice and status.

      Serialize on receipt or sale.

      Physical Count Processing

      Print count tags and cycle count worksheets.

      Physical count entry screen.

      Actual vs. physical discrepancy report.

      Automatically create inventory adjustment transactions and General Ledger entries to account for discrepancies.

      End of Month Rollover

      Continue updating inventory while reconciling count.

      Update inventory with count Delta.

      Inventory Inquiry Screens

      Inventory Inquiry allows for quick access (view only) to vital information about any item at all locations, including open Purchase Orders.  Costs may be suppressed.

      Inventory Transactions

      All inventory activity from any module writes a record to the inventory transaction file completely describing the activity.

      Transaction look-up screen allows for quick review of inventory activity by item.

      Transaction Report lists all changes to inventory quantities for a range of dates for any or all Locations.

      Inventory Comments

      Unlimited comments to each item.

      Attach extended descriptions to each item for use by quotation and invoicing systems.

      Inventory Valuation

      Based on Standard, Last, or Average Cost for any or all Locations.

      By product line or by Vendor.

      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.

      Price Lists

      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. optionally create G/L journal entries to update the General Ledger to reflect inventory adjustment activity.

Integration with the General Ledger:

Integration with Bill of Materials (BOM): The BOM Module uses the inventory data for description and structure level control information.

Integration with Sales Order Entry (SOE): When orders are entered the reserved quantities are updated on quantity controlled items.

Integration with Invoicing (OC): When sales orders are invoiced or direct invoices are created, the quantity on-hand data and reserved data are updated.


Product Management Overview