WM - Report for stock with storage time

[Former Member]

Hi Guru,

How can I get a report with material_name, quantity, and their storage time?

e.g. part A putaway on 2008/1/1, 100 EA

The report will show:

material Qty storage time

part A 100 EA (2008/12/10 - 2008/1/1)

We want to find out the stock which have a long storage time - dead stock.

Thanks,

[former_member536836 · Accepted solution]

you can go in LX03 & set up the layout in which you can select last movement date.There are also other parameters.

Regards,

Prashant

[csaba_szommer]

Hi,

Information that comes from WM can be misleading. Even if you have the stock long ago, WM movements may happen within the WH for that material (and this does not mean IM movement but the quant-data in WM may change).

I think you should consider the use of dead stock and slow moving stock reports (MC46 , MC50). MC.A report can also be used to get information on goods movements.

Of course, depending on your WM strategy and processes you can extract the necessary information. E.g. in LX02 you can see the GR date, SLED/BBD, the already mentioned last movement, last removal, etc - check the layout.

Regards,

Csaba

[Former Member]

Hi

In transaction LT10 with your warehouse and in the st type put *** you will see a column called 'Durat' this is Duration and shows you how long in days it has been there. This changes at midnight and so if the field is blank it means that it went in there today.

I hope that this helps

Frenchy