Selesai

Data warehouse db

Need a data warehouse db.

used by 4-5 users.

1. We need to record incoming/outbound item (3 dock doors).

what the driver gives to the dock will by verified by what was received.

The item number given must match the number keyed in by the dock

(the driver types the items in = 12345678

23456789

his user name TOM BURK from drop down

The dock employee then types the item received

12345678

23456789

his user name Jim Taylor from drop down

a field in case of comments needed (ex. box 123011 was wet)

and then hits the VERIFY button .

The verify checks to see what the driver (delivery) and the dock (received) are the same.

If the same print a report 2 times with the items, delivery name, receiver name and time and date and comments

2. Once received the inside warehouse will add more info to the items scanned in

1234567

2345678

they will add : from what [url removed, login to view], the value and a comment field

The inside warehouse will then forward the items to area 1 or area 2 (need to record this).

Also the inside ware. will create new orders, so the will need to :

type in the item 55556666

Company Richo

Value 200

only then the dock will be able to send out an item (must exist in the system prior).

any move. to the dock doors from area 1 and 2 will be done by the inside ware. fowarding the items to the dock.

We need to be able to print reports:

what was received by dock door 1, 2,3 and by all doors (also by date)

report of items sent to area 1 or 2 for inside ware.

a report from inside ware. on newly created items

and be able to track an item by its number.

In essence an items db tracking movement and creating reports.

This can be done in Access or ?

Skills: MySQL, PHP, Perancangan Perangkat Lunak, Pengujian Perangkat Lunak, Hosting Web, Manajemen Situs Web, Pengujian Situs Web, Destop Windows

See more: track 1 data, inside track, warehouse, warehouse system, jim, Data ware, access creating reports, create doors windows, access track orders, doors company, record checks, employee data php, data tracking, employee record system, delivery driver, scanned orders, access orders track, dock, employee time tracking, door access, print reports php, access item tracking, print driver create, item tracking access, windows doors

About the Employer:
( 2 reviews ) Athens, Greece

Project ID: #2703469

Awarded to:

customizedata

See private message.

$255 USD in 18 days
(104 Reviews)
5.8

10 freelancers are bidding on average $202 for this job

amcsummers

See private message.

$265.2 USD in 18 days
(61 Reviews)
5.5
lourdasv

See private message.

$246.5 USD in 18 days
(47 Reviews)
5.4
russel02cuet

See private message.

$175.1 USD in 18 days
(54 Reviews)
4.5
bdtechies

See private message.

$150.45 USD in 18 days
(42 Reviews)
4.3
bickos

See private message.

$170 USD in 18 days
(15 Reviews)
3.4
nithyarajeshg

See private message.

$85 USD in 18 days
(30 Reviews)
3.3
pramodv

See private message.

$250.75 USD in 18 days
(14 Reviews)
3.2
Aliraza170

See private message.

$190.4 USD in 18 days
(3 Reviews)
1.0
sonugeevw

See private message.

$227.59 USD in 18 days
(0 Reviews)
0.0