Physical Inventory in WM - Clear Differences

[Former Member]

Hi,

Giving below two cases for Inventory Difference Clearing in WM. Refer last column "Our query" - Looking for standard SAP Behavior for clearing differences in the WM level, if WM differences are counted in two different Inventory Documents. Refer Case 1 and Case 2, where inventory differences are posted with two different methods, In both the cases IM and WM stock is matching before and after inventory.

#	Warehouse	St type	bin	Batch no	BOOK Stock	Count	Inventory doc	LI20 Clearing differences in WM	LI21 Clearing Inventory Management differences	Our query
Case 1
1	100	1	Bin1	B1	5	NIL (missing)	1000	Sr no 1 & 2 are having same inventory document. While going into transaction LI20. System is clearing bin in background. Stock updated BIN1 without B1 BATCH, BIN2 with batch no B1	Inventory document 1000 is not coming in list of differences.	NIL
2	100	1	Bin2	B1	0	5 (Additional)	1000		Reason: Inventory differences are settled in LI20 as the same inventory document was having differences for the same batch i.e. One batch found in one & missing from another bin.
Case 2
3	100	1	Bin1	B1	5	NIL (Missing)	1001	Bin Cleared	Inventory document 1001 is appearing in the list of differences. If we are selecting both Inventory documents system generates Material document with two line item one is Inventory Debit & another line item Inventory Credit.	During LI21,as the stock at the inventory & WM level is matching. There should not be any material document posting. But system is posting the material document.
4	100	1	Bin2	B1	0	5 (Additional)	1002	Bin Cleared

Regards,

MG

[former_member220444 · Accepted solution]

Hi IBPABAP,

Further to your query for the Physical inventory difference posting. I would like to mention as below.

a) Case no 1 - there is one Inventory document number 1000, all the differences within the document will be settled during with transaction LI20, Clear WM differences. In your case Same batch is missing from one bin & found in another bin. These will be settled at the WM Level. The differences will not be posted to the Inventory Management. No need to Run Transaction LI21. Even though user goes into li21, document 1000 will not appear on the screen for clearing differences, because the differences have been settled at the WM Level. No need anything into the IM level.

b) Case no 2- there are two inventory document. The differences for each document will not be settled at inventory document level in LI20 Clear WM differences. This is because each Inventory document is a bin number in storager type 999 Differences. All the differences are settled at the Bin Level during WM Inventory differences via LI20.

This the case 2 - differences will be not be cleared for inventory doc 1001 & 1002 , because these will be two different bins in the storage type 999.

Case 2 will lead the differences into the inventory document.

Hope this suffice your query.

Regards,

Manish

[JL23]

Each inventory document has to be closed with difference posting and it is a reference for the material document. Since each inventory document has a difference, you get a for each inventory document a material document.

even across the inventory documents the sum of differences is zero, it cannot be ignored for audit purposes.

[Former Member]

Hi Jurgen,

Thanks for quick reply. our client SME says that he has already seen in WM inventory, if there is not difference at IM & WM level, posting of inventory document will not take place, even you create many inventory document.

If you could please send some help link, where it is clearly mentioned that Each Inventory Document clearing will be done at Document Level not at WM level.

Regards,

MG