Encerrado

Truck tracker

MS Access or Intranet based database to track a variety parts shipped via several trucks to a vendor or to the construction site.

The original system was built using a DOS database many years ago in a couple of days and was used until a while back when the computers were replaced.

We need to collect the following information for each Job: job name{15}, customer{25}, start date{date}, target completion date{date}, ship-to-address

Section I

1. Drawing #{10}, [Item{10} (lookup1), description{60}, weight{#}], quantity{number}, source{15} (lookup2), comment{60}, origin{15} (lookup3)

2. Die #{10}, Length{number} (feet and inches to [url removed, login to view]). finish{15}(lookup4), quantity{number} and comment{60}

3. Set a job active or inactive.

Add all of the entries together so the total number required is accumulated for each item and stored when changed.

## Deliverables

Section II

Collect information about a given delivery truck:

1. Source{15}(lookup2), destination{25}(lookup5), shipper{25}(lookup6), date shipped{date}

Section III

Load items on a truck:

1. Select from the items from Section I, view the quantity to be shipped, enter the quantity shipped, deduct that from the total number store the new total number.

Reports to see:

All items for a job, all jobs in the system, all trucks for a job, all items on a truck, items to be shipped for a job, all items to be shipped. Total weight of a truck, for an individual item all drawing #s that apply, for an individual item all jobs that apply, for an individual item and job, which truck is it on, We want to colorize the report by source so it is easily visible. On reports relating to items from Lookup 3, display the appropriate color background for the first or second column of the report.

This will be a working system, used by professionals who are familiar with the data and perhaps data entry people, so the ability to use the system with speed such as a spreadsheet data entry where the passable items are visible and only the numbers need to be entered for each can be 123, tab or down arrow, 123. In addition to a record by record entry form.

Access 2003 and an Intranet are available so it could be web based. The number of users could be as many as 7 at the same time, but more often 1-2.

The number inside the {}s are estimated field length to hold what we need as I know it at the moment.

Lookup Details:

1. Extract from Inventory database, items can be added on the fly.

2. A small number of locations GT and other sources of material.

3. 4 Items right now, Fabricated(Blue), inventory{yellow}, Direct Ship(green), Outsourced item(Orange)

4. 5 items right now, Mill, Painted, Anodized, Abraided, Galvanized

5. Job site names (perhaps from the Jobs table and some vendors sites when items sent to be galvanized on the way to the job.)

6. Name of shipping companies used (perhaps a small table with particulars phone, contact person, comments about the shipper)

Version 1.c dated 6/6/08 9:28 AM

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).

* * *This broadcast message was sent to all bidders on Friday Jun 20, 2008 7:22:49 AM:

Additional information: We have MS Windows Server 2003 for Small Business Server with Service Pack 2 that is primarily used for file sharing. We would be willing to add software to support local processing. Our website is capable of MySQL. The only data we expect to import will be a "one-time" of the existing inventory, from Access.

## Platform

Windowqs Xp and Up on MS Access 2003 and Up.

Habilidades: PHP

Ver mais: windows phone jobs, website people bid jobs, website hire professionals, website customer service jobs, web customer service jobs, table jobs, trucks hire, truck jobs, truck hire, time tracker desktop, target item number lookup, spreadsheet engineering, sources information buyer, site engineering jobs, section one computers, parts inventory database, outsourced server, outsourced professionals, outsourced support, outsourced engineering jobs, outsourced desktop support description, outsourced database, new hire report form, ms lookup, access parts inventory database

Acerca do Empregador:
( 0 comentários ) Riverview, United States

ID do Projeto: #3002510

50 freelancers estão ofertando em média $593 para este trabalho

itgurussoftware

See private message.

$470.05 USD in 14 dias
(139 Comentários)
8.4
fastudiovw

See private message.

$552.5 USD in 14 dias
(731 Comentários)
7.5
evisionisfvw

See private message.

$765 USD in 14 dias
(27 Comentários)
7.4
techfirstvw

See private message.

$680 USD in 14 dias
(179 Comentários)
7.2
asselsolutions

See private message.

$595 USD in 14 dias
(65 Comentários)
7.1
tjlTOM

See private message.

$765 USD in 14 dias
(266 Comentários)
6.7
suthernsoftware

See private message.

$637.5 USD in 14 dias
(62 Comentários)
6.6
ritzdigitals

See private message.

$765 USD in 14 dias
(89 Comentários)
6.5
Premshanks

See private message.

$722.5 USD in 14 dias
(355 Comentários)
6.5
branislavm

See private message.

$552.5 USD in 14 dias
(259 Comentários)
6.5
SaneliteTechnolo

See private message.

$612 USD in 14 dias
(116 Comentários)
6.1
AliQ

See private message.

$765 USD in 14 dias
(52 Comentários)
6.0
urmate

See private message.

$680 USD in 14 dias
(92 Comentários)
5.9
softncode

See private message.

$765 USD in 14 dias
(64 Comentários)
6.0
zeesoft

See private message.

$743.75 USD in 14 dias
(197 Comentários)
6.0
coderTariq

See private message.

$764.15 USD in 14 dias
(34 Comentários)
5.7
tusharjohri

See private message.

$634.95 USD in 14 dias
(82 Comentários)
5.6
mdsoftsl

See private message.

$510 USD in 14 dias
(10 Comentários)
5.0
peteoconnor

See private message.

$680 USD in 14 dias
(14 Comentários)
5.0
geniussoftwvw

See private message.

$425 USD in 14 dias
(20 Comentários)
4.8