# Slow Moving and Obsolete Inventory

- URL: https://dynamicaccounting.net/slow-moving-and-obsolete-inventory/
- Date: 2008-11-12
- Topics: Sales, Purchasing & Inventory
- Type: original article

Mohammad Daoud has a SQL script designed to provide a list inventory items that have not sold between two dates. This is very useful for create a Slow Moving and Obsolete Inventory lists. For Slow Moving you could easily modify the query to look for a count of sales less than some number rather than not in the sales tables. If you wanted to get creative you even look at from a formula perspective. For example, deliver items where the count of sales over the last year is less than the on hand inventory amount (meaning that you are carrying more than a year’s worth of inventory).

Mohammad has give us a great start to build a more specific report off of.

[HT to Steve Chapman of Rose Business Solutions for pointing this out. I had missed it.)]