Inventory Management System - Similar to weberp

Inventory Management System - Similar to weberp is project number 168353 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider softlance
Budget:	$300-1500
Created:	08/15/2007 at 17:26 EDT
Bidding Ends:	08/30/2007 at 17:26 EDT
Project Creator:	redgui   Buyer Rating: (2 reviews)
Description:	Its an php/msql based inventory management system. Similar to weberp application with modified look and feel and easy navigation with the requirements as listed below from 1 to 8. Modules that are particular of interest from weberp are Main, Items, Suppliers, Manual, Logout Under Main we need: Payables, Purchases, Inventory, Setup. This module will be integrated with internal master application. We do have quiet a bit of modules in master application as well. Looking for a highly skilled individual or a company who has experience in health care information systems and php/mysql whom we can partner for development. Preference will be given who can demo similar type of system. Please quote your hourly rate as well. php/mysql based inventory management system requirements: 1. Ability to view/add/modify/delete suppliers thru GUI and also upload it thru csv file. 2. Ability to group the items thru Category. (view/Add/Modify/Delete Categories) thru GUI and also upload it thru csv file 3. Ability to add/modify/delete items to/from categories (select and click arrows type) thru GUI and also upload it thru csv file 4. Ability view/Add/Modify/delete items thru GUI and also upload it thru csv file 5 Ability to track order history, POs and usage history. 6 Search and filter for suppliers, items, categories. or show all. {Supplier Name, Category, Item, List price, discounted price} 7 Alert the admin (send email and red color on screen on item) on expired items. (Think as medications which are expired cannot be used) 8. Inventory reports. How Many units are there in stock? What suppliers are supplying what categories that are in stock Send email and display on gui on low stock or on expiration date? (based on configurable stock qty or prior to expiration date). What is the total amount purchased from the supplier with given dates? and details of the purchases. (order summary} What is the item summary that was ordered so for and what is used so for? Prefer a gui template to add report data into gui ability to generate the reports into PDF and save as csv file. - Supplier can supply multiple categories and multiple items. - Screen Layout with CSS style {ability to change the colors, fonts etc at one place) Please quote how much would you charge extra for barcode scanning for inventory Ex database tables to get you an idea SupplierDetailsTable{...} Item or product Table{Item Internal code, facilityID, CategoryID, size, Characteristic 1, Characteristic 2, Characteristic 3, Characteristic 4} Facility Table {Facility ID,Facility Desc} Category Table {Category ID, Category Desc} Supplier and Item assoc {Date, SupplierID,Item internal code, Item Externalcode, OrderedQty, qtyinstock, Msrp price, Discount Price, Purchased Price, Discount %} ORDER Table {..} ORDERHistory Table{..} CurrentStock Table{,,} ItemUsageHistory{Date,Item internal code..} Deliverables and payment details: Payment will be through GAF escrow - Scope out detail requirements and plan and accepted. - 5% - Screen layout and navigation complete (Html design)- 20% - with database design Database ER diagram - 10% - First working prototype - 25% - Complete the project with bug free - 40% I need this project completed in 3-4 weeks.
Job Type:	PHP
Database:	MySQL
Operating system:	(None)
Bid count:	42
Average bid:	$ 1223