Skip to main content
Statistical Process Control (SPC) & Control Charts — A build-to-order Frappe app that turns ERPNext Quality Inspection data i — 1/1Illustrative preview

A build-to-order Frappe app that turns ERPNext Quality Inspection data into real-time SPC

— X-bar/R, X-MR, p/np/c/u control charts, Cp/Cpk/Pp/Ppk capability indices, and rule-based out-of-control alerts.

ECOSIRE scopes, builds, installs, and supports it for your v15/v16 site.

What is Statistical Process Control (SPC) & Control Charts?

A build-to-order Frappe app that turns ERPNext Quality Inspection data into real-time SPC — X-bar/R, X-MR, p/np/c/u control charts, Cp/Cpk/Pp/Ppk capability indices, and rule-based out-of-control alerts. ECOSIRE scopes, builds, installs, and supports it for your v15/v16 site. Built to order by ECOSIRE for ERPNext v15, v16 — indicative price from $999.00 USD; request a quote for a scoped proposal.

Key Features

X-bar/R and X-bar/S control charts for variable subgroup data, with UCL/CL/LCL computed server-side from your subgroup size and constants (A2, D3, D4, A3, B3, B4)
X-MR (individuals and moving-range) charts for low-volume or single-measurement characteristics
Attribute charts — p, np, c, and u — for defect-rate and defect-count data with variable or fixed sample sizes
Cp, Cpk, Pp, and Ppk process-capability indices calculated against per-characteristic spec limits, target, and tolerance
Western Electric and Nelson rule sets for out-of-control detection (beyond-3-sigma, runs, trends, and zone A/B/C violations)
A `hooks.py` doc event on Quality Inspection `on_submit` that auto-ingests readings into the SPC pipeline — no duplicate data entry
Dedicated Frappe DocTypes (`SPC Characteristic`, `SPC Subgroup`, `SPC Control Chart`, `SPC Capability Study`) modeling the full measurement domain
Whitelisted server methods exposing chart data, limit recomputation, and rule evaluation over the Frappe REST API for machine/gauge integration
`scheduler_events` recomputation of control limits on a defined cadence, so limits reflect a stable, locked baseline period
Real-time out-of-control alerts via ERPNext Notification, email, or Frappe Realtime push the moment a subgroup breaks a rule
Interactive client-script control-chart and capability histogram dashboards with drill-through to the offending subgroup and readings
Trend dashboards filtered by item, production line, work order, shift, and operator to isolate special-cause sources
Role profiles and DocType permissions separating operators (record readings) from quality engineers (edit spec limits, reset baselines)
Baseline/phase management so you can freeze Phase 1 limits and monitor Phase 2 production against them, with a full change audit trail

Built to order, done for you

No DIY setup — a working app, built, installed and supported by ECOSIRE.

  1. 1

    You order

    Start with a one-time build price. We scope it with you at kickoff.

  2. 2

    We build & install

    ECOSIRE builds, configures and installs it on your ERPNext.

  3. 3

    Go live + support

    You go live in about one working week, with two weeks of go-live support. Defects in the code we deliver are fixed free of charge.

Technical Specifications

ERPNext Compatibility
—
License
Licence confirmation required
Python Requirement
Python 3.10+
Database
MariaDB 10.6+

About this Product

Quality engineers in precision and regulated manufacturing collect measurement data in ERPNext through Quality Inspection and Quality Inspection Reading, but the platform stops at pass/fail against a reading value. There is no live control chart, no calculated control limits, no capability study, and no automatic detection of a process drifting toward failure. Teams end up exporting readings into spreadsheets or a separate SPC tool, which breaks the audit trail, delays reaction to special-cause variation, and makes it hard to prove statistical control to an auditor or customer. ERPNext native simply was not built to compute X-bar/R limits or a Cpk against per-characteristic tolerances.

We build a proper Frappe application — its own module, not a pile of loose scripts — that layers a full SPC engine directly on your ERPNext data. New DocTypes model the measurement domain: SPC Characteristic (per item/parameter spec limits, target, tolerance, subgroup size, chart type), SPC Sample and SPC Subgroup for the collected readings, and SPC Control Chart / SPC Capability Study to hold computed results. A hooks.py doc event on Quality Inspection (on_submit) pipes submitted readings into the SPC pipeline automatically, so engineers keep working in the standard Quality Inspection flow and the charts populate themselves. Server-side logic computes control limits (UCL/CL/LCL) for X-bar/R, X-MR (individuals & moving range), and attribute charts (p, np, c, u), plus Cp, Cpk, Pp and Ppk against the characteristic's spec limits.

Out-of-control detection runs the Western Electric and Nelson rule sets — points beyond 3-sigma, runs on one side of the centerline, trends, and zone violations — implemented as whitelisted server methods so results are consistent whether triggered by a doc event or the REST API. A scheduler event (scheduler_events hook) can recompute limits on a fixed cadence and raise alerts (ERPNext Notification, email, or a Frappe Realtime push) the moment a subgroup violates a rule, so the line lead reacts to special-cause variation in minutes rather than at end-of-shift review. The interactive control-chart and capability dashboards are rendered client-side; trend dashboards slice by item, production line, work order, and shift. Access is governed through dedicated role profiles and DocType permissions so operators can record readings while only quality engineers edit spec limits or approve chart resets.

Because every install has different characteristics, tolerances, sampling plans, and reporting needs, this is a build-to-order engagement, not an instant download. After a short scoping call we confirm your chart types, capability requirements, and which inspection points feed the engine, then build and configure the app against your exact ERPNext v15 or v16 site. Typical delivery is one working week from confirmed scope. You receive the installable source, UAT on a staging copy of your instance with a rollback plan, documentation, a training session, and a post-go-live support window — plus the git repository so your team owns the code.

What you get

  • Installable source code for your version of the SPC app (Frappe app installable via bench on your v15/v16 site)
  • Installation and configuration on your environment, including characteristics, spec limits, chart types, and role setup
  • Technical documentation — DocType schema, hooks, whitelisted API methods, and scheduler jobs
  • User guide plus a live training session for quality engineers and line operators
  • UAT on a staging copy of your ERPNext instance with a documented rollback plan before production cutover
  • Post-go-live support window for defect fixes and configuration adjustments
  • Git repository handover so your team owns and can extend the code
  • Statistical validation notes — worked examples confirming control-limit and Cp/Cpk math against your reference data

Who this is for

Quality Engineer (Precision/Regulated Manufacturing)

Owns the SPC program and needs live control charts, correct Cp/Cpk, and rule-based alerts tied directly to ERPNext Quality Inspection data — not exported spreadsheets that break the audit trail.

Quality / Plant Manager

Wants shift- and line-level trend dashboards to see which processes are drifting out of control and to demonstrate statistical control to customers and auditors from one system of record.

Manufacturing / Process Engineer

Uses capability studies and out-of-control signals to isolate special-cause variation on specific work orders, lines, or operators and drive corrective action quickly.

ERPNext Administrator / IT Lead

Needs a clean, upgrade-safe Frappe app with proper DocTypes, permissions, and REST endpoints that fits the existing v15/v16 site and can be maintained and extended in-house.

How Statistical Process Control (SPC) & Control Charts Compares

CriterionECOSIRECustom BuildCompetitorERPNext Native
Control charts (X-bar/R, X-MR, p/np/c/u)Full set, computed server-side from your subgroupsPossible, but you build and validate the mathOften a subset; fixed chart typesNone — no control charts in core
Cp/Cpk/Pp/Ppk capabilityCalculated against per-characteristic spec limitsHand-coded per project; error-proneSometimes; often generic tolerancesNot available
Out-of-control detectionWestern Electric + Nelson rules with alertsMust implement rule sets yourselfBasic 3-sigma at bestPass/fail on reading value only
Quality Inspection integrationAuto-ingest via `on_submit` doc eventYou wire the hooks and test themMay require manual data importData captured but never analyzed for SPC
Fit to your processScoped to your characteristics and tolerancesFully bespoke but time-intensiveGeneric; you adapt to its modelNot applicable
REST API / gauge integrationWhitelisted methods for readings and resultsBuild and secure endpoints yourselfVaries; often closedStandard Frappe API, no SPC endpoints
Ownership & extensibilityGit repo handover; you own the codeYou own it, but carry all build riskVendor-locked; limited source accessCore code, but no SPC to extend
Time to valueone working week build-to-order, then liveMonths of design, build, and validationFast install, but gaps you must fillImmediate, but no SPC capability

Frequently Asked Questions about Statistical Process Control (SPC) & Control Charts

How long does delivery take?

This is a build-to-order app, not an instant download. After a short scoping call to confirm your characteristics, chart types, and inspection points, typical delivery is one working week from confirmed scope. Larger sampling plans or multi-site rollouts may extend that, and we agree the timeline in writing before we start.

Does it work with our existing ERPNext Quality Inspection data?

Yes. The app hooks the standard Quality Inspection `on_submit` doc event and ingests Quality Inspection Reading values into the SPC engine automatically. Operators keep using the native inspection flow — the control charts and capability studies populate themselves, so there is no duplicate data entry.

Which ERPNext versions are supported?

We build against Frappe/ERPNext v15 and v16. We confirm your exact version and site setup during scoping and target that release, so the app installs cleanly via bench and stays compatible with your update path.

What about support and updates after go-live?

Every engagement includes a post-go-live support window for defect fixes and configuration adjustments. Because you receive the full git repository, your team can maintain and extend the app in-house, and we offer ongoing support or version-upgrade retainers separately if you'd prefer we handle it.

Which control charts and capability indices are included?

Variable charts (X-bar/R, X-bar/S, X-MR individuals & moving range), attribute charts (p, np, c, u), and Cp, Cpk, Pp, Ppk capability indices computed against per-characteristic spec limits and tolerances. We confirm which of these you actually need during scoping so you don't pay for chart types you won't use.

How are out-of-control conditions detected and flagged?

The engine runs the Western Electric and Nelson rule sets — points beyond 3-sigma, runs, trends, and zone violations — as whitelisted server methods. When a subgroup breaks a rule, it raises a real-time alert via ERPNext Notification, email, or Frappe Realtime push, with drill-through to the offending readings.

Can we integrate gauges, machines, or external systems?

Yes. Chart data, limit recomputation, and rule evaluation are exposed as whitelisted methods over the Frappe REST API, so automated gauges, PLCs, or MES systems can push readings and pull SPC results programmatically. We scope the specific integration points with you before building.

Request a quote

Statistical Process Control (SPC) & Control Charts

A build-to-order Frappe app that turns ERPNext Quality Inspection data into real-time SPC — X-bar/R, X-MR, p/np/c/u control charts, Cp/Cpk/Pp/Ppk capability indices, and rule-based out-of-control alerts. ECOSIRE scopes, builds, installs, and supports it for your v15/v16 site.

  • X-bar/R and X-bar/S control charts for variable subgroup data, with UCL/CL/LCL computed server-side from your subgroup size and constants (A2, D3, D4, A3, B3, B4)
  • X-MR (individuals and moving-range) charts for low-volume or single-measurement characteristics
  • Attribute charts — p, np, c, and u — for defect-rate and defect-count data with variable or fixed sample sizes
  • Cp, Cpk, Pp, and Ppk process-capability indices calculated against per-characteristic spec limits, target, and tolerance

Request a Quotation

Tell us about your Statistical Process Control (SPC) & Control Charts requirements and we'll send pricing, licensing options and a tailored proposal — usually within one business day.

No payment now. This sends a quote request to our team — we'll follow up by email with pricing and next steps.