Skip to Content
avatar image
Former Member

WM Materials not counted in last 6 months

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 04, 2017 at 08:19 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 04, 2017 at 09:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 04, 2017 at 09:24 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 07, 2017 at 05:33 AM

    Thanks Jurgen for all the information.

    Regards

    Vijay

    Add comment
    10|10000 characters needed characters exceeded