Available in Sage 50 Quantum Accounting and higher.
Vendor Item List
The Vendor Item List report shows a list of inventory items that a vendor(s) sells. Only associated vendors and items appear in this report. To create an association between a vendor and item, use the Inventory & Vendors window.
This report tells you:
- Item No.. A code number for the inventory item
- Description. A description of the inventory item
- Vendor Item No.. The vendor's code number for the inventory item if different from Item No.
- Vendor Item Description. The vendor's description of the inventory item
- Unit. The unit you stock, sell, or buy the item by
- Price. The current price for the inventory item
- Effective Date. The effective date for the purchase price
- Last Purchase Date. The last date of purchase from the vendor
- Last Price. The last price for the vendor associated with the inventory item
- Last Quantity. The last purchase quantity for the vendor associated with the inventory item
- Last Amount. The amount purchased based on the Last Price multiplied by the Last Quantity.
You can drill down to the Inventory & Services Record Window report for any inventory or service item in the report viewer. You can also drill down to the Vendor Records Window.
To view this report, open the Reports menu in the Home window, select Vendors & Purchases, and then Vendor Item List. Click Display.