I am trying to make a report showing which items have not moved in 6 months or more. I have been told the Item LedgerTable or the Warehouse EntryTable would be the best tablesto use. Does anyoe else have input on this?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Methanol,
I'm thinking of 2 different ways to do this:
- have a closer look at the definition of the Net Change field on the Item card - you may find it in NAVs Help or even better in the Advanced Jet Designer. I believe this field sums quantities during a certain period - you may apply a date filter. If that value equals zero you have the items that have not moved.
- create an array of all items with an NL(Filter), create an array of all item nos from the item ledger entry table with a posting date younger than 6 months with another NL(Filter). Get the difference between these arrays with an NP(Difference).
Please sign in to leave a comment.