Product Supplier Price Summary
Shows up to three suppliers of each product side by side (A, B and C) with each one's purchase price, next to the retail price and stock.
Menu: Reports › Product Reports › Product Supplier Price Summary
What it's for
Use it to compare suppliers before ordering, and to find products where another supplier is cheaper than the one you usually use. The suppliers and prices come from the product's Supplier tab. When you filter by one supplier, only that supplier is shown.
Canned Tuna 155 g shows A Supplier Metro Foods at 28.50, B Supplier Sunrise Trading at 27.25 and C Supplier Island Distributors at 29.00. The buyer places the next order with Sunrise Trading.
Filters
Click Filters to narrow the report. You can filter by:
Branch (Inventory), Product Barcode, Product Name, Default Supplier, Supplier, Category Tag.
Columns
| Column | What it shows |
|---|---|
| Product Name | The product name. |
| Memo | The product memo. |
| Parent Category | The category one level above the product's category. |
| A Supplier | The product's first supplier. |
| A Cost | The first supplier's purchase price. |
| B Supplier | The second supplier. |
| B Cost | The second supplier's purchase price. |
| C Supplier | The third supplier. |
| C Cost | The third supplier's purchase price. |
| Retail | The product's retail price in the branch. |
| Inventory | Current stock, in the product's default unit. |
Also shows: Barcode, Chinese Name, Category.
For searching, express filters, sorting, column settings, exporting and printing, see About reports.