I need an internal inventory web-based app for ordering supplies for 3 offices. Ideally this involves:
-mobile responsive, ability to add items from an ipad.
-Multiple sites , able to move inventory between sites
-barcode scanning preferred
-up to 1000 skus
-budgeting / forecasting
-storage bin locations for items
-ability to scan or manually enter usage
-low inventory monitoring, automatically trigger new requisition
-universal search by name, internal sku, vendor sku, category, vendor, price, storage bin, site location, etc
-workflow: add the items to requisition(per site) => manager approval => automatically creates purchase orders for each vendor=> emails vendor if set to auto email (or manually mark "sent" if ordered online or via phone => mark as received when received => update quantities, mark back ordered items, cross check invoice pricing vs database of historic pricing (alert if price change) => automatically update inventory to reflect new stock.
-keep historic data to track pricing and frequency of ordering
-alerts for low inventory
-monitor all inventory
Tables: vendors, storage bin, locations, items, purchase orders , received orders, requisitions, users
-item details: name, description, last order date, inventory per site, storage bin per site, vendor , price, internal sku , barcode, vendor sku, photo
-set it up on a hosting site
Milestone 1: Show front end design mockup, not functional
Milestone 2: Show functioning demo of add/remove items, supplies, categories, item details, framework
Milestone 3: Show fully functional app, some minor bugs allowed
Milestone 4: Deploy to host and use functionally without critical bugs, meeting all interface requirements including design and fonts
Mielstone 5: 30 days of constant minor tweaks and minor bug fixes.