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
Best answer by aryanjadhav50
Hi
In Acumatica, the Dead Stock report does not use a single configurable “comparison date.” Instead, it evaluates inventory based on the criteria defined in the report parameters and underlying inventory transaction history.
Here is how it works:
What date is being used
Dead stock is generally determined by comparing the item’s last movement date (last issue, receipt, or other inventory transaction) against the “Number of Days” parameter entered when running the report.
If you leave the Days field blank, the system typically evaluates based on zero movement within the default logic of the report, which can cause items with no recent activity to appear.
Where the movement date comes from
The comparison is usually based on:
– Last Inventory Transaction Date
– Last Issue Date
– Last Receipt Date
– Or last activity affecting on-hand quantity
These dates are stored in inventory history tables and calculated per warehouse when you filter by warehouse.
How to confirm what date is used
To verify the exact logic in your environment:
– Open the report in Report Designer
– Review the Data Source and the formula/conditions used
– Look for filters referencing LastTranDate, LastIssueDate, or similar fields
If this is a Generic Inquiry–based report, review the Conditions tab to see the date comparison logic.
Can you change the comparison date?
There is no global system setting that changes the “dead stock date.”
You must either:
– Enter a specific number of Days when running the report, or
– Customize the report to use a different date field or logic
+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.
Hi
In Acumatica, the Dead Stock report does not use a single configurable “comparison date.” Instead, it evaluates inventory based on the criteria defined in the report parameters and underlying inventory transaction history.
Here is how it works:
What date is being used
Dead stock is generally determined by comparing the item’s last movement date (last issue, receipt, or other inventory transaction) against the “Number of Days” parameter entered when running the report.
If you leave the Days field blank, the system typically evaluates based on zero movement within the default logic of the report, which can cause items with no recent activity to appear.
Where the movement date comes from
The comparison is usually based on:
– Last Inventory Transaction Date
– Last Issue Date
– Last Receipt Date
– Or last activity affecting on-hand quantity
These dates are stored in inventory history tables and calculated per warehouse when you filter by warehouse.
How to confirm what date is used
To verify the exact logic in your environment:
– Open the report in Report Designer
– Review the Data Source and the formula/conditions used
– Look for filters referencing LastTranDate, LastIssueDate, or similar fields
If this is a Generic Inquiry–based report, review the Conditions tab to see the date comparison logic.
Can you change the comparison date?
There is no global system setting that changes the “dead stock date.”
You must either:
– Enter a specific number of Days when running the report, or
– Customize the report to use a different date field or logic
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
