In trying to develop an inventory movement system I have items coming in, being transfered to different locations and being sold at almost the same time. How can if keep up with what I have on hand and where it is? I have a single table with item, qty, and location.