Dead Stock Inquiry

  • 24 March 2021
  • 5 replies

Userlevel 4
Badge +1

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


Here’s a quick video.


5 replies

Userlevel 4
Badge +1

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 4
Badge +2

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 5
Badge +1

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 4
Badge +2

@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?)




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 — 2022  Acumatica, Inc. All rights reserved