The Inventory by Vendor report tracks the last order date, item, on-hand quantity, and cost for a specific vendor. The report can be filtered by location and one or all vendor(s).
To view the report, navigate to Reports > Inventory Management > Inventory By Vendor.
- The Cost column is derived from the Cost price set up in Product Maintenance.
If you use the Average Cost method to calculate inventory, then the average cost displays (Admin > Product Maintenance > Search and select the product name > click the Location Default tab > Unit Cost field reflects the average cost price)
- The Retail column is derived from the Retail prices set up in Product Maintenance.
- Preferred vendor column (Pref) indicates whether the vendor is setup as the preferred vendor for the selected item. Yes indicates the vendor is preferred, No indicates they are not.
Note: Each product can have a preferred vendor. When a preferred vendor is set, the system will prompt users when attempting to create purchase orders for this item using a different vendor. For example, a vendor may be preferred if their price is lower than other vendors.