What is Material Price Control?

Material Price Control is a guardrail app for ERPNext that protects inventory valuation during stock-in transactions such as Purchase Receipts, Purchase Invoices (with Update Stock), and Stock Entries.

It automatically checks incoming material rates against expected values and stops abnormal entries before they damage inventory valuation, COGS, and financial reports.

This app is designed for finance-first, audit-safe ERP usage.

The Problem It Solves

In real operations, wrong valuation rates often happen due to:

• Wrong UOM selection

• Incorrect quantity entry

• Manual data entry mistakes

• Temporary staff or rushed postings

Once posted, these errors:

• Inflate or deflate stock value

• Corrupt P&L and Balance Sheet

• Are extremely hard to trace during audits

Material Price Control stops these errors at the source.

How It Works (Simple Flow)

1. User submits a stock-in transaction

2. Material Price Control runs automatically before submit

3. The incoming rate is compared with expected values

4. Based on deviation:

   • Allowed → Transaction proceeds

   • Warning → Logged and allowed

   • Severe → Blocked (configurable)

Authorized users can override blocks if needed.

Key Features

Real-time Validation
Checks material valuation before document submission.

Flexible Rule System
Define expected rates at:

• Item level

• Item Group level

Warehouse-Specific Rules
Different expected rates for different warehouses or locations.

Date-Range Rules
Temporary pricing rules with From Date / To Date support.

Variance Thresholds
Configure acceptable percentage deviation from expected rate.

Hard Limits (Min / Max)
Absolute floor and ceiling to block extreme errors.

Internal Supplier Filter
Optionally skip validation for internal or inter-company transfers.

Bypass Roles
Allow senior or finance users to override blocks.

Anomaly Logging
Every abnormal rate is logged for audit and review.

Control Charts (ECharts)
Visualize historical rate behavior and outliers.

Item Statistics Report
Mean, standard deviation, UCL / LCL analysis from real data.

Bulk Rule Creation
Create rules for multiple items directly from statistics.

Supported Transactions

• Purchase Receipt

• Purchase Invoice (with Update Stock enabled)

• Stock Entry (incoming items only)

Getting Started (New User Setup)

Step 1: Enable the Guard
Open Cost Valuation Settings and enable Material Price Control.
Set default variance limits and blocking behavior.

Step 2: Create Rules
Create Cost Valuation Rules for:

• Individual items, or

• Item Groups

Optionally define warehouse-specific or date-based rules.

Step 3: Start Posting Normally
The app works automatically.
No change required in user workflow.

Typical Use Cases

• Prevent inflated stock during audits

• Control valuation during new vendor onboarding

• Protect inventory during seasonal price fluctuations

• Enforce finance discipline in ERPNext

• Catch errors before they hit reports

Compatibility

• ERPNext v14, v15, v16

• Frappe Framework v14, v15, v16

• Python 3.10+ (3.11+ for v16)

Designed For

• Finance-driven ERP implementations

• Manufacturing and trading businesses

• Audit-sensitive organizations

• ERPNext users who want SAP-like guardrails