SAP Warehouse Management

Increase or Decrease Warehouse Stock from WMS and IM

A step-by-step SAP ERP 6.0 walkthrough for adjusting Warehouse Management System and Inventory Management stock balances using the WM Physical Inventory method.

What are the steps to increase or decrease WMS and IM balance?

This demo is to decrease the WMS and IM stock balance to 0 using the WM Physical Inventory Method.

The procedure isolates the target stock in an empty storage bin before the physical inventory adjustment, helping ensure that the bin does not contain other materials during counting and write-off.

Eight-step procedure

WM Physical Inventory Stock Adjustment

1
Transaction LS24

Find the warehouse material storage type and bin

Use LS24 to identify the warehouse material storage type and storage bin.

Find the warehouse material storage type and bin

Take note of the Storage Type and Storage Bin for the stock you wish to set to 0 balance or increase/decrease.

Note down the storage type and bin
2
Transaction LT01

Transfer the stock to an empty bin storage type

Transfer it to an Empty Bin Storage Type. WM Physical Inventory blocks stock count by Bin, and we do not want other materials in the same Bin.

LT01 transfer to an empty bin storage type
  • Input and check that all entries are correct.
  • Enter twice to post.
Create transfer order
3
Transaction LS24

Confirm the destination storage type and bin

You should see the newly transferred Destination Storage Type and Storage Bin.

Stock per material showing the new destination storage type and bin
4
Transaction LI01N

Create the physical inventory record

Create WM Inventory Record
  • Input the Storage Bin for WM Physical Inventory and check.
  • If everything is correct, click the Activate button.
Storage bin physical inventory
5
Transaction LI11N

Input the storage bin to write off

  • Check that there is only 1 material to write off.
  • Tick the Column Zero count.
  • Click Save if all is correct.
Input Storage Bin to Write Off
6
Transaction LI20

Clear differences in WM

Clear WM differences

If everything is correct, tick the item and click the Write off button.

Confirm WM write-off
7
Transaction LI21

Perform the physical write-off in Inventory Management

Clear IM differences
IM write-off
Log for Difference Clearing
8
Verification

Check the stock balance after WM and IM write-off

MMBE Material Overview

WMS also balance 11.

WMS Stock Balance

Tested in SAP ERP 6.0