Hi all,
Does anyone know how to change / update the date that Acumatica uses to calculate the dead stock? As it stands, i can run a dead stock report - not selecting any days - by warehouse and items show up.
I want to see what the date that Acumatica is comparing the items against to determine dead stock.
*Note: I did do a search on the community and didn’t see an answer to this. :)
Thanks!
Joseph
+6
In Acumatica ERP, dead stock generally refers to inventory items that have not moved (no sales, issues, or transfers) for a defined period — often 6–12 months or more.
Acumatica doesn’t have a single “Dead Stock” button, but you can calculate it using Generic Inquiries (GI) or Inventory Turnover reports.
The common formula is:
[ \text{Dead Stock %} = \frac{\text{Value of Dead Stock}}{\text{Total Inventory Value}} \times 100 ]
Where:
QtyOnHand × UnitCost for items with Last Sale Date or Last Issue Date older than your threshold.QtyOnHand × UnitCost for all items.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.