MI20 Report problems

[Former Member]

I am having a real issue with my MI20 report.  I created my physical inventory doc, entered the count, confirmed that I have existing balances for the item numbers that I have on my physical inventory doc, but when I run that report, it tells me that the book value for all of my items on the physical inventory doc = 0.

[JL23 · Accepted solution]

Is there really a book value in this report? I think you can only get a difference value.

Can you do a counter check in transaction MB52 to see if your materials have values.

What about the date, are you eventually operating with past dates?

[Former Member · Accepted solution]

The report has the following columns from left to right on the screen:

• PhysInvDoc
• Item
• Material
• Batch
• Plnt
• SLoc
• Book Quantity
• Qty Counted
• Difference qty
• Difference amt

I have confirmed that my materials have values.  The dates are good.  The weird thing is that it is only happening for 2 business units...all others are fine.

[Former Member · Accepted solution]

Forgot this part...

Because there is no book value showing up on the report, it is displaying Difference qty and Difference amts that are not valid...and if I post the report, it actually doubles my inventory.

For example:

Item 100 has a qty = 1 and a Unit Price = $100.  When I entered the count, I entered in qty = 1.  But on the report, it shows that my Difference qty = 1 and my Difference amt = 100 so when I post it, my inventory now says:

Item 100 has a qty = 2 for a value of $200...thereby doubling my inventory.

[JL23 · Accepted solution]

yes, I have the same columns, but there is no book value column, not among yours, just book quantity and  difference value.

Prices are also not maintained at a BU level, they are at plan level.

So there is a lot potential to clarify, you should use screenshots. This is much better than saying "the dates are good" . Are you having special stock item? Is the material split valuated. Is SAP and the process new for you, or do you already have experience?

Show the difference list, show the MB52, make sure people here are able to match the entries shown between the screenshots, of course you can hide names, but you should show numbers for plant and material.

[JL23 · Accepted solution]

this sounds pretty much like posting to a zero stock than to the actual stock. Maybe posting to blocked stock while the real stock is in unrestricted use.

Please show screenshots.

[Former Member · Accepted solution]

Yes, sorry about that...Book Qty is shown.

Here are some screenshots...

[JL23 · Accepted solution]

Can you add another one from MB51 for one of these materials showing all movements from current and previous month.

Right now it looks like you created the inventory document for zero stock materials, counted either before the stock was added or created with freezing inventory.

It would be good to know when the inventory document was created and when it was counted  and if the difference is already posted.

[Former Member · Accepted solution]

Here is the MB51...

All of these values displaying in MI20 have Book qty and have had it since August 2012.  The document was created in July 2015 and nothing has been posted.

[former_member183424 · Accepted solution]

Here your screen shot of MB51 shows for material 20000890 and 20024548. I can't able to see any stock in MB52 for these two materials, hence your MI20 is showing correct for these two materials (at least).

Coming into the material number 20021541, Can you please show us MB51 screen shot this material ?

What is the date of your physical inventory document ? What is the stock showing in MB5B for this material for the key date (date of PI document) ?

[JL23 · Accepted solution]

Saying inventory was created in July does not get us further, it is very very important to know the exact dates and to compare those dates with  entry date of the movements for a root cause analysis.

Your example from MB51 does not match with any number from MB52 stock list so it is not an evidence for your differences.

Do you use selection screen variants to create physical inventory documents, if so, then share a screenshot to know about the stock selection

[Former Member · Accepted solution]

Basically nothing has moved in SAP for these items in this plant, except for those 2 items that show '0' in MI20 - that is the only thing that is correct on that MI20 report.  When I ran the MB51, I put all of the items in the material selection and only those 2 items have activity, which is why they do not show up on MB52...

[Former Member · Accepted solution]

For 20021541, the MB51 screen looks like this:

This 561 movement was the original MM load from Maximo that we did when we converted from Maximo to SAP.

When I run the MB5B for the date of the PI doc, I get the same information as is on the MB52 screenshot.

[Former Member · Accepted solution]

Sorry...I misspoke.  On my original MB51 screen shot, I only put those 2 items in.  Here is MB51 with all items.

As you can see, 20000890 and 20024548 are the only ones that show movement out of the storeroom, which is why they are showing as 0 on the MI20...this is the only one that is correct.

[former_member183424 · Accepted solution]

How did you create this PI document ? Is it from MI01 ? What about table level ISEG?

What if you create another PI document for just one material (you can take material 20021541) ? Okay you can delete it after check MI20 for new PI document.

If everything seems fine from your side for this new testing, then I assume there must be a hard table update for ISEG for this particular document.

[Former Member · Accepted solution]

I created this via MI01.  I don't have access to the table level ISEG.  I created a new PI document for all items and I still get the same issue on MI20...all book qty = 0.

[JL23 · Accepted solution]

Can you show a screenshot from MMBE for one of these materials and another one from MI05.

This will help to compare if the inventory is entered to the right stock

[Former Member · Accepted solution]

Ok...I figured out what was wrong with this report.  I had multiple Physical Inventory Count documents attached to some of the items (I thought I had deleted all of the extra ones, but I guess I had not) and that was causing the report to spit back book values = 0.  Once I deleted all of the docs, created a new one, and then entered the count, then all of the book values showed up correctly.  Thanks for taking the time to help me investigate this...turns out I had created the problem myself...sorry about that.