We can use the Merchandise Activity Report or build the following query:
  1. Go to Analysis > Information Library 
  2. Click Add to add a new ad-hoc query 
  3. Select the source view of Merchandise
  4. In the left column, expand Inventory Item and highlight History
  5. Drag Action Date to Include Records Where. Set this filter to be equal to or between the dates when you ran your last physical count/inventory update. 
  6. Drag Action Type to Include Records Where. Set this filter to be equal to Physical Count. 
  7. Highlight Inventory Item again in the left column. 
  8. From the middle column, drag details such as Retail Price, Unit Cost, Name, etc to Results Fields to Display
  9. In the left column, highlight Vendor
  10. From the middle column, drag Vendor name to results fields to display