Inventory Control

Inventory Control Overview:

The Inventory Control Package is designed to either operate stand-alone or in conjunction with the OrderProcessing/Invoicing and/or Purchasing Packages. It provides for multiple warehouse locations and can function in a multi-company environment. All inventory items can be easily accessed by keying in a partial description of the item, the item number or a user defined keyword for the item. Item pricing may be by quantity break, product class or any one of six different price levels. Serial number/warranty tracking is optionally available for each item. Serial numbered and non-serial numbered items are both handled by the package and both types of items can coexist in the system at the same time.

Inventory Control Features:

  • Each item may be priced by quantity break, product class or any one of up to six different price levels.
  • Items may be accessed by keying in either the item number (up to 14 alphanumeric characters), a partial description of the item (up to 29 alphanumeric characters) or a user defined ‘keyword’ (up to 16 alphanumeric characters). In those cases where multiple items may share the same partial description or keyword, a qualifier may also be keyed in for a more specific selection. For example, keying in ‘BOLT’ will cause all bolts to display, whereas keying in ‘BOLT, BRASS’ will cause only brass bolts to display.
  • Each item may optionally have multiple line descriptions, providing for more detailed item descriptions when necessary.
  • Items may be stocked in one unit of measure and priced in another (i.e. stocked by the ‘foot’ and priced by the ‘hundred feet’).
  • Items may be costed either by standard cost, average cost or last cost
  • Automatic conversion from purchase unit of measure to stock unit of measure occurs at inventory receipt time.
  • Provides automatic conversion from stock item number to primary vendor item number for purchasing purposes.
  • Provides for unlimited vendors for purchasing.
  • Maintains summary vendor price quotes and last purchase price by date, for all vendors for each item.
  • Provides detailed information on vendor price quotes and last purchase in order to be able to always purchase from the most appropriate vendor (i.e. quickest ship, least expensive, best payment terms).
  • Optional provision for substitute items.

Main Warehouse Features:

  • Provides for multiple warehouse locations and/or companies.
  • Provides for warehouse transfers.
  • Provides the following information for each item:
    • product class code
    • unit weight
    • primary vendor number
    • taxable or non-taxable item status
    • item is serial numbered or non-serial numbered
    • substitute item number
    • item is discontinued or not
  • Provides the following information for each warehouse location:
    • quantity-on-han
    • quantity allocated to in-house, unfilled orders
    • quantity on customer backorder
    • quantity on order from vendors
    • quantity on backorder from vendors
    • due date and P.O. number of most recent Vendor order
    • quantity sold month-to-date and year-to date
    • bin number
    • last issue date

Item Serial Number/Warranty Features:

  • Provides optional serial number/warranty tracking for each item.
  • Serial number/warranty tracking information that is retained, includes:
    • Item number and Serial number
    • Item current location code (warehouse or customer site)
    • warehouse/bin location (if in the warehouse)
    • vendor number
    • status code (new or used)
    • comment
    • Purchase data:
      • date purchased and cost
      • warranty start date
      • purchased new or used
    • Sales data
      • order/backorder number
      • invoice number, date and sell price
      • customer number shipped to and billed to
    • Trade-in data
      • trade-in date, cost and customer number
      • Allows stock inquiry for all warehouses