How does LX23 work when WM stock is greater than IM stock level?

[christopher_bader]

Hello,

In MMBE the WM storage location shows 5 units total, all unrestricted stock. Physically in the WM bin there are 5 units. LS26 shows 19 units. There are no open TR or TO or TPN.

Some of the 19 units of stock are in interim storage types 902, 916, and 922. The Purchase orders and outbound deliveries for the dynamic bin numbers are fulfilled completely and accurately.

The stock differences appear to be related to numerous transfer postings that were done in an attempt to correct stock between own and sales order stock.

When running LX23 without clearing differences, it shows the 14 unit difference as expected.

Am I correct in understanding that if I clear the differences with with LX23, that 14 units will be added to ECC, according to MMBE. Then we will need to goods issue or cycle count out of WM the inventory that doesn't physically exist?

In addition, these are serialized materials. The serial numbers of the 5 units in ECC match the serial numbers of the 5 physical units.

Is there another option, like cycle counting in WM and clearing the differences that way?

Any guidance is greatly appreciated.

Thanks, Chris

[NTeunckens · Accepted solution]

Some references that could help you :

• SAP-KBA 1871525 - Correction cases of stock inconsistencies between IM and WM : link
• SAP-KBA 535043 - Stock comparison with LX23: Difference between WM and IM : link
• SAP-KBA 484788 - LX23: Workaround for clearing difference with serial numbers : link

You could also check the tables (MARD for MM - T320 - LQUA for WM) to find out what's going on (via SAP-Query)?

[christopher_bader]

Thanks Nic - this is very helpful. Since these are serialized units, it seems our only option is to follow advice of note 484788:

As a workaround, you can allow movement types 701 and 702 for transaction MB11 in the short term. You can make this setting in Customizing for the movement types (table T158B).
Ensure that the WM stock remains and the IM stock is adjusted to the WM stock. The posting using movment types 701 and 702 is only carried out in one system. That is, only the IM stock is changed. If the WM stock is incorrect, still proceed as described above and then carry out a WM physical inventory, in which you correct the WM inventory and then clear it to inventory management using report RLLI2100.

Forgive my ignorance but is note 484788 something that would have been a part of more recent versions of SAP IM/WM with serialized materials? It seems odd that this would still need to be the only course of action after all these years. I'm just not as familiar with what kind of notes get incorporated in future releases to correct program errors.

Thanks, Chris

[NTeunckens]

Glad to see that there's some valuable information in these Notes ...

And yes, WM and SerialNumbers have always been a problem. As the direction of SAP WM is that it will probably be deprecated in the near future (under the impulse of S/4HANA-Extended Warehouse Mgmnt), I doubt there is any other solution.

Kind regards

Nic T.