Andy is an experienced Microsoft Certified Implementation Specialist for Dynamics NAV who has been working with NAV since 2002 as a Consultant and Project Manager.
Dynamics NAV - Slow Moving Stock Report
Do you need to know which stock items are the slow movers?
Do you need to know which stock isn't selling? Do you want to know which stock items are slow movers? Do you want to clear out old stock on a regular basis?
The best way to do this is by running the 'Item Age Composition – Qty' report in NAV.
The report can be found in Departments/Purchase/Inventory & Costing/Reports:
Enter the Ending Date – (Today)
Period Length (1Y)
Location Filter (W-SO)
Then preview the report.
Next, choose the 'Save to Excel' option:
Open the spreadsheet and delete the first 7 rows:
Then select columns A to K and turn on the filter function:
Then filter column G for Zero values:
The report will then show all items with no movements in the last year.
If you want to look at a shorter or longer period, change the ‘Period Length’ on the Options tab of the report.
I find their approach to our relationship very professional whilst being refreshingly realistic. We now consider them to be part of our teamLee Crowhurst, Technical Director