stocks in a particular storage type on a particular date

[Former Member]

Dear Friends,

I have a question.

There are storage types available in a particular warehouse.

I want to check in a particular storage type and on a particular date (for example 1 week ago), what was the stock of different materials available in that particular storage type.

Do we have a standard transaction or do we need to check in the tables.

Waiting for your reply.

Regards,

Sampath

[csaba_szommer]

Hi,

I guess you think of MB5B's counterpart in WM...sorrowfully those who created the WM module didn't think of the same...

So, you can't solve this by standard reporting tool.

What you can do is:

- get the current stock level of the storage type (/storage bin) (e.g. in LX02)

- get all the goods movement INTO and OUT of that particular storage type (/storage bin) in LT22

- work up the two reports (add all the qty of incoming goods movement to current stock level of that storage type (/bin) and reduce the stock level by the outgoing quantities)

...or you can create your own query (stock - LQUA, TO - LTAK, LTAP).

Regards,

Csaba

[Former Member]

Dear Csaba,

Thanks for your answer.

I think we have to go for a new report development for this.

Sampath