How To: Set a Stock Item Price List against a specific Supplier
Table Of Contents
Supplier-specific pricing allows you to maintain purchase prices for individual suppliers, including quantity breaks, discounts and date-based pricing. When configured, these prices are automatically used when creating purchase orders for that supplier.
Important: Supplier prices configured in the Supplier Price List take precedence over supplier buy prices configured against the stock item for the same supplier.
Open the Supplier Price List
- Open the Supplier screen (Show me how).
- Open the Tab" target="_blank" rel="noopener noreferrer">[ Supplier | Supplier Price Lists | Supplier / Stock (1) ] tab.
- Click the green folder button to open the supplier lookup.
- Search for the supplier you want to maintain pricing for and double-click their record to select it.
- Press Alt + E or click Edit to enter edit mode.
Add Stock Items to the Price List
- Click Add Item above the grid.
- Select the stock items that require supplier-specific pricing.
- The selected items will be added to the price list grid.
Configure Quantity Breaks (Banding)
Quantity breaks allow different purchase prices to be applied depending on the quantity ordered.
- Add the stock item once for each pricing band required.
- For each band, enter:
- The minimum quantity in the Start column.
- The maximum quantity in the End column.
- Enter the supplier purchase price in the supplier's currency in the Price column.
Example
| Start Qty | End Qty | Price |
|---|---|---|
| 1 | 99 | £10.00 |
| 100 | 499 | £9.50 |
| 500 | 999999 | £9.00 |
In this example, larger order quantities receive a lower purchase price.
Note: Discounts can also be applied to individual quantity bands if required.
Apply Supplier Discounts
If your supplier offers a percentage discount, you can record it in the price list.
- Enter the discount percentage in the Discount column.
The discount will be applied to the supplier buy price for that price band.
Example
| Price | Discount |
|---|---|
| £10.00 | 10% |
This would reduce the effective purchase price by 10%.
Set Date-Based Pricing
If supplier pricing is only valid for a specific period:
- Enter the relevant start and end dates for the price record.
This is useful for:
- Promotional supplier pricing
- Seasonal pricing agreements
- Temporary supplier cost changes
Save the Price List
- Press Ctrl + S or click Save to save your changes.
The supplier-specific pricing is now available for use on purchase orders.
Important Information
Purchasing Items Free of Charge
If a stock item needs to be added to a Purchase Order with a purchase price of £0.00:
- Add the item to the supplier price list.
- Set the Discount to 100%.
This will result in a purchase cost of zero when the item is added to a Purchase Order.
Price List Priority
Supplier pricing configured in the Supplier Price List overrides:
- Supplier buy prices held against the stock item; and
- Other default supplier pricing for the same supplier.
This ensures the most specific supplier pricing is always used.