Dead Stock Inquiry

  • 24 March 2021
  • 6 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.


6 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.  





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