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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.