TheInventory Control Package is designed to either operate stand-alone or in conjunction with the Order Processing/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.
Main Package Features:
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.
Each item may be priced by quantity break, product class or any one of up to six different price levels.
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 the following information for each warehouse location:
quantity allocated to in-house, unfilled
quantity on customer backorder
quantity on order from vendors
quantity on backorder from vendors
due date and P.O. number of most recent
quantity sold month-to-date and year-to
last issue date
Provides for warehouse transfers.
Additional Item Features:
Provides the following information for each item:
product class code
primary vendor number
taxable or non-taxable item
serial numbered item or non-serial
substitute item number
discontinued item or not
Inventory Status Report
Costed Inventory Report
Inactive Items Report
Recommended Reorder Report
Physical Inventory Worksheets
Inventory Transaction Listing
In-stock Serial Inventory Listing
Master File Listing for the following Files:
Product Class File
Main Serial #/Warranty Features:
Provides optional serial number/warranty tracking for each item. Serial number/warranty tracking information that is retained, includes:
Serial number data
location code (warehouse or customer site)
warehouse/bin location (if in the warehouse)
status code (new or used)
date purchased and cost
warranty start date
new or used
invoice number, date and sell price
customer number shipped to and billed to
trade-in date, cost and customer number
Allows stock inquiry for all warehouses.
Optionally interfaces to Order Processing and/or Purchasing