Skip to Content
0

WM Materials not counted in last 6 months

Apr 04, 2017 at 08:07 PM

68

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Jürgen L
Apr 04, 2017 at 08:19 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Vijay Mane Apr 04, 2017 at 09:14 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
Apr 04, 2017 at 09:24 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Vijay Mane Apr 07, 2017 at 05:33 AM
0

Thanks Jurgen for all the information.

Regards

Vijay

Share
10 |10000 characters needed characters left characters exceeded