WindoorERP Documentation 19.0

Conduct procurement spend analysis, raw material price variance audits, and purchase BI reporting

1 min read Updated 2026-08-28 WindoorERP 19.0

What this does

Delivers executive business intelligence into total procurement spend, raw material commodity trends, vendor cost variances, and purchase budget compliance across graphical and pivot views.

Before you start

  • Purchase Manager or Finance Director access.

Steps

Executive procurement spend and sourcing trends bar chart

Purchase analytical multi-dimensional pivot table

Important

Comparing average unit purchase prices over time highlights inflation risks and informs strategic raw material hedging.

  1. 01
    Open Purchase › Reporting › Purchase.
  2. 02
    Toggle between Graph and Pivot views.
  3. 03
    Select Measures: evaluate Untaxed Total, Quantity Billed, Average Price, and Lead Time to Purchase.
  4. 04
    Group by Vendor and Product Category to audit major spend categories (e.g. Aluminium Extrusions, Glass, Hardware, Consumables).

Common mistakes

  • Evaluating spend totals without separating capital equipment tooling from consumable project materials.
  • Not auditing invoice price variances against initial purchase order agreed rates.

Was this article helpful?

Running a window or door factory?

Ask for a demo