Solved

Office Supplies Inventory/Stock control

Posted on 2011-09-08
14
1,424 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
 

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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

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 500 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

911 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now