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