Skip to main content
Solved

Cannot change cost on standard cost item when it has an inventory QTY


Forum|alt.badge.img+6

Would like to change the standard cost on a stock item, but we get the following error if there is a quantity in inventory.  I believe there is no away around this other than to adjust out inventory, make the change, then adjust it back in.  “IN Error: There is non zero Quantity on Hand for this item. You can only change Cost when the Qty on Hand is equal to zero”

 

Is this correct?

Best answer by dgodsill97

You have to update the Pending Cost, either manually or using the BOM Cost Roll. Then run the Standard Cost Preview Report to make sure your Standard Cost Adjustment won’t set your CFO;s hair on fire. Then run Update Standard Cost process which will revalue the inventory and create a standard cost adjustment transaction.

 

https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=29dd17ca-5a7d-4ec8-864f-4f8d8916efb1

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

9 replies

Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • 466 replies
  • June 10, 2024

@ltussing03 is this a purchased item or a Manufactured item?


Forum|alt.badge.img+6
  • Author
  • Captain II
  • 279 replies
  • June 10, 2024

purchased

valuation method standard


Forum|alt.badge.img+6
  • Author
  • Captain II
  • 279 replies
  • June 11, 2024

@Debbie Baldwin any thoughts on this?  Can we really not change standard costs on stock items if they have inventory QTYs?


claudematherne24
Jr Varsity III
Forum|alt.badge.img

I’ve only ever seen this issue when changes the UoM, not cost.  We use Standard Valuation, and can adjust costs.  To make sure, you are going to the Pending Cost, then trying to Update Pending Costs?

 


Forum|alt.badge.img+3
  • Varsity I
  • 205 replies
  • Answer
  • June 11, 2024

You have to update the Pending Cost, either manually or using the BOM Cost Roll. Then run the Standard Cost Preview Report to make sure your Standard Cost Adjustment won’t set your CFO;s hair on fire. Then run Update Standard Cost process which will revalue the inventory and create a standard cost adjustment transaction.

 

https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=29dd17ca-5a7d-4ec8-864f-4f8d8916efb1


Forum|alt.badge.img+6
  • Author
  • Captain II
  • 279 replies
  • June 11, 2024

I get the error on the stock item screen.

 


Debbie Baldwin
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • 466 replies
  • June 11, 2024

@ltussing03 - it’s only going to work using Dennis’s suggestions above. 


Forum|alt.badge.img+6
  • Author
  • Captain II
  • 279 replies
  • June 11, 2024

Thank you.  I read through it but misunderstood to just update the pending cost without trying to “update costs” from the stock item screen.

 

Thanks Dennis!

Thanks for helping Debbie!


Forum|alt.badge.img
  • Jr Varsity II
  • 21 replies
  • August 5, 2024

Btw this is the exact reason for the screen ID IN502000 “Update Standard Costs” in the Inventory workspace.  Its odd as you need to set the Pending Date and cost on either the Stock Item screen or the Item Warehouse Details screen first then use this screen to do the actual update process.  It will then create the inventory adjustment that records the value change.


Reply


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