We get many questions from customers on how to report on items that have inventory on hand but have had little or no sales for a period of time. The example below will isolate items with zero stock on hand.
Report Solution
- Generate an Inventory > Analysis > Inventory Transactions report.
- Create a series of columns and choose an appropriate time range that you want to report on your items. In the screen shot example, we created a quarterly view for the trailing 8 quarters ending in Q3 2024 (screenshot 1). The timeframe and range is up to you. You can perform a series by the Month, Quarter or Year for the time period you wish to analyze.
- Chose the header filter to include items that have had no activity and include inactive items and load the data and run the report for total usage (screenshot 2).
- You can use the Customize button and make sure to make the Qty OH field visible. You may also want to make the Inventory Cost field visible as well (screenshot 3).
- You can use the data column filter for the Qty OH field and make sure the filter the results to only items with a Qty OH greater than zero (screenshot 4).
- If you are trying to isolate items with zero transactions, you can filter on your Total column and select Total = zero (screenshot 5). You may just want to instead just sort by the Total column and sort the report for the zero total at the top. This may give you an idea of some of your items that are low usage but not completely inactive.
- You now have a list of items that have stock on hand, yet have had no activity for the range of time that you have selected to analyze. You can output this list for further analysis.
Screenshot 1 - Add a series of time columns

Screenshot 2 - Choose to inclued items with no activity and inactive items.

Screenshot 3 - make the Qty OH and Inventory Cost columns visible

Screenshot 4 - Column filter for Qty OH field set to greater than zero

Screenshot 5 - Column filter for Total = Zero

Alternative - Database Query Solution
Is there a Database Query that shows non-moving stock items?
This report is based on a "from date" so it will need to be altered for your particular circumstance. This query will show you any stock items that have had no transactions after the date that you specify in the query.
To run it, go to (Utilities > Database Queries) in the software and copy/paste the following into the SQL box:
select * from item where (select first 1 itemh.itemcode from itemh where itemh.dat_ > :DATE and itemh.itemcode = item.itemcode and TYPES in ('POREC', 'ISSUE', 'JOBREC', 'PICK')) is null and ITEMSTATUS = 'Active'
After pasting it, change the date to whatever "from date" you'd like. Be sure to keep the single quotes around the date. Then, click OK and the report should populate.
Related Artcile