Vendor Price List Setup
The Vendor Price Matrix form (menu path: Purchasing > Vendors > Vendor Price Matrix) defines the pricing relationship between vendors and items. Each record in the SLVendorPriceMatrix table stores the unit price, unit of measure, currency, and quantity range for a specific vendor-item combination. Configure effective and expiration dates to manage contract pricing periods.
- Create vendor price records on the Vendor Price Matrix form linking vendor, item, unit of measure, and negotiated unit price
- Set effective and expiration dates on each price record to manage contract pricing windows and automatic price transitions
- Configure quantity break pricing with multiple rows per vendor-item combination using ascending break quantities in the SLVendorPriceMatrix.BreakQty field
- Enable currency-specific pricing for international vendors with exchange rate integration from the SLCurrencyRates table
- Set up the primary vendor flag on the Items form Purchasing tab to define default price resolution order during PO creation
Discount and Adder Configuration
Beyond base pricing, SyteLine supports vendor discount structures and price adders that modify the base unit price. Configure discount percentages, freight adders, and tooling charges on the Vendor Price Matrix form to capture the true landed cost of purchased materials for accurate cost rollup calculations.
- Configure line-level discount percentages on the SLVendorPriceMatrix.DiscountPercent field for volume or contract discounts
- Set up freight adders as a per-unit or per-order charge to include transportation costs in the vendor price calculation
- Define tooling and setup charges as one-time price adders that amortize across the order quantity for total cost accuracy
- Enable automatic discount calculation based on order value thresholds using the vendor discount schedule
Price Matrix Maintenance and Analytics
Vendor pricing requires periodic maintenance to reflect market changes, contract renewals, and negotiated improvements. SyteLine's Vendor Price Comparison Report and price change history tracking in the SLVendorPriceMatrixHistory table enable data-driven procurement decisions and cost trend analysis.
- Use the Vendor Price Comparison Report to compare pricing across vendors for the same item to identify cost-saving opportunities
- Configure price change tracking to log historical pricing in SLVendorPriceMatrixHistory for year-over-year cost trend analysis
- Set up price variance alerts when PO unit prices deviate from the current vendor price matrix beyond a configurable tolerance
- Enable mass price update functionality for contract renewals using the Vendor Price Matrix Import utility
- Generate spend analysis reports by vendor and commodity code using the price matrix data for strategic sourcing negotiations
Try it here, free
SyteLine AI Integration Readiness Assessment
Score your SyteLine environment across version, IDO and ION API maturity, data quality, integration middleware, and organizational readiness for an AI layer.
Get your SyteLine vendor pricing right with expert price matrix configuration—request a procurement optimization review.