Any way to find out last activity for items in stock?

rico1931
rico1931 Member Posts: 295
in NAV Three Tier
Dynamic Nav 2013 R2 - Is there any way to find out items that are currently in stock but their last activity was before a certain date? I tried going into the Item ledger entry table and filtering out "remaining Qty" <> 0 and posting date before 'date' but that then excludes the last activity which could have been after the posting date I wanted. Not sure if that makes sense, but hoping someone else has gone through this and can give me some advice.

Thanks!
-rico1931

Best Answer

  • rico1931
    rico1931 Member Posts: 295
    Answer ✓
    Meaning the last time this item was consumed/sold/produced/ anything.. we are looking for items that have been sitting on our shelf with no movement greater than 5yrs. I think I found what I'm looking for in the Item Age Composition - Qty report.. just have to add more filters and then modify the excel sheet a little more to get close to where I need to be... Thanks!
    -rico1931

Answers

  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    What do you mean by last activity date??
    See if Warehouse Entry tables helps you.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • rico1931
    rico1931 Member Posts: 295
    Answer ✓
    Meaning the last time this item was consumed/sold/produced/ anything.. we are looking for items that have been sitting on our shelf with no movement greater than 5yrs. I think I found what I'm looking for in the Item Age Composition - Qty report.. just have to add more filters and then modify the excel sheet a little more to get close to where I need to be... Thanks!
    -rico1931

Categories