- Analysis > information library > add an ad hoc query > change the record type to merchandise item > choose the merchandise query source view
- Under browse for fields in click on Inventory Item, drag quantity from the middle column to results fields to display to output the current quantity of the merchandise item
- Expand the inventory item field under browse for fields in and click on the history field
- Drag the action type and/or action date field from the middle column to include records where to filter on certain actions during certain time frames
- Drag the previous quantity field from the middle column to the results fields to display section to get the previous quantity of the merchandise item before the action
Connect and collaborate with fellow Blackbaud users.