AnsweredAssumed Answered

inventory report

Question asked by AvtandilKiladze on May 15, 2015
Latest reply on May 24, 2015 by philmodjunk


inventory report



i'm making inventory DB, to track product transaction and see balance in multiple warehouses.

i have 3 table:

TB1 (warehouses): wharehouse_id .... with: wh1, wh2, wh3 etc...

TB2: (Products) Product_id .... with: A, B, C, D etc...

TB3: (Transactions): Transaction_id. warehouse_id_sender, warehouse_id_reciever. Product_id, quantity

what i want to do is:

make report to see for example: 

wh1 productA Sum_quantity

wh1 productB Sum_quantity

wh2 productA Sum_quantity

wh2 productB Sum_quantity