Batches with zero quantity in physical inventory document and problem in posting block

[Former Member]

Greetings to all...

I have created Physical Inventory Document using MI01 Tcode. I notice that batches that are not contain any stock I can see in the inventory document.

I read in discussion forum that activate the check box of "Only consider batch stock records without stock" but I unable to find that check box.If some one has the answer please send screen shot.

I have another query.

I have checked Posting Block option while creating Inventory Document, still users able to do transactions. How can I restrict users to do postings.

Thanks and regards,

AR

[JL23]

Just stop using this MI01 transaction for phyiscal inventory, it is the manual way to create a physical inventory and hence only useful to count a few materials but not useful for regular annual inventories.

If you leave the batch field empty in MI01 then SAP proposes all batches that you have for that material, if you don't want that then enter the batch numbers that you want count manually as well.

The transaction that is used by professionals to create physical inventory documents is MI31 and here you have the option to select only batches with stock.

[Former Member]

Hi,

Thanks for the solution

Is there any step by step refer notes to delete the batch stock segments with zero stock ?

Is there any alternate way to block the stocks till we post the inventory difference.

Thanks and Regards,

AR

[Prasoon]

Hi,

I hope archival will be the ideal way - please refer the doc: https://blogs.sap.com/2013/03/05/sap-data-archiving-mmspstock-archiving-batch-master-records/

If there will be huge delay for posting after entering the count, I hope you need to train the users to post the differences asap or you may hold the count entry till the pre-requisites are completed. Moreover, even if a goods movement will be posted after entering the count, you can check the freeze book inventory option in OMBP and the "Adjust Book Inventory" in OLMB-Settings for Physical Inventory.

Regards,

Prasoon

[Prasoon]

Hi,

I have seen the indicator "Only consider batch stock records without stock" in batch archival process with object MM_SPSTOCK - not in physical inventory. Seems you are confused with it:

The archival process in SARA with object MM_SPSTOCK can delete the batch stock segments with zero stock and hence it wont be available in PI or any search help.

For the second query, the posting block is valid only until you enter the count in MI04 - it wont check whether the count is posted or not and changes the posting block indicator autmatically after MI04. Refer the notes: 1502385 Physical Inventory, Posting Block Removed After Count and 1502321 Physical Inventory Posting Block Removed

Regards,

Prasoon