Take a look at my excel spreadsheets and try to troubleshoot the formulas.
It is a simple inventory management for our church office to monitor various supplies, etc. We need the following features working properly:
* "stock-in" and "stock out" data entry shall be done using a usb barcode scanner (where it also automatically populates the date/time cell)
* ability to add new products (and their respective barcodes); and have these automatically sorted (first by category, then alphabetically, then by cost) on the master list of products
* auto-generate a purchase order (one for each vendor), when the stock level falls below the minimum set quantity.