Inventory Net Realizable Value (NRV) and Write-Down Provision Report (IAS 2)
Short answer: A report that compares the cost of inventory by material with the net realizable value calculated from recent sales prices less costs to sell, and calculates the write-down provision needed. Lines such as returns or free-of-charge sales are excluded by rule, and materials without sales are flagged; the result is an audit-ready listing.
- Estimated effort
- M · 8–12 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
Standard lowest value determination (MRN0, MRN1, MRN2) proposes devaluation based on market price, range of coverage and movement rate; but it does not calculate net realizable value from actual sales invoices, after deducting costs to sell and excluding returns, free-of-charge or intercompany sales. The IAS 2 listing is usually assembled in Excel.
Who uses it? Finance and reporting teams, cost accounting, auditors and IFRS reporting teams.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| MBEWMaterial Valuation | Stock quantity, total value, valuation class and price control | — | ECC + S/4 |
| VBRKBilling Document Header | Invoice header: date, cancellation, billing type, rate | — | ECC + S/4 |
| VBRPBilling Document: Item Data | Invoice items: material, quantity, net value | VBRP-VBELN = VBRK-VBELN | ECC + S/4 |
| MARAGeneral Material Data | Material type, material group, base unit | MARA-MATNR = MBEW-MATNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = MBEW-MATNR | ECC + S/4 |
| MARMUnits of Measure for Material | Conversion of sales unit to base unit | MARM-MATNR = VBRP-MATNR AND MARM-MEINH = VBRP-VRKME | ECC + S/4 |
| T001KValuation Area | Link of valuation area to company code | T001K-BWKEY = MBEW-BWKEY | ECC + S/4 |
| CKMLCRMaterial Ledger: Period Totals (Values) | Material Ledger period price (S/4HANA) | — | S/4HANA only |
S/4HANA notes
- MBEW: In S/4HANA the Material Ledger is mandatory and valuation data is read through a compatibility view. Prices remain readable; validate value calculations against the currency and valuation view in use.
BAPIs and functions used
- CONVERT_TO_LOCAL_CURRENCYTranslate Foreign Currency Amount to Local Currency. Converts the invoice amount to local currency
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_BUKRS | Company code | Single value | T001K-BUKRS | Yes | 1000 |
| S_BWKEY | Valuation area (plant) | Range / multiple | MBEW-BWKEY | No | 1000 |
| P_PERIOD | Closing period / year | Single value | — | Yes | 12.2026 |
| S_FKDAT | Sales price period | Range / multiple | VBRK-FKDAT | Yes | 01.10.2026 – 31.12.2026 |
| S_BKLAS | Valuation class | Range / multiple | MBEW-BKLAS | No | 7920 |
| P_NOSALE | Without sales: last price / list price / leave empty | Radio button | — | No | Son fiyat |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Plant | MBEW-BWKEY |
| 2 | Material | MBEW-MATNR |
| 3 | Description | MAKT-MAKTX |
| 4 | Stock quantity | MBEW-LBKUM |
| 5 | Cost value | MBEW-SALK3 |
| 6 | Unit sales price | Calculated Σ VBRP-NETWR (local currency) / Σ VBRP-FKIMG (base unit), excluded invoices left out |
| 7 | Costs to sell % | Calculated Rate set during installation for the material group |
| 8 | NRV | Calculated Unit price × (1 − costs to sell %) × stock quantity |
| 9 | Write-down needed | Calculated max(0, cost value − NRV) |
| 10 | Note | Calculated No sales, list price used or number of excluded invoices |
Sample output
| Plant | Material | Description | Stock quantity | Cost value | Unit sales price | Costs to sell % | NRV | Write-down needed | Note |
|---|---|---|---|---|---|---|---|---|---|
| 1000 | MK-NEV-150 | Duvet cover set double, grey | 4,200 | 1,890,000 | 520 | 12 | 1,921,920 | 0 | |
| 1000 | MK-HAV-070 | Bath towel 70x140, white | 9,800 | 1,176,000 | 128 | 12 | 1,103,872 | 72,128 | |
| 1000 | IP-PES-NM60 | Polyester yarn Nm 60 | 15,500 | 1,069,500 | 66 | 6 | 961,620 | 107,880 | 2 return invoices excluded |
| 2000 | MK-PERDE-OLD | Curtain panel, old season | 1,300 | 247,000 | 95 | 15 | 104,975 | 142,025 | No sales; last price used |
How does the report work?
- Stock quantity and cost value are taken by valuation area (plant) from MBEW (LBKUM, SALK3) for the closing period; in S/4HANA the Material Ledger price can be read from CKMLCR for actual cost. MBEWH is used for prior periods.
- Recent sales price: invoices in the chosen period (VBRK/VBRP) are read per material; cancelled invoices (VBRK-FKSTO), returns and credit memos, billing types excluded during installation and intercompany customers are left out. Unit price = Σ net value (converted to local currency) / Σ billed quantity (converted to the base unit).
- Costs to sell: rates defined during installation by material group or product hierarchy (freight, commission, marketing) are deducted from the unit price. The rates are the company’s own data and are reviewed at period end.
- NRV = (unit sales price − costs to sell) × stock quantity. Write-down needed = max(0, cost value − NRV).
- Materials without sales in the period are flagged separately; for these the program, by selection, looks for the last sales price, uses the list price (price condition) or leaves them for user assessment. For semi-finished goods and raw materials the cost to complete is deducted with the method chosen during installation.
- The report totals by material, valuation class and plant; the difference to the prior period provision is shown as the amount to post. In S/4HANA the inventory value can be reconciled with ACDOCA; in ECC the flow with MBEW and BSEG is the same.
Performance notes
Read invoice items in one SELECT aggregated by material for the period and material list (GROUP BY). Convert currency per document with the rate on the invoice header. For many plants run the report in the background and store the result.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Clicking the unit price lists the invoices used in the calculation.
- Export to Excel The audit listing is exported to Excel.
- Runs as a background job
Authorization objects
- K_ML_VADisplay of Material Ledger values
- V_VBRK_VKOBilling document display by sales organization
- F_BKPF_BUKFinancial data display by company code
Frequently asked questions
How does it differ from standard lowest value determination?
MRN0-MRN2 propose devaluation based on market price, range of coverage or movement rate and can change the price. This report calculates NRV from actual sales invoices and shows the write-down needed; the posting decision is made in accounting. Both methods can be used together.
Where do the costs to sell rates come from?
The rates come from the company's own cost analysis and are entered in a table by material group or product hierarchy during installation. The program does not suggest rates; check at period end that they are current.
Does the report post the provision?
No, the report calculates the amount and shows the difference to the prior period. The posting is entered by accounting according to the company's provision policy; it can be automated with a separate posting program if needed.
Related reports
Mass Material Price Change and Inventory Debit/Credit Posting
A custom program that posts moving average or standard price corrections and debits/credits to inventory value from a file, for company and project …
Stock Aging Report
A custom ALV report that shows how many days each material has been in stock since its last goods receipt and which age bucket (0–30, 31–90, 91–180, …
Inventory Book (Envanter Defteri) Report and Print
A custom ALV report and print output that prepares the year-end inventory book from SAP account by account. The closing balance of every balance sheet …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.