# Inactive Inventory

**URL:** <https://community.striven.com/t/inactive-inventory/707>\
**Category:** Reports\
**Created:** [January 31, 2025, 3:47pm UTC](https://community.striven.com/t/inactive-inventory/707 "2025-01-31T15:47:26Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jaredmorland](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@jaredmorland](https://community.striven.com/u/jaredmorland)\
**Post date:** [January 31, 2025, 3:47pm UTC](https://community.striven.com/t/inactive-inventory/707/1 "2025-01-31T15:47:26Z")

</div>

Has anyone created a report that shows you your inactive or slow moving inventory? I can’t seem to find a way even using the new report builder to see inventory on hand that has zero usage or sales or even slow moving. I would like to see what is dead, inactive or slow moving inventory. I would like to view movement for a certain time period, etc.

---

<div class="post-metadata">

**Author:** ![Naveen](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.striven.com/naveen/32/899_2.png) [@Naveen](https://community.striven.com/u/Naveen)\
**Post date:** [February 1, 2025, 8:05pm UTC](https://community.striven.com/t/inactive-inventory/707/2 "2025-02-01T20:05:26Z")

</div>

Greetings Jared,

I have created a task for this request and will generate a report based on the Inventory dataset with the necessary filters for item status, sales, and time period as per your requirements. I will send you the resolution along with screenshots once the report is ready.

Let me know if you have any questions in the meantime! 😊

Best regards,  
Naveen Kumar

---

<div class="post-metadata">

**Author:** ![AshleyCrest](https://avatars.discourse-cdn.com/v4/letter/a/13edae/32.png) [@AshleyCrest](https://community.striven.com/u/AshleyCrest)\
**Post date:** [February 1, 2025, 10:41pm UTC](https://community.striven.com/t/inactive-inventory/707/3 "2025-02-01T22:41:21Z")

</div>

I would try using a transaction detail report. This would be on Invoices and Sales Receipts and can show you history.

---

<div class="post-metadata">

**Author:** ![jaredmorland](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@jaredmorland](https://community.striven.com/u/jaredmorland)\
**Post date:** [February 3, 2025, 4:53pm UTC](https://community.striven.com/t/inactive-inventory/707/4 "2025-02-03T16:53:06Z")

</div>

Thank you @Naveen and @AshleyCrest. To be a little more specific. We have five locations in five different cities, all with their own inventory on hand. Combined we have approx. $2.5M of physical inventory on hand. I would like to see a list of the items on hand for our Lubbock location and for each item see what how many of each item were sold for a specific time period (last year) and the date of the last time sold.

---

<div class="post-metadata">

**Author:** ![AshleyCrest](https://avatars.discourse-cdn.com/v4/letter/a/13edae/32.png) [@AshleyCrest](https://community.striven.com/u/AshleyCrest)\
**Post date:** [February 3, 2025, 5:25pm UTC](https://community.striven.com/t/inactive-inventory/707/5 "2025-02-03T17:25:14Z")

</div>

Here is an example of what I am talking about

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/striven/original/2X/9/94c9f91c54588928fe191d30e2f3a5efa756e115.png)

It doesn’t show quantity on hand, but does show you how many sold per site and you can get as granular as you need. I would assume you could add the bills to this and run an API with a Pivot table that could get you the info you need now. I haven’t recreated this in the new Beta so Idn if it gives more fields to filter and would plus and minus for bills very sales. I think your idea is great and would love to see Striven create this report for you. But since that takes time I was offering a work around that could get the job done sort of.

---

<div class="post-metadata">

**Author:** ![jaredmorland](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@jaredmorland](https://community.striven.com/u/jaredmorland)\
**Post date:** [February 3, 2025, 5:49pm UTC](https://community.striven.com/t/inactive-inventory/707/6 "2025-02-03T17:49:38Z")

</div>

Okay…I will dig into this using the new Beta and see if there is more data available. If not, I will use API and a Pivot Table. Thank you for your feedback and help

---

<div class="post-metadata">

**Author:** ![Ailerons](https://avatars.discourse-cdn.com/v4/letter/a/f08c70/32.png) [@Ailerons](https://community.striven.com/u/Ailerons)\
**Post date:** [February 6, 2025, 8:16pm UTC](https://community.striven.com/t/inactive-inventory/707/7 "2025-02-06T20:16:47Z")

</div>

Following. I can see my company being interested in this. Thanks @AshleyCrest for the workaround in the meantime!
