Inventory Tracking

[CSM123]

Hi All! I am trying to create a database in which our small business can keep track of our inventory at all times. One of the things that we do is create gift baskets, therefore we have large quantities of supplies with up to 5 different people taking from them.

Is there a good way to have the inventory and have a way that everyone can check out the items that they take and be able to keep track of this while always having a running total of how much stuff is actually in stock so we know when to reorder?

Also. Is there any way to have the "Gift Basket" as an item but when someone 'checks out' a gift basket it also takes one away from each item in the basket?

Thanks!

Edited July 25, 2009 by Guest
A little bit of color for emphsising a point is cool, but the whole questions is hard to read.

[Tim W]

Hi CSM123 (Your Name could go here);

Inventory control is not possible when everyone's hand is in the cookie jar. Without a policeman, there will be no integrity to the relieving of items from inventory. Is there a policeman guarding your inventory? If so, make that person responsible for relieving the items on hand, we use a material requisition turned in to the inventory person.

As far as the filemaker file is concerned, a requisition table could track the items moved from available stock. A finished goods inventory could be used to collect the gift baskets made but not yet shipped.

So I can see at least 3 tables: raw materials inventory, material requisitions, finished goods inventory.

I hope this helps,

Tim

[jstaphse]

I would have to agree with the policeman concept. I would suggest a table InvTrn that manages the levels of inventory items. When a transaction is created for an item, depending on the transaction type, the levels are modified and the item has a history of who, when, how many, etc. Some transaction types would be restock, pull and reconcile.

Edited July 25, 2009 by Guest