The Inventory application maintains a master inventory file including description, size, classification, location, high/low limits and reorder point. Additional data is maintained interactively for quantity on order, quantity on hand, last unit cost, average cost, value, average usage for a specified number of months and dates of the last order, receipt and issue.
A detail record of the transactions for each item is kept on file and may be viewed at any time. Transaction types are orders, receipts, issues and adjustments. Actual costs are kept for all receipts. Items may be issued on a first-in-first-out basis, last-in-first-out or average cost.
Preferred vendor information may be maintained for each inventory item including vendor name, vendor's part number, manufacturer's name and manufacturer's part number. Up to six preferred vendors may be recorded for each part and used for reference or, if the Requisition software is active, for automatic generation of requisitions.
Inventory items may be accessed by part number, classification, size, location, description, vendor, manufacturer or purchase order number. Inventory master information is displayed with options to view detail transactions for pending and processed orders, receipts, issues and adjustments.