- Analysis > Information Library > Add an ad-hoc query
- Change the query record type to Merchandise Item and 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 on the left-hand side 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 Results fields to display section to get the previous quantity of the merchandise item before the action
Connect and collaborate with fellow Blackbaud users.