Skip to the content

Dynamics NAV - Slow Moving Stock Report

slow moving stock

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:

Item Age Composition â Qty. Report

Enter the Ending Date – (Today)

Period Length (1Y)

Location Filter (W-SO)

Then preview the report.

 

Next, choose the 'Save to Excel' option:

Item Age Composition â Qty. Report

 

Open the spreadsheet and delete the first 7 rows:

Item Age Composition â Qty. Report

 

Then select columns A to K and turn on the filter function:

Item Age Composition â Qty. Report

 

Then filter column G for Zero values:

Item Age Composition â Qty. Report

 

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.

Andrew Trayfoot

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.  

comments powered by Disqus

Latest Blog Posts

I find their approach to our relationship very professional whilst being refreshingly realistic. We now consider them to be part of our team

Lee Crowhurst, Technical Director

Partner with the Experts

With over 200 years of combined experience in Microsoft business solutions, our team will help to get you up and running, as well as building a partnership that keeps you supported, all from our UK offices. 

From functionality and licencing to business strategy, we like your questions; contact our experienced team for open, honest and reliable advice so that we can find the answers.