Dead Stock Inquiry

  • 24 March 2021
  • 9 replies

Userlevel 4
Badge +2

Very Cool new surprise for 2021 R1.  Dead Stock inquiry screen lets you see non moving inventory.


Here’s a quick video.


9 replies

Userlevel 6

Great new feature.  Thank you.

How this inquiry calculate the Dead Stock? I got an item that has 3 dead stock qty and the cost is being duplicated and the total cost triplicated. 

It only happens in a few items. 



Userlevel 5
Badge +1

It would be nice if you could run this across multiple warehouses. Overall, it is very helpful, but for distributors who are looking at multiple warehouses, they don’t want to run it for every one.

Userlevel 7
Badge +2

Hello @jeremyd45 ,

The warehouse field is currently a required field since the Dead Stock inquiry can be run wide open for all inventoried items.  Having required fields is a way to improve performance and reduce the search results displayed.  Imagine if the warehouse field wasn’t required and the inquiry was run wide open (without specifying any search criteria)  - the inquiry would be asking to see every single item in the system as well as perform calculations to calculate the dead stock quantity. 

If we were to consider opening up warehouse, i think we would think about perhaps making Inventory ID a required field, or something like that so that performance would not be adversely impacted.

What are your thoughts?




Userlevel 5
Badge +1

@Dana Moffat I think that there could be a way that maybe you force people to somehow select the warehouses? That way you would be fully aware that they are running multiple warehouses?  Limiting by item could create more issues in the opposite direction (who wants to run 10000 reports per item?)



Userlevel 4
Badge +1

Is there a way to reproduce this report as a generic inquiry so that it can be easily modified or added to? 


Currently it appears that this report considers items “dead stock” even if the item is being used regularly in production, which we would not consider dead stock. It would be great if the wiki could be updated to provide better clarity on how some of these values are being calculated


Dead Stock Qty. - The quantity of stock items calculated as a dead stock.” I don’t believe you should use the term being defined as part of the definition and is very unhelpful for anyone who doesn’t already understand what this means… 


I would love to include production usage (totals issued in manufacturing), site summary data (Qty avail, Qty on PO, on SO etc), as well as some pricing info or the ability to calculate values here.  




Userlevel 5
Badge +1

@Dana Moffat is there any thought about adding item class and possibly primary vendor to this dead stock report?  given that you can’t modify it, and you can’t see the item class when you get results, it seems silly that you have a filter for the item class. It seems like this would be a very easy change for Acumatica to get pushed out. 

Userlevel 7
Badge +2

Hi @jeremyd45 

We have made improvements to this report based on Acumatica Community feedback.  A community member had suggested adding Last Purchase Date to the results.

So here, the need you’re highlighting, is to be able to compare across different Item Classes, the dead stock?  

Showing the preferred vendor, what business value/problem would that solve for you?

P.S.  We also have the Inventory Turnover inquiry, which can provide additional insights too.




Userlevel 5
Badge +1

@Dana Moffat the item class seems like a no brainer, because if you already have it as a filter criteria but it doesn’t show you this information in the display.  if you are using subclass and you want to look at everything, you do not have the option of filtering by contains XXX- or anything like that. Showing the item class field in the details would allow for this. The preferred vendor or last vendor could provide some insight if you are making vendor criteria selections but not as necessary.


As a note, the inventory turnover inquiry also doesn’t have the item class on the details but it is on the header filter information as well. 



About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved