Customer Management Database/Inventory Control

Completed Posted Aug 30, 2006 Paid on delivery
Completed Paid on delivery

hello all,

This app is for a oilfield rental equipment company trying to better manage their inventory (2000 pieces +)

inventory tracking/web based application

Main admin should be able to set up other secondary level access accounts, and regulate functionality.

Items will be tracked using the following fields:

- Unit id#

- Unit Name

- Unit Catagory

- Unit Sub-catagory

- Manufacturer

- Year of Manufacture

- Serial #

- color (drop down choice)

- Unit Cost

- Repairs

- In service time

- Current location

- Down time (calculated by uptime difference)

- Current unit location

- misc notes

*** Ability to add/manage new unit tracking fields ***

Catagories:

Pumps

generators

light towers

shale tanks (drop down add-ons)

flock tanks (drop down add-ons)

Mats

Misc 1 - misc 5

*** Ability to add/manage new catagories and sub cats ***

Display info:

Unit current status

unit current location

lease time

rental time

repair time

yearly rental

long term rentals

Customer tracking

Name (first)

name (last)

company name

company email

company phone contact numbers (drop down)

fax numbers (drop down)

personal email address

personal phone

Head office location

head office phone number

head office fax number

customer notes

*** Ability to add/manage new customers and add fields ***

cross referencing:

- owner wants to be able to track each piece of equipment

by individual unit, catagory and sub-category.

- rental times for each unit

- most popular equipment rented

- cost/profit margin for each unit by time period

- cost/profit margin for each category by time period

- ....etc.

- (possible) may want to build in an invoicing module

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

unix or win

please provide benefit of .php over .asp :)

Database Administration Engineering Linux Microsoft MySQL PHP Software Architecture Software Testing SQL Windows Desktop

Project ID: #3766343

About the project

9 proposals Remote project Active Aug 31, 2006

Awarded to:

mziconsultinginc

See private message.

$361.24 USD in 88 days
(84 Reviews)
6.3

9 freelancers are bidding on average $320 for this job

NetzPro

See private message.

$340 USD in 88 days
(387 Reviews)
8.7
rattanisoft

See private message.

$340 USD in 88 days
(315 Reviews)
7.5
helvivw

See private message.

$425 USD in 88 days
(64 Reviews)
7.0
maeenul

See private message.

$255 USD in 88 days
(159 Reviews)
5.8
farukhzahoor

See private message.

$255 USD in 88 days
(50 Reviews)
5.5
achieversin

See private message.

$361.25 USD in 88 days
(4 Reviews)
4.0
vw2136664vw

See private message.

$267.75 USD in 88 days
(2 Reviews)
1.5
dotnetjunky

See private message.

$425 USD in 88 days
(0 Reviews)
0.0
ushopusa

See private message.

$106.25 USD in 88 days
(0 Reviews)
0.0