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
 

Environment

 Altru Arts & Cultural

Was this article helpful?