Solved

Office Supplies Inventory/Stock control

Posted on 2011-09-08
14
1,454 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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

803 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