# Inventory Net Realizable Value (NRV) and Write-Down Provision Report (IAS 2)

> 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.

- Type: Report, Custom development, ALV report
- Module: FI
- Estimated effort: M (8–12 working days)
- Last updated: 2026-11-19
- URL: https://nekuhub.com/en/reports/inventory-net-realizable-value-report/


## 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.

### Closest standard alternatives

- MB5L: Lists stock values by account and material; makes no comparison with sales prices.
- CKM3: Shows the Material Ledger price analysis; no net realizable value calculation.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MBEW | Stock quantity, total value, valuation class and price control | Read | - | ECC + S/4 |
| VBRK | Invoice header: date, cancellation, billing type, rate | Read | - | ECC + S/4 |
| VBRP | Invoice items: material, quantity, net value | Read | VBRP-VBELN = VBRK-VBELN | ECC + S/4 |
| MARA | Material type, material group, base unit | Read | MARA-MATNR = MBEW-MATNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = MBEW-MATNR | ECC + S/4 |
| MARM | Conversion of sales unit to base unit | Read | MARM-MATNR = VBRP-MATNR AND MARM-MEINH = VBRP-VRKME | ECC + S/4 |
| T001K | Link of valuation area to company code | Read | T001K-BWKEY = MBEW-BWKEY | ECC + S/4 |
| CKMLCR | Material Ledger period price (S/4HANA) | Read | - | S/4HANA only |

## BAPIs and functions used

- CONVERT_TO_LOCAL_CURRENCY: Converts the invoice amount to local currency

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_BUKRS | Company code | Single value | T001K-BUKRS | Yes |
| S_BWKEY | Valuation area (plant) | Range / multiple | MBEW-BWKEY | No |
| P_PERIOD | Closing period / year | Single value | - | Yes |
| S_FKDAT | Sales price period | Range / multiple | VBRK-FKDAT | Yes |
| S_BKLAS | Valuation class | Range / multiple | MBEW-BKLAS | No |
| P_NOSALE | Without sales: last price / list price / leave empty | Radio button | - | No |

## Output columns

| Column | Source |
|---|---|
| Plant | MBEW-BWKEY |
| Material | MBEW-MATNR |
| Description | MAKT-MAKTX |
| Stock quantity | MBEW-LBKUM |
| Cost value | MBEW-SALK3 |
| Unit sales price | Calculated: Σ VBRP-NETWR (local currency) / Σ VBRP-FKIMG (base unit), excluded invoices left out |
| Costs to sell % | Calculated: Rate set during installation for the material group |
| NRV | Calculated: Unit price × (1 − costs to sell %) × stock quantity |
| Write-down needed | Calculated: max(0, cost value − NRV) |
| Note | Calculated: No sales, list price used or number of excluded invoices |

## How does the report work?

1. 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.
2. 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).
3. 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.
4. NRV = (unit sales price − costs to sell) × stock quantity. Write-down needed = max(0, cost value − NRV).
5. 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.
6. 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.

## Authorization objects

- K_ML_VA: Display of Material Ledger values
- V_VBRK_VKO: Billing document display by sales organization
- F_BKPF_BUK: Financial 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=fi-inventory-net-realizable-value
