Skip to Content
0
Former Member
Jun 10, 2009 at 09:31 AM

Combined Quantity

50 Views

Hello all,

We have a HQ that stores liquid in 3 tanks - in order to keep track of quantity in each tank, they have been set up as 3 warehouses in the HQ location.

It would be impractical to have our sales staff look up the quantity situation per tank with each order and then attaching an order to a particular tank ad hoc, so all orders are tied to Tank 1.

We wind up with an inventory data tab for the item that looks like (trimmed for simplicity):

WH--


Stock-- -Ordered --


Available

Tank1--


50
100
--


(-50)

Tank2--


50
0
--


50

Tank3--


50
0
--


50

Does anybody have any ideas for how to keep track of each tank but still get a more realistic picture of the combined stock/ordered/committed/available etc for the item available at HQ without having to resort to manual arithmitic?

Thanking you in advance.

Edited by: L Soyer on Jun 10, 2009 11:36 AM