Inventory control report.

I need a side by side report that would look a lot like the "Stock Check Sheets" but would show the stock level of multiple locations.  Here is a sample report (script500.com/uploads/sidebyside/sample-sidebyside-report.pdf).

I will use repgen to manage reports.  What I need is the SQL Statement.

   1. It will show stock level for multiple locations, (once the statement is written, it would not be difficult to change or add to the statement to change or add locations)
   2. It would show one, or all categories.
   3. It would not show inactive items.
   4. We may want to add an Item (reorder level) column to this report later.

Objective:  When you are in the retail trade with multiple locations, you may have some items that sell better in one location then others.  You have one location that may operate as a distribution center.  Most of your orders or cargo would come to this location and be transferred from there... When you need to restock some items at a location, you do a stock check to verify the accuracy of the system.  Then you need to check the level of stock at other locations for these items you need to order.  You may want to do a location to location transfer of these items before you generate a PO for your supplier.

If anyone has other ideas or is in need to inventory control... Please let me know.