Need Help With HQ Reports

I run a HQ with 6 store in Liquor Store environment.

Most of the products we order at one store and then distribute to other stores.

I am looking for generate a Item report with quantity OH(On Hand) and Quantity Sold for all stores for specific dates. Some time we have vendors put some products on sale and some time of the sale.

So we want to take advantage of sale price and plan our Purchase order for specific vendor. I want to see the items from particular vendor with QTY sold and QTY OH.

So if some product are qoing of the sale for specific period from vendor so I can stock it for that period depending on the report how many Sold and how many aviable. Lets look at Example

Item # Store Name Descriuption QTY OnHand QTY SOLD Overall 123 170

166 123 Store 1 Vodka 32 19 123 Store 2 Vodka 43 28 123 Store 3 Vodka 28 11 123 Store 4 Vodka 0 56 123 Store 5 Vodka 11 43 123 Store 6 Vodka 56 9

Overall 124 190

169 124 Store 1 Whisky 35 17 124 Store 2 Whisky 39 21 124 Store 3 Whisky 21 32 124 Store 4 Whisky 45 36 124 Store 5 Whisky 19 39 124 Store 6 Whisky 31 24

I tried to customized the detailed sale report with extra colum added for QTY on hand but its give me a HQ quantity for all stroes in stead of seperate QTY for each store. Also if particular store item did not have a sale data for particullar period but still have QTY OH, don't show up on this report

Thanks

snipped-for-privacy@sbcglobal.net