Item qty/movement report

I am looking for a report for HQ that will provide a list of all items in the database grouped by Store that will provide the qty sold between a particular date range and the quantity on hand for that store. This report is similiar to the Detailed Sales report that already exists in HQ but it would need to contain ALL items not just items that sold and would not display transaction level details, only a grand total for each item for each store. We are willing to pay for this report if anyone has seen one or developed one like it. I really appreciate any feedback you can provide,

Thanks.

Casey snipped-for-privacy@4nwt.com