WM Materials not counted in last 6 months

[Former Member]

Hello Experts,

We have stocks managed at Warehouse level. We are looking for a report which can show materials that have not undergone physical inventory for last 6 months. ( Materials for which Physical Inventory Document is not created ). I checked Transaction MIDO, but it included items for which Inventory was done, also it does not have a date range as a selection criteria. Can anyone suggest how / where i would get this information ?

Reply would be greatly appreciated.

Regards,

Vijay

[Former Member]

Thanks Jurgen for all the information.

Regards

Vijay

[JL23]

Standard reports are LX22, LX25 and LI15, but they don't give you what you were looking for, that's the reason why I said Z-report

And again, WM is not about counting materials, in WM you count all material in a bin, but you actually select bins to be counted instead of material to be counted. This is THE major difference between IM and WM physical inventory.

[Former Member]

Thanks Jurgen. Perfect. Do we have report in WM that at least tells us when a material was last counted.( we are not using cycle count )

Regards

Vijay

[JL23]

WM inventory is not about materials, it is about bins. Only the LICC Cycle counting quant inventory is about materials.

So you won't find last inventory dates at material level. And quants get deleted when they become zero which means you won't see the last inventory date from there either.

So you can only create a Z-report that reads the physical inventory documents to evaluate which materials were included and which still need to be counted.