Item Price Comparison

The Item Price Comparison report shows a price comparison of inventory items. Only inventory items with an associated preferred vendor 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
• Vendor Name. The vendor's name
• Contact. A contact person for the vendor
• Phone. A telephone number for the vendor
• 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.

What do you want to do?

Modify the Item Price Comparison report

Create inventory and vendor associations

Create a Vendor Item List report