Materials & Procurement
End-to-end material flow — from supplier and PO through warehouse, issue to work order and consumption logging. Stock movements are append-only, so any past state can be reconstructed exactly.
Functional areas this module covers.
Inventory catalogue
Materials with type, UOM, manufacturer, reorder levels and substitutes.
Suppliers & POs
Supplier registry, contracts and purchase orders with line items.
Stock movement log
Every receipt, issue, transfer and adjustment captured.
Consumption & cost
Material issued to work orders, costed at issue or weighted average.
1 core table documented in detail.
Unlocked by the depth of this module's schema.
Demand forecasting
Forecast monthly consumption per SKU using task plans and seasonality.
Stock-out prediction
Flag materials that will fall below reorder level before next PO arrives.
Supplier scoring
Score suppliers on lead time, fill rate and price variance.
Sample queries an AI agent can resolve against this module.
“List materials below reorder level by warehouse.”
“Forecast next month's HVAC filter demand for the East region.”
“Show top suppliers by on-time delivery this quarter.”
Pre-built summary views and the metrics teams track.
Summary views
- Monthlymonthly_material_consumption_summaryConsumption by trade and building.
- Quarterlyquarterly_supplier_scorecardSupplier performance metrics.
Key KPIs
- Stock turnAnnualised inventory turnover rate.
- Stock-out eventsCount of fulfilment failures per period.
- Supplier OTIFOn-time, in-full delivery rate.
Where this module connects across the platform.