Planning and analytics

Purchasing includes tools to plan what to buy and to analyse how you’re buying, from material requirements planning to average-price trends and vendor comparisons.

MRP, material requirements planning

MRP consolidates your open demand into a single view of what needs purchasing, with vendor suggestions so a planner can act quickly.

• It aggregates demand: open material requests, open sales orders, reorder thresholds per warehouse, and open production orders (when Production is enabled), against current stock and on-order quantities.
• Shortages are flagged with a suggested order quantity (lot size + safety stock + lead time) and a suggested vendor (from vendor price and history).
• A shortage row expands to a per-warehouse supply breakdown (on-hand + on-order).
• Results are scoped to your active business unit, and each run is reconciled live from current demand and stock, there’s no stale snapshot.
• Act on a suggestion to start a PO (or raise a draft purchase request) directly.

📷 Image placeholder

Add a screenshot here: the MRP view listing shortages with suggested order quantity and vendor, one row expanded to its per-warehouse on-hand + on-order breakdown.

Average purchase price

See, per product, the total purchased quantity and the average purchase price, with inventory valuation derived from average cost. Figures are scoped to your organisation and business unit.

For deeper analysis, the average-price analysis shows a weighted-average price per item across periods you choose (month / quarter / financial year) with a trend chart so you can spot price drift and negotiate better. A point on the trend drills into the goods receipts that made it up. Items with no receipts in the period are excluded, and figures are in your base currency (using the exchange rate at receipt date).

Item valuation drill-down

Behind the valuation summary, an item drill-down reconciles each item against the inventory record:

• Receipts: GR reference, vendor, date, quantity, unit cost (including any landed-cost component) and total.
• Consumption: date, movement type, warehouse, quantity, unit cost, and a running balance per row.
• Current valuation per warehouse, which reconciles against the inventory ledger.

Filter by date range and warehouse, and drill through to the source documents. Figures are in your base currency.

Vendor purchase summary

The vendor summary compares your vendors by total purchase quantity and value, with a comparison chart across vendors. It respects your business-unit and date-range filters, helping you analyse vendor performance.