I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I can't seem to find the right table in VI, I am using IM_ItemWhseHistoryByPeriod, pulling "PrimaryVendorNo" and UseinSO, is there no field for "transaction quantity"? (I am not sure how to combine SO/Invoice with the Qty Issued) 

Furthermore, to get a custom range of dates, I pulled in "SaleStartingDate" and "SaleEndingDate" and set an "equal to" date for both. This didn't work. 

Does anyone have any ideas, this is harder than I thought it would be!