Dibatalkan

Stock Control Database

I am looking for someone to build me a cheap and simple database (not access or excel as these are too slow for the amount of stock) for the following purpose.

We are a warehouse company that stores and distributes for many different customers. I need a system that will allow me to

1. Enter a stock item and assign it to a customer and storage bay (location in my warehouse numbered 1-500). It will need to show how many pieces make up that item (eg a bed has 3 parts), when it came in to stock, which customer it belongs to, who entered the stock item.

2. When we receive notification from our customer that an item needs delivering - we need to be able to allocate the item to a final consumer (name, postcode and automated reference), give a delivery date (or if a date is not available - still allocate but date to be confirmed - this will remove the item from freestock), details of how we were told about the work order (ie fax from Linda etc).

3. When we deliver the item we will have to post it putting in date delivered, what proof of delivery we had, comments field, job value (nett and vat).

4. I need to be able to send my customers an excel report of what items they hold in stock (free stock and allocated) grouped together (ie Verona Bed 10 stock 6 allocated 4 freestock).

5. I will need to be able to edit items after they are input (in case any details change), change locations of items, remove items from stock (with reason codes and comments), search for items by either product code, description or customer and job reference as in point 2)

6. I will need to report on - whats held in each storage area (ie bay 20 holds 33 items so I will need the system to tell me whats in so I can check), whats been delivered between certain dates, whats been delivered by customer, amount I have earned by customer (and date), whats freestock (not allocated to a consumer),, whats in stock (freestock and items allocated - i will need to stocktake them so even if they are allocated to a customer they are still in my warehouse so have to be accounted for), whats been booked in by a certain day, detailed delivery report (what item was, code, date entered, date advised of work order, date actually delivered, proof of delivery method).

7. Must be easy to use and create a user id when a member of staff logs into system - this will allow me to track who is making changes to items etc.

I dont want an access or excel spreadsheet as this wont do the job. This needs to be a stand alone system. I bet you have one you can just adjust which is all ready to go - if so let me know what it does.

It must be really easy to use and look like a windows system with buttons to press - I dont want it to look like a scarey sheet which takes hours to find what you need.

I need this very quickly.

I am sure thats all - but please allow for some changes in spec.

Thanks

Once we have agreed the system i will deposit money in escrow and pay as soon as i get it.

Kemahiran: Pemasukan Data, Excel, Sistem Admin

Lihat lebih lanjut: stock control system excel, stock control flow chart, excel stock warehouse, warehouse stock control report, stock control database, stock control excel, who can hold money in escrow, what is escrow and how does it work, what is database entry, what does escrow stand for, what does escrow pay, warehouse data entry job description, warehouse data entry, track description, stocktake database, staff me up, reason for job change, parts database access, order entry job description, one cheap code, looking for data entry staff, logs for company, location of escrow, job stock, how to find data entry free job

Tentang Majikan:
( 11 ulasan ) Middlesbrough, United Kingdom

ID Projek: #293437

15 pekerja bebas membida secara purata $197 untuk pekerjaan ini

spawar

Hi, As you mentioned in the bid Job type (Data Entry, Excel, Admin), its not related to that, it goes in to the programming category. I've read your complete bid, you required the windows application, I'm ready to d Lagi

$250 USD dalam 15 hari
(47 Ulasan)
5.9
trupti

Please check PMB

$250 USD dalam 15 hari
(6 Ulasan)
3.8
omsoftware

Hello , Understand your project and will ready to provide you Web based Solutions to maintain your Stock and warehouse Thanks

$250 USD dalam 15 hari
(4 Ulasan)
3.8
megsoft

Please see your PMB

$250 USD dalam 10 hari
(2 Ulasan)
1.9
spencetech

I could program something like this for you using PHP/MySQL so your system is accessible online, via the internet. Approximately 1-week (7-days) to complete. I would be available Skype, Phone or Email during project Lagi

$250 USD dalam 7 hari
(1 Ulasan)
1.3
ultimatesystem

Your work will be done for sure, check PM for details.

$200 USD dalam 10 hari
(2 Ulasan)
1.0
raskhitinfotech

please see pmb.

$250 USD dalam 20 hari
(0 Ulasan)
0.0
OlegBPavlov

Please see the pm. Regards...

$250 USD dalam 15 hari
(0 Ulasan)
2.2
emerald8hfb

I bid this...work as data entry. Thanks, Howie

$30 USD dalam 3 hari
(0 Ulasan)
0.0
phpoutsource

can be done!

$200 USD dalam 5 hari
(0 Ulasan)
0.0
wfwtechnologies

Hello, We already got what you need. We are a company who builds POS system for a living. Please find time to talk to us. wFw Technologies

$250 USD dalam 10 hari
(1 Ulasan)
0.0
himadri208

We can do this job. Please award us the project asap.

$35 USD dalam 2 hari
(0 Ulasan)
0.0
rezowankarim

Can be do the project another program.

$150 USD dalam 7 hari
(0 Ulasan)
0.0
Elwos

Please SEE YOUR PM

$150 USD dalam 60 hari
(0 Ulasan)
0.0
dktouch

I very well suffice your requirements and is interested in taking up this project and assure you the completion of the assignment to your uttermost satisfaction, provided your guidence in the beginning will be highly a Lagi

$190 USD dalam 25 hari
(0 Ulasan)
0.0