Supplier Product Price
Shows, for each supplier and product, the latest purchase price (with its unit), the lowest and highest prices paid, and the minimum order quantity.
Menu: Reports › Partner Reports › Supplier Product Price
Required permission
Reports › Supplier Product Price › View
What it's for
Use it to check purchase prices before ordering or when a supplier announces a price increase, and to negotiate with evidence.
Example
Metro Foods announces a new price of 30.00 for Canned Tuna 155 g. The report shows Latest Price 28.50 and Highest Price 29.00 in the past year, so the buyer negotiates the increase down.
Filters
Click Filters to narrow the report. You can filter by:
Default Supplier, Supplier.
Columns
| Column | What it shows |
|---|---|
| Supplier | The product's default supplier. |
| Product | The product name. |
| Latest Unit | The unit of the latest purchase. |
| Latest Unit Qty | How many default units that unit holds. |
| Latest Price | The latest purchase price. |
| Latest Fields' Updated Date | When the latest price was recorded. |
| Lowest Price | The lowest price paid to this supplier. |
| Highest Price | The highest price paid to this supplier. |
| Minimum Qty | The supplier's minimum order quantity. |
| Remarks | The transaction's remarks. |
Also shows: Chinese Name, Description, Brand.
For searching, express filters, sorting, column settings, exporting and printing, see About reports.