multiple warehouses

  • Thread starter Thread starter Amin
  • Start date Start date
A

Amin

Hi everybody,

I'm designing a simple inventory managment database, that would be easy if I
only have one warehouse but I have multiple warehouse.

How can I handle inventory transfers between several warehouses? I prefer if
i dont use code.

Thanks in advance.
 
Why not an Item table and transaction table.
Item --
ItemID - autonumber - primary key
Name
Size
Color
etc

Transact -
TransactID - autonumber - primary key
ItemID - number - long integer - foreign key
TransDate - DateTime
WareHouse
QTY
Type - Gain (Purchase), Loss (Consume), InvAdj (to make data match physical
inventory), Damage, etc.
Rmks

When item moved from one warehouse to the other there will be two
transactions.
 
Hi Karl,

Thanks for taking time responding to my post, your method is what I use for
one location warehouse I can't see how does that apply to multiple locatios
... maybe u have a different approach for a query?

Thanks again,
 
The totals query would include the warehouse field to show where the items
and quanities can be found but omitted to show current balance.
 
Thanks I'll try it

KARL DEWEY said:
The totals query would include the warehouse field to show where the items
and quanities can be found but omitted to show current balance.
Click to expand...
 
Back
Top