multiple warehouses

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

 

[KARL DEWEY]

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.

 

[Amin]

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,

 

[KARL DEWEY]

The totals query would include the warehouse field to show where the items
and quanities can be found but omitted to show current balance.

 

[Amin]

Thanks I'll try it

The totals query would include the warehouse field to show where the items
and quanities can be found but omitted to show current balance.