Book qty in MI20 report

[Former Member]

Hi all,

Count date - 1st Sep 2009

Posting date - 1st Sep 2009

Document date - 1st Sep 2009

Stocks as on 3st Aug 2009 - 31 Ea When i run MI20 report now,

I am getting book qty as zero. But there were stocks as on end Aug 2009.

What could be the reason?

[JL23]

do you do physical inventory in MM or with WM?

Stocks as on 3st Aug 2009 - 31 Ea 

Why do you mention that if you counted on September 1st.

When did you create the physical inventory documents?

was it created with freezing book inventory?

[Former Member]

Hi,

I mentioned about the stocks on August u2013 Just to clarify impact of u2018Freezing the book inventory balanceu2019 indicator.

It was not flagged.

Thanks

Ravi

[Former Member]

Check

MB51 & MB52 and find out the material Movements

[JL23]

please answer my other questions too

[Former Member]

Hi Jürgen L,

I am sorry. My mistake. Storage location is ware house managed.

My next doubt is how is that if Sloc is ware house managed, what is the impact on book quantity in MI20.

Which report do we have to refer to if Sloc is ware house managed.

Thank you very much.

Ravi

[JL23]

MI20 cannot be used for WM inventories.

difference lists in WM can be called by LX17 and LX18 and LI15.

But LX17 only works before the inventory document is cleared.

LX18 does not show material differences only bins.

[Former Member]

Hi Jürgen L,

Thank you for response. It would have very helpful if you had mentioned what is the effect of using MI20 t-code for ware house managed materials. In what way it affects and how?

Thanks a lot

Best regards

Ravi

[JL23]

MI20 reads inventory documents stored in the MM tables IKPF and ISEG, it does not read the tables LINV, LINK and LINP which are the inventory docuement tables in case of a WM inventory.

But, as a storage location can become warehouse managed after it was already used for years, MI20 must not issue an error message telling you that the location is WM. MI20 allows you still to check differences for that location before it became WM.

So just the user must know that he is supposed to use MI20 in case of inventory done with inventory managment, and the other transactions in case the inventory was done with WM.

[Former Member]

Hi,

I would like to know which field which refers to Book quantity in ware house management tables?

I am getting only book value field.

I did check LINK, LINV and LINP tables.

Appreciate your input.

Thanks

Ravi