Skip to main content
Solved

Total Dead Stock Cost VS Inventory Valuation


Why is the total Dead Stock Cost in the dead stock screen different from the total cost in the inventory valuation & Inventory Summary.

I have a item that shows the same QTY ON HAND in the Dead stock, Inventory Summary, Inventory Valuation but the DEAD STOCK COST is 47K but the Inventory Summary & Inventory Valuation the total cost is 14K

why is the Dead Stock qty calculating 47K ? How did it get that number 

Does the dead stock do some sort of Inventory Holding calculation?

 

 

Best answer by olgakonanykhina22

Hello, basically the total dead stock cost is using item layers and the cost amounts from the layers.

Total Dead Stock Cost = ∑(Qi * UCi) where Qi - Dead Stock quantity in cost layer i, UCi - Dead Stock unit cost in cost layer i, i - cost layer ϵ {Dead Stock}

Average Dead Stock Item Cost = Total Dead Stock Cost/Dead Stock Qty

 

Besides, there were several known issues related with Total Dead Stock Cost, you can check it on the Known issues section on the partner portal.

View original
Did this topic help you find an answer to your question?

3 replies

Hello, basically the total dead stock cost is using item layers and the cost amounts from the layers.

Total Dead Stock Cost = ∑(Qi * UCi) where Qi - Dead Stock quantity in cost layer i, UCi - Dead Stock unit cost in cost layer i, i - cost layer ϵ {Dead Stock}

Average Dead Stock Item Cost = Total Dead Stock Cost/Dead Stock Qty

 

Besides, there were several known issues related with Total Dead Stock Cost, you can check it on the Known issues section on the partner portal.


Forum|alt.badge.img
  • Jr Varsity III
  • 15 replies
  • June 3, 2024

@olgakonanykhina22, can you post the known issues to the Community as well? The inventory team at my company uses the Dead Stock GI to help inform inventory decisions. If it is broken in some way, I would like to be able tell them what to look out for. 


There were a couple known issues on the 22R1/R2 which are retired now, and you can review it on the following link: https://portal.acumatica.com/(W(4))/Help?ScreenId=KI2022R1&PageID=f4c70ae8-17e1-4e49-867b-f26ab674608b

And there was a bug in 23R110 and fixed in the initial release of 23R2, here is its description:

AC-282452: If the negative quantity and cost adjustment was performed for an average-costed item on the Adjustments (IN303000) form, the Total Dead Stock Cost and Dead Stock Item Average Cost amounts were calculated incorrectly on the Dead Stock (IN405500) form for this item


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings