We have recently merged three branch data bases into one data base, which is wonderful for looking up quantites on hand on any item. However, I need to create a report for ordering that will give me the following:

Item
Item Number
Quantity on Hand by Location
Units Sold Last Year by Location
Units Sold Year to Date by Location
Quantity on PO by Location
Quantity on SO by Location

All of these fields are quite important when I look at re-ordering. What is the best way to obtain these fields in a cohesive report?

Thank you.