Gina,
Let's just say I'm doing something like this in Access:
http://indzara.blogspot.com/2013/07/InventorySalesManager.html
A sort of point-of-sale system, but applied in a different way. I've already been able to do something like this in Excel, but for confidentiality reasons, I've just showed a link of where I got my format from.
1. I want to be able to keep track of inventory levels especially when they are low.
2. I want to know who or which department gets to use most supplies.
3. I want to update, live, the level of inventory everytime a staff requests for a certain item
4. Every department has a different fund source because our company has more than one income generating programs
This is how the process goes in the office:
1. I, the property custodian, keep all inventory
2. The procurement department for example purchases office supplies under their own fund source
3. I receive them, record them on my database (inventory level/quantity), and add new items if the item is not listed yet
4. A staff requests for an item from me. I let the staff sign an Acknowledgement Form (AF) before releasing the item. The AF looks exactly like this:
Ref. No. | Date | Requesting Staff | Department | Fund Source | Item Code | Qty | Unit | Signature of Requester | Released By | Remarks
5. I release the items. Every time a staff requests for an item, his/her department sort of "borrows" items from the Procurement Department's fund source. Later on, Procurement will "replenish" the items and will be charged to the requester's fund source.
6. After 3 weeks, I will prepare a consolidated list of all items released under different departments and fund sources.
7. I will forward the list to Procurement and they are in charge of purchasing all the items.
8. I receive all items, and the cycle continues.
This is my progress so far:
View attachment X.accdb
I have included an Employee table because I would need those information when I issue employees with items that need accountability for example: laptop, cellular phone, etc. But that's a different problem. I just want you to know that I'm gonna need that table later on, so it's not unnecessary.
For confidentiality purposes, I've also made fictional employees and items. But the thought is totally the same.
PROBLEMS:
1. What should I do next?
2. What kind of object should I use to keep track of inventory? Like when I receive and release items.
:banghead: