[AccessD] Inventory Tracking

Then John's approach would seem to be a good basis.  

Part Master table with all the info about a part - Autonumber ID,number,
description, unit cost, vendor, etc.  Location table  with FK to the Part
Master, and quantity.  

Third table for audit trail - date/time, user, location, old balance,
transaction quantity, new balance, audit reference (to note why the
transaction took place), standard cost, actual cost if they want to do
purchase price variance.

HTH

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 8:36 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Inventory Tracking

It is for distribution. How much they have, how much they use in a certain
location & if it goes below the minimum amount. They don't need anything
fancy; just to know how much is in each storage location.
 
 
 
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

 

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