Physical Inventory

[former_member595216]

Guys I have a question ....we are doing inventory count and we created a document in MI01 and in MI04 for few materials we set the indicator ZERO COUNT. These materials have batches as well. When I am doing MI07 for these materials I am getting the

Deficit of SL Unrestricted-use 8,981 EA : 20000539 MX01 1002 0000000975

Message no. M7021

My understanding is when the stock set to zero and I shouldn't get deficit error.Please see the attached and let me know if I am missing some basic undersating about proces.

screen shots

[former_member197616]

Hi ,

I see that there is only 10EA in your storage location 1002 OF BATCH 0000003692 . Probably you can try with that . Also please check the MC.9 standard report for valuated stock and the Accounting view of the MM03 for the available stock comparision .

As you re telling that there is an inconsitancy in the available stocks , you try an issue at MIGO without saving to see the error message and you get the same deficit ?

Please try this report RM07KO01 and below

1. 1618888 – How to deal with stock inconsistency?

2. 76926 – Checklist for stock inconsistencies

3. 204393 – Inconsistencies between stocks of MARD and MBEW

4. 2010127 – Inappropriate customizing change of material type may cause stock inconsistency.

5. 32236 – Incorrect stock qty or stock value in material master

6. 392205 – Analysis of stock in transit/correction for split valuation

7. 1908994 – MMPV: Error M3705 – Period closing terminated due to negative stoc

and check out this link.

https://blogs.sap.com/2015/01/30/stock-inconsistency/

Regards,

[former_member595216]

I analyzed MSEG table and found that there is a difference in storage location qty and batch qty. It could be a possibility because many consumptions had happened without batch entry. That’s the reason we have qty mismatch. We like to clean this discrepancy using inventory count process so from next month we can operate.

[former_member193808]

Hi Sethi,

Can you check the overall stock level from MB52 or MMBE/ or try MB5B stock on posting date from Physical count date till current date?

It is possible that there are some transactions happened from MI01 date provided till current date. The batch you are referring to has only 10 EA available at the time of physical inventory count date.

Thanks

Prem

[vijay2006ece]

Hi Sethi,

Need to understand, while creating PID, are you selected 'Freeze book Inventory' and not selected 'posting block'?

In the above scenario, While creating PID, suppose stock is 10 and it got moved/consumed. So counted is '0'. While posting system has to remove 10 from plant/sloc which is not exists now. So it is giving deficit error.

Please verify and comeback.

[former_member233510]

Check the batch status, if it is in restricted, then change it to unrestricted and retry MI07. Also, check the below SAP Note,

118968 - MI07:Error w/ neg.differencs of restricted batches.

[former_member193808]

Hello,

Are you maintaining the date properly ? You are trying to zero out the stock of 8,991 EA, but deficit of 8,981 EA shows up on that date.

Check if there any pending documents for this material - batch. Also check the date of physical inventory document.

Thanks

Prem