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
+2
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?
+6You 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
+2Thank 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!
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
