?
Solved

Office Supplies Inventory/Stock control

Posted on 2011-09-08
14
Medium Priority
?
1,930 Views
Last Modified: 2012-05-12
Hi,
I have been tasked to develop a stock control/inventory system for our office  stores.This stores keeps office supplies like toner,bond paper,cleaning materials,pencils,beverages etc all for office use.Management wants to be able to monitor usage and generally to help stores officer plan well.
I searched the database and found a similar question asked but the answer/solution does not meet my expectation hence decided to ask again.A web based system would be very good.
The link for the question is:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22119451.html?sfQueryTermInfo=1+10+30+inventori+offic+softwar+suppli

Its almost exact,i will be glad if anyone is able to help.
Any open source software  is highly preferred since freedom is GOOD for everyone.

Nb:If i have misplaced zones for this question please help by re-directing it
Thanks you.
0
Comment
Question by:protechzm
  • 9
  • 5
14 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36503662
<Its almost exact>
What is "almost exact"?

There were two posts accepted in your link, which one are you referring to?


If it were me, and I was new to database design, I would start with the MS Access template:
http://office.microsoft.com/en-ca/templates/inventory-control-database-TC001047741.aspx

Just be aware that inventory management Database can end up being some of the most complex databases to develop.
(They will be commonly be called on to interface with Sales and HR systems)
So I would not recommend you doing this alone if you are new to database design.

JeffCoachman
0
 

Author Comment

by:protechzm
ID: 36508412
The link i am talking about is the accepted solution,there is also an assisted solution,generally,there are no sales issues on our part.All we want is to monitor the flow of items issued to staff from the storeroom by the stores officer and to also know how to control usage and to help the stores officer plan the re-order levels of the items.I do not really need something very complicated.

Thanks
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36510530
OK, then that is what the sample I posted is...
a very basic system.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:protechzm
ID: 36517414
I have looked at the one you,suggested,looks ok on the part of the inventory but there is no part where products are issued,is there a way to edit this to include the issuing part of the items to members of staff?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36517575
The database manages the inventory.
In that respect the database is functionally complete.
(example: An employee is assigned to a Purchase order)

So you will have to clearly define what you mean by "Issue".
0
 

Author Comment

by:protechzm
ID: 36518856
Okey,what i mean in simple terms is this:every employee fills in a request form where they say what they want from stores,the stores officer then records qty issued.we have 2 departments,each with their requisition book.we want to be able to track the issuing of items from stores and if possible know who uses alot of bond paper for example or who uses alot of toner.i hope i have given u the clear picture!
0
 

Author Comment

by:protechzm
ID: 36518857
Okey,what i mean in simple terms is this:every employee fills in a request form where they say what they want from stores,the stores officer then records qty issued.we have 2 departments,each with their requisition book.we want to be able to track the issuing of items from stores and if possible know who uses alot of bond paper for example or who uses alot of toner.i hope i have given u the clear picture!
0
 

Author Comment

by:protechzm
ID: 36518858
Okey,what i mean in simple terms is this:every employee fills in a request form where they say what they want from stores,the stores officer then records qty issued.we have 2 departments,each with their requisition book.we want to be able to track the issuing of items from stores and if possible know who uses alot of bond paper for example or who uses alot of toner.i hope i have given u the clear picture!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36526696
Then you will need something like this as a start

tblEmpOrders
EmpOrderID
EmpID
OrderDateTime

tblEmpOrderDetails
EmpOrderDetailID
EmpOrderID
ProductID
Quant
0
 

Author Comment

by:protechzm
ID: 36541835
Thank you for the support,these fields make up two tables that will need forms not so?how about the dept usage as a whole,please shade abit more on the ideas,looks like i wud use alot of your help,i can compensate you if have time to help,
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 36545226
Well the addition of needing "Department" level info, moves this well beyond the original question.

So now you obviously need an "Employee" table and a related "Department" Table.
tblDepartments
DeptID (PK)
DeptName
...etc

tblEmployees
EmpID (PK)
DeptID (FK)
EmpFN
EmpLN
EmpAddress
...etc

<i can compensate you if have time to help,>
As Experts, the only compensation we can accept is the points you assign to a question.

If you need help with an issue "outside" of this site, you can browse all of the profiles of the top experts here.
Most will have a "Hire Me" button.

JeffCoachman
0
 

Author Closing Comment

by:protechzm
ID: 36555681
I have accepted this solution because it points to what i need,many thanks for your help
0
 

Author Closing Comment

by:protechzm
ID: 36555682
I have accepted this solution because it points to what i need,many thanks for your help
0
 

Author Closing Comment

by:protechzm
ID: 36555683
I have accepted this solution because it points to what i need,many thanks for your help
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Why WooCommerce is one of the majorly favored choices when it comes to having an eCommerce store. This article will acquaint you with some reasons that I believe make it one of the best eCommerce platforms available.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question