WindoorERP Documentation 19.0

Perform deep order lines analytics across product categories, profile finishes, and margins

1 min read Updated 2026-08-28 WindoorERP 19.0

What this does

Analyzes order lines data across multi-dimensional pivot tables and charts to reveal which aluminium profile series, glass layups, and accessory combinations generate the highest sales volume and gross profit.

Before you start

  • Sales Manager or Cost Controller privileges.

Steps

Order lines analytical pivot table by product category and margin

Order lines revenue and quantity bar graph

Important

Drilling down into product line margins identifies low-margin items that require engineering cost optimization or vendor renegotiation.

  1. 01
    Open Sales › Orders › Sales Order Lines and switch to the Pivot or Graph view.
  2. 02
    Select Measures: analyze Quantity Invoiced, Subtotal Untaxed, and Margin.
  3. 03
    Group by Product Category (e.g. Curtain Walls, Thermal Break Sliding Doors, Frameless Glass).
  4. 04
    Group by Order Date › Quarter to track demand trends across different architectural specifications.

Common mistakes

  • Analyzing product line sales without factoring in scrap remnant and cutting waste percentages.
  • Evaluating sales volume alone without filtering by net profit margin.

Continue learning

Audit sales team operations, team member targets, and executive revenue dashboards Monitors team-level order generation, monthly target completion rates, and lead… Audit product sales velocity, profile series popularity, and fabrication mix Evaluates the popularity and profitability of individual window and door…

Was this article helpful?

Running a window or door factory?

Ask for a demo