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.)]