Inventory-Am I on wrong path?
- From: Josh <traygo@xxxxxxxxxxx>
- Date: Wed, 16 Aug 2006 15:53:45 -0600
I'm wondering if I'm setting myself up for problems......am I wrong in my design
of a fairly simple Inventory DB.
This is for receiving only. Some items will be stocked on shelf, but most items
will be delivered directly to various departments.
Most of the samples I see have a "Products" and/or "Inventory" Table, and a
Transactions Table. I only have a Transactions Table. (and P.O. Table).
To get current stock level, I sum the transactions field. (+24 for 24 ItemXYZ
received, -8 for when some was delivered to department).
So, my thinking is why have *any* table that stores an Inventory? But now, as I
said, I'm wondering if I'm missing something obvious....
Also, the P.O. Item(s) when ordered are inserted into the Transactions Table as
a positive, but with Status of "OnOrder". When Recieved, the Status is changed
to "Received". I wonder about the wisdom of doing that, also. Would it be
better to add the P.O. Items at all (to the transactions table) until Received.
If it would be better to do that, then I suppose, to get current stock info
would take sum of Transaction table to get Stock on hand, then add the sum of
P.O. "OnOrder" items (for each item).
Thoughts?
Thanks, Josh
.
- Follow-Ups:
- Re: Inventory-Am I on wrong path?
- From: Allen Browne
- Re: Inventory-Am I on wrong path?
- Prev by Date: Re: student database
- Next by Date: order history database design in access 2003
- Previous by thread: Re: How to change or indciate the type of relation in Relation Dia
- Next by thread: Re: Inventory-Am I on wrong path?
- Index(es):
Relevant Pages
|
Loading
