26 April 2012
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
25 April 2012
Last weekend I went on a day trip to London. On the Tube, I saw a series of posters from the company managing the advertisement space on the Tube: “87% of the passengers welcome ads on the Tube”, “Each Tube traveller spends on average 44 min on the Tube every day”, “1 billion people journey by Tube every year”. Next I was expecting a poster like “What are you waiting for? Place your ad here.”
This is probably what you would expect from the average blog on Document Management and Delivery Add-ons for ERP: “Each invoice you send by regular mail takes X minutes to process”, “You’re sending XX documents per month.” “Using XXX Document Management System can save you up to xx per month.” That’s not what this blog is about. I think we can agree that this is the way to go. (The number of offerings in the area is proof enough that there is a need for such a solution).
The question then