Key Features

The Inventory 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.

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.

Provides for multiple warehouse locations and/or companies.

Provides the following information for each warehouse location:

quantity-on-hand

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

Provides for warehouse transfers.

Provides the following information for each item:

product class code

unit weight

primary vendor number

taxable or non-taxable item

serial numbered item or non-serial

numbered item

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:

Inventory File

Warehouse File

Product Class File

Provides optional serial number/warranty tracking for each item. Serial number/warranty tracking information that is retained, includes:

Serial number data

item number

serial number

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

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.

Optionally interfaces to Order Processing and/or Purchasing