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--
Available
Tank1--
(-50)
Tank2--
50
Tank3--
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