[AccessD] Inventory Tracking

Virginia:

I have a commercial product E-Z-MRP which does, among other things,
inventory tracking.  As you get further into it, feel free to contact me
off-line with your questions.  

You should also consider adding an audit trail of inventory transactions to
the db.

Is this for manufacturing, distribution, or retail?

 Regards,

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Thursday, March 29, 2007 4:37 AM
To: accessD at databaseadvisors.com
Subject: [AccessD] Inventory Tracking

Does anyone have anything that would help me set up a new database for
tracking inventory? I can't seem to get it in my head how to set it up.
It should be simple, but adding to the inventory & taking out of inventory -
I am having problems with setting up the tables. This is my first inventory
tracking system.

 

There are only 3 storage locations where the inventory is kept & only 5
types of items stored. But adding and removing items, then keeping track of
the minimum inventory and the actual inventory I don't know the best way to
set up the tables.

 

I know I need a location table & a type of inventory table, but how do I
list the same items for each of the 3 locations in a table? If they add to
the inventory at a certain location on a certain date, it should add to the
actual inventory for that item and location.

 

Hope someone can help on this....

 

Virginia

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.20/737 - Release Date: 3/28/2007
4:23 PM