Four Tables. Will require addition and subtracting. See attached 4 tables.
Main table = Item_List.
Table = Item Adjustment
Table = Item Received
Table = Item Sold
From TABLE Item_List : ItemId, ItemNum, Cost, SalesPrice, Notes.
From TABLE Item Adjustment: Adj_Loc, Adj_Q.
From TABLE Item Received: Rec_Loc, Rec_Q.
From TABLE Item Sold: Sold_Loc, Sold_Q.
The col Current will = Adj_Q + Rec_Q - Sold_Q = Current_Q
All math based on the total sum for each location in TABLES Adj+Rec-Sold and showing all [url removed, login to view]'s
ItemId | ItemNum | Adj_Loc | Adj_Q | Rec_Loc | Rec_Q | Sold_Loc | Sold_Q | Current | Cost | SalesPrice | Notes