Vendor incorrect on Inventory report

When running the inventory report, inventory items show up under an old vendor even though the merchandise record reflects the new vendor. This may also prevent certain records from merging properly. 
The Inventory Report lists all merchandise items that are currently in stock. Thus, this report lists the vendor that is listed as vendor for the inventory shipment. To check the vendor for the last shipment:
  1. Click Merchandise > Merchandise Search 
  2. Search for your inventory item
  3. Select the dropdown arrow underneath the product SKU
  4. Click Change Inventory
  5. Mark the box to Adjust quantity, enter a negative value to reduce the inventory count to zero, add a custom Reason, and save this change
  6. Select Change inventory again, mark the box to Add inventory shipment, choose the correct cost, vendor and quantity and save 
User-added image

The vendor detail field that is edited under the Tasks menu for the merchandise, is used for a recent vendor that your organization used but isn't the main vendor and may not be the vendor you use again in the future. This can also come into play if your organization uses multiple vendors for a particular item, the individual vendors would be listed under each inventory item.  
User-added image

Thus, if there is a vendor listed under the Change Inventory section then that is what is used for the Inventory report. If this field is blank, then the vendor specified in the vendor detail field is used instead. 

Steps to Duplicate

  1. Go to Merchandise > Merchandise Search
  2. Select merchandise
  3. Select Edit merchandise under Tasks
  4. Change vendor from old vendor to new vendor
  5. Click Save
  6. Go to Merchandise > Inventory (report)
  7. Run report grouped by Vendor

Actual Results: Item appears under old vendor
Expected Results: Item should appear under new vendor


 Altru Arts & Cultural

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.