SAP Moving Average Price (MAP) Calculator
Materials with price control V are valuated at a moving average price that SAP recalculates on every valuated goods receipt and some invoice postings. This calculator reproduces that arithmetic so you can predict the price before posting, or explain a price movement to a controller.
Your numbers
Total valuated stock quantity before the receipt.
Total value in the valuation view (MBEW-SALK3).
PO net price converted to base unit and local currency.
Freight or duty posted to stock through the PO condition.
Your results
Valid when stock is positive and the receipt is valuated at PO price. Negative stock, invoice price differences posted to stock and revaluation postings change the result in the system.
New moving average price vs receipt price
Sweeps Receipt price per unit from 8 to 20, holding your other inputs fixed.
Valuation anomaly review
Optional: we can scan an export of valuation data for price outliers and negative stock and send back a short list to investigate.
Optional. The tool and every export work without this. No spam.
How to use the calculator
Enter the stock quantity and stock value that you see in the material valuation data, then the receipt quantity and the net price per unit. If the purchase order carries planned delivery costs such as freight or customs, add the amount in the delivery cost field, because those are valuated into stock in the same posting. The tool returns the new quantity, value, moving average price and the percentage move. The chart shows how sensitive the new price is to the receipt price.
- Convert PO price units to the base unit first
- Use local currency values
- Check MBEW for current quantity and value
The formula
The moving average price equals total stock value divided by total stock quantity. On a goods receipt against a purchase order, SAP adds the receipt value to stock value and the receipt quantity to stock quantity, then divides. Because both numerator and denominator grow, a small receipt barely moves the price while a large receipt at a different price drives the average toward the new price. For example, 500 units valued at 6,250 (12.50 each) plus 300 units at 13.80 gives 10,390 over 800 units, or 12.99.
Why price control V can surprise you
Moving average price makes the cost of goods sold move with every receipt, which is useful for traded goods but noisy for production materials. Consuming stock at the moving average also means a late invoice at a different price changes the value without changing the quantity, and if stock has already been consumed, the difference goes to the price difference account instead. For stable product costing most manufacturers use standard price S with purchase price variance posted separately.
Common mistakes
Typical mistakes include applying the formula when stock is negative, forgetting that a price unit of 100 or 1000 divides the price, and mixing foreign currency with local currency values. Valuation levels also matter: if valuation is at plant level, each plant has its own price, while company code level valuation shares one.
- Check the price unit before entering price
- Remember MAP is per valuation area
- Large single receipts move the price the most
Frequently Asked Questions
Where is the moving average price stored?
In the accounting view of the material master and in table MBEW, field VERPR for the moving average price. Stock value is in SALK3 and total valuated stock quantity is in LBKUM.
What happens when I post a goods receipt with price control V?
SAP posts the receipt at PO price, adds it to stock value and quantity, and recalculates the moving average price. The accounting document debits inventory and credits GR/IR.
What is the difference between price control S and V?
Under S, stock is valued at a fixed standard price and variances go to price difference accounts. Under V, stock is valued at the moving average and the price adjusts with each valuated receipt.
Can the moving average price go wrong?
Yes, mainly through negative stock, bad migration balances or invoices at unusual prices after consumption. Compare value divided by quantity with VERPR regularly and investigate large gaps.
Netray can scan your SAP valuation data for materials with unusual price swings and explain each movement from the underlying documents, read-only.
Related Tools
SAP Material Valuation and Price Unit Worksheet
A fill-in worksheet that recomputes inventory value per material from quantity, price and price unit, so you can reconcile with MBEW or migration loads.
SAPSAP Invoice Verification Tolerance Calculator
Simulates the price and quantity variance checks behind MIRO invoice blocks so you can test tolerance limits before changing OMR6.
SAPSAP MRP Lot Sizing Cost Comparison Calculator
Compares annual ordering plus holding cost for lot-for-lot, a fixed lot size and the economic order quantity, so you can pick a sensible SAP lot sizing procedure.
Discrete ManufacturingInventory Carrying Cost Calculator
Build your true annual carrying cost from capital, storage, insurance, and obsolescence components - and see what an inventory reduction target is worth.