Merchandise Inventory Batch Control Report does not display values for fields

When running a Merchandise Inventory Batch Control Report, you may notice that there are columns on the report for Unit Cost, Retail Price, and Vendor. You will notice that nothing displays for Unit Cost, Retail Price or Vendor. 
The control report only shows fields that could be changed in the batch.

You can build a query to find all inventory items that have been updated and pull information such as Unit Cost and Retail Price. 
  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 and Unit Cost 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. 

 

Environment

 3.18

Was this article helpful?