There’s an easy way to produce a list of customers who have purchased specific inventory items during a given date range. The Item Costing Report lists items with costing information for quantities received and sold.
Select Reports & Forms; Inventory; Item Costing Report. Click the Options OK to preview the report. button to set a date range and to filter by specific inventory items. Click
To include the invoice numbers of purchases and sales, click the Columns button and set Reference to Show.
If you want a simpler listing that includes only items included on customer invoices, you may want to take a look at the Find Transactions Report. Select the Company report group to locate this report. Click the Options button and select Transaction Type as a filter. Set this filter to Sale/Invoice. You can also filter by a range or specific Item IDs.
Thanks to the folks at Sage for this great tip!
The ROI-Centric Conference of the Year is coming this Fall!
November 9-12 in Atlanta
