Hi, we have Nav 2009 R2 & Jet Essentials
We have been asked to produce a Slow Moving Stock report for the Auditors & there is nothing in standard Nav or Jet Essentials that will meet this, so looking for help.
The criteria is, Item Balance as at 31/12/2014 is greater than 0
Items that have sold less than 10 in the period 01/01/2013..31/12/2014
For us additional filters, Location = Main & Inventory Posting Group = RAW
Any help appreciated, I did try to modify Nav022 Inventory Availability but it would not work out the Consumption Field within the date period, it always returned the complete consumption of that Item
I was using Consumption from Item Ledger Entry table to show movement.
Thanks in advance
Date
Votes
1 comment
-
Jet Reports Historic Posts You may have to change the fields a bit based on your table (I don't have a "Consumption" field) but I created a replicator that used a NL(Sum) as a filter.
Since I needed a range, the only way I could get it to work was to have an NL(Join) in cell C3 to say, "One of these values". In my testing > and < did not work, nor did a range. The range is set to -10 to 0 because as you ship items, it removes it from the stock, hence needing to look at negative values.
I also based this on Sales Shipments because that was the only field that had data (Sales Invoices did not have values in my CRONUS database).
Column E is the actual function while column F is my proof. While this may not be the exact function you need, hopefully it illustrates what you can do.
Hope that helps. (I also am using US date format, FYI)
Please sign in to leave a comment.