Inventory-product stock by warehouses

[DR_LOG]

Hello,
Is there anybody able to suggest me how to solve Product inventory by warehouses.
We have more warehouses, and actually we choose every now and then new. I have tables with Products (where I would like to get stock by warehouse) with column for actual stock that goes like this: COUNT([Related Purchases]) - COUNT([Related Order Details]) + [Initial Stock].
How should I make to get stock by warehouse in each separate column…How to filter it?
Thank you for help in advance!

[1minManager]

I'm guessing this complicated because you want the solution to work for an unlimited number of warehouses?  Where I'd start would be to create a table called warehouse and then create a  column to pull in all the purchases, orders and initial stock for that warehouse.

Simon@1minManager.com