Skip to Content
Jul 27, 2020 at 05:41 PM

Query Help for Vendor items purchased and sold


Is there a report that can be run that would pull the following data by Vendor:

All items purchased over a given time period (ie past 12 months) and the amount of those same items sold.

Select VENDOR and Date range

Item No

Item Description

Quantity purchased

Amount purchased $

Quantity Sold

Amount Sold