Now accepting guest editorial from SAP, Oracle, Workday and ServiceNow practitioners.Pitch a guide
The Sign-Off Table

Lesson 6 of 6

Testing counts and reconciliation with inventory management

10 min

Listen to this lesson

0:00 / 7:04

The final test of a warehouse system is simple to state: does the stock in the bins equal the stock in the books? For embedded EWM that means EWM bin stock, inventory management stock per storage location, and the inventory value in finance must agree, and when they do not, every difference must be explained. This lesson builds the test set and the reconciliation routine Contoso uses.

Three levels that must agree

EWM bin stockQuants per bin, handling unit, stock type and owner in warehouse 1710
Inventory managementStock per plant 1710, storage locations 171R and 171A, by stock type
FinanceInventory value on the balance sheet for plant 1710 at standard cost
The three views of the same stock.
The Sign-Off Table · thesignofftable.com/academy/sap-ewm-204

EWM stock summed over all bins for a product and stock type should equal inventory management stock in 171R plus 171A, allowing only for differences that are posted in EWM and waiting in the difference analyzer, and for any goods receipt mode that delays messages by design. Inventory management quantity times standard cost should equal the inventory value Dan sees.

The reconciliation equation: EWM bins must equal 171R plus 171A, allowing only for explained timing items, and quantity times standard cost must equal the balance sheet value.
The Sign-Off Table · thesignofftable.com/academy/sap-ewm-204

The test set

IDScenarioExpected result
PI-01Cycle count, no differencesDocument completed; completeness updated; no analyzer entries
PI-02Count difference within tolerancePosted by Marcus; difference in analyzer; cleared after wait time
PI-03Count difference above toleranceRecount created for another user; Dan approves clearing
PI-04Offsetting differences in two binsNet zero in analyzer; nothing posted to inventory management
PI-05Low-stock count triggered by pickingDocument created in background when bin drops below threshold
RP-01Planned replenishment overnightTasks per rounding rules; bins at expected quantities
RP-02Direct replenishment from a pick denialPicker receives the replenishment as next task
AM-01Ad hoc HU move with reasonBin changed; no inventory management posting
AM-02Posting change to blocked and backMaterial documents both ways; stock type correct in bin
RC-01Daily stock comparisonNo unexplained differences between EWM and inventory management

Physical inventory, replenishment and internal movement tests for warehouse 1710.

The stock comparison and its trap

SAP provides a stock comparison between EWM and inventory management (/SCWM/ERP_STOCKCHECK). SAP's course material is explicit that it assumes EWM stock is correct and adjusts the other side, and cautions against using it routinely instead of fixing root causes. In testing, run it to find differences, then trace each one: a failed interface message, a delayed goods receipt mode, an uncleared analyzer entry, or a real defect. Never let it silently correct differences during a test cycle.

  1. Run comparisonFor products touched today, compare EWM and inventory management
  2. List differencesProduct, stock type, quantity, storage location
  3. ExplainAnalyzer entry? Delayed message? Failed posting? Unknown?
  4. ActClear, reprocess, or raise a defect with evidence
  5. Value checkQuantity × standard cost against Dan's inventory balance
Contoso's daily reconciliation routine during testing.
The Sign-Off Table · thesignofftable.com/academy/sap-ewm-204

Rehearse the year end

Even with continuous counting, rehearse the year-end steps in the quality system: the completeness report per PI area, the clearing of all analyzer entries, the stock comparison, and the value reconciliation with finance. Luis puts the rehearsal into the cutover plan because the initial stock load into EWM at go-live is itself a count: stock is loaded into bins from the classic warehouse data, and the first reconciliation proves the load.

The year-end rehearsal in the quality system follows the same order as the real year end, ending with Dan's value reconciliation.
The Sign-Off Table · thesignofftable.com/academy/sap-ewm-204

What would you do?

The daily comparison shows EWM 34 and inventory management 40 alternators. The analyzer shows −6 for the same product, posted today, wait time one day. Priya asks whether to raise a defect. What is the right answer?

Difference found in the daily comparisonClassificationAction
Analyzer entry within wait timeDesigned timingCheck it clears tomorrow
Failed queue or posting messageInterface or technicalReprocess; raise a defect if it recurs
Goods receipt from production posted in IM but not put awayProcess timing (171B → 171A)Confirm the putaway task and recheck
No explanationDefectRaise in SAP Cloud ALM with both stock figures and documents

Classifying each comparison difference keeps real defects separate from designed timing.

Key points
  • EWM bin stock, inventory management stock and finance value must agree, or differ only for explained reasons.
  • Test counts, tolerances, recounts, netting, replenishment and internal movements.
  • Use the stock comparison to find differences, not to fix them.
  • Rehearse year end and treat the initial stock load as the first reconciliation.

Check your understanding · not graded

Lesson check

  1. 1. EWM shows 34 and inventory management 40; the analyzer has −6. Is this a defect?

  2. 2. What does SAP's stock comparison assume?

  3. 3. Which check proves the finance side of reconciliation?

  4. 4. Why does Luis treat the initial stock load as a reconciliation?