Mysql Item Report On 4 Tables 2
June 22nd, 2011
Four Tables. Will require addition and subtracting. See attached 4 tables.
Main table = Item_List.
Table = Item Adjustment
Table = Item Received
Table = Item Sold
12 Columns
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 Item_List.ItemID’s
Structure Example:
ItemId | ItemNum | Adj_Loc | Adj_Q | Rec_Loc | Rec_Q | Sold_Loc | Sold_Q | Current | Cost | SalesPrice | Notes
