Stock Control System

I am looking for someone to build me simple database 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. I want the facility to enter items in bulk per supplier as stock arrives by container.

2. When we receive notification from our customer (often a retailer whom we work for) 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.

8. I would like to be able to pick items for delivery - ie search for items, click them into a field so that I can create a picking list for the staff. I need to be able to assign a name to the picking lists as I have multi staff and vans.

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 nor do i want it web based.

Bidding Conditions:

1. I ned this complete in one week - 2 weeks max.

2. PLease dont send me your life history or standard bid applications - all i need is a yes, price, time and any questions.

3. If you have a system you can adapt - great - but show me.

4. I dont want this to be like a spreadsheet - I need this to be like a windows based system which you click icons to enter details etc. I dont want a huge access or excel spredsheet which looks difficult - my staff are use to clicking icons - we have thousands of items to enter and we constantly work on data input etc - hence the easier the better.

5. This is the thirt time I have listed this - if you cant do it dont bid, if you are thinking of doing a quick excel system dont bid. I want someone who knows what they are doing.

6. PLease ask as many questions as you like about the company and how we operate - dont ask me anything technical as this is your area of expertise.

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


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

Kemahiran: Pemprosesan Data, Excel, Sistem Admin, Destop Windows

Lihat lagi: stock control system excel, simple stock control system excel, windows free icons, windows 8 price, windows 10 icons, who can hold money in escrow, vans job, track description, this day in history database, the icons codes, system one, stocktake database, staff me up, reason for job change, questions to ask about a company, product supplier database, pay per click job description, parts database access, my supplier find, max delivery, making icons for windows, making icons, logs for company, location of escrow, life company logs

Tentang Majikan:
( 11 ulasan ) Middlesbrough, United Kingdom

ID Projek: #295182

Dianugerahkan kepada:


pls chk pmb

$250 USD dalam 14 hari
(1 Ulasan)

25 pekerja bebas membida secara purata $582 untuk pekerjaan ini


Hello sir, Thanks for providing us a chance to bid. Our experties are very much in line to your requirements. We already developed many systems realted to inventory like Warehouse mangement System, Inventory manager et Lagi

$650 USD dalam 15 hari
(139 Ulasan)

plz check pmb. thanks

$750 USD dalam 20 hari
(8 Ulasan)

Plz Chk PMB

$725 USD dalam 15 hari
(9 Ulasan)

Hi.. I can do this work for you.. Please see PM.. Thanks

$500 USD dalam 7 hari
(31 Ulasan)

I`ll do that.. I can show you How reporting, dataentry, export, printing , Charts etc works in the softeare we develop. Thanks

$700 USD dalam 20 hari
(3 Ulasan)

Please See PMB.

$700 USD dalam 30 hari
(4 Ulasan)

We're offering a high reliable windows database solution using the Clarion IDE and Databases. No 3rd party dlls or ocx-es to register. No additional windows libraries. Just a single executable file. Nice user interface Lagi

$690 USD dalam 14 hari
(1 Ulasan)

Dear sir, please see my pm. Thanks

$250 USD dalam 7 hari
(13 Ulasan)

Please check PMB for design Details

$650 USD dalam 15 hari
(2 Ulasan)

Hi Sir, I can develop a such warehouse database. If you need to veryfy how can do for this, I will start to develop your database and can send sample of your future database to you within 3 days. After assigning me to Lagi

$600 USD dalam 10 hari
(0 Ulasan)

Lets start.

$500 USD dalam 10 hari
(0 Ulasan)

plz check PM

$750 USD dalam 15 hari
(0 Ulasan)

We are a small, dedicated and focussed consultancy based in Melbourne Australia, with experience and expertise in commercial applications. Please visit our website at [url removed, login to view] to view examples of previous Lagi

$750 USD dalam 30 hari
(0 Ulasan)

Hello sir, Thanks for providing us a chance to bid. Our experties are very much in line to your requirements. We already developed many systems realted to inventory like Warehouse mangement System, Inventory manager et Lagi

$500 USD dalam 16 hari
(0 Ulasan)

Ready to start. Please see PM for details, thanks.

$750 USD dalam 15 hari
(0 Ulasan)

I can offer this using windows based vb and MSAccess as the back end database

$350 USD dalam 7 hari
(0 Ulasan)

Can start anytime.

$500 USD dalam 15 hari
(0 Ulasan)

I have more than 6 yrs experience having worked for multinational corporations. I can show you samples of my previous work if you want.

$400 USD dalam 10 hari
(0 Ulasan)

I have 30 persons team. In this team, I have Web Developers, SEO, Data Entry Operators, Programmers and Graphic Designers. Give us a chance. We will do that but our charges is $1500.

$750 USD dalam 14 hari
(0 Ulasan)

Please do check our PM.. Thank You

$747 USD dalam 21 hari
(0 Ulasan)