Hello Everyone,
In the Stock Item screen [cst.in.20.25.00], under actions, there is an ‘update cost’ button but when i click it, nothing happens...is this button really working?
Kind regards,
Melq
Userlevel 7
+17
Hi
I have checked the OOTB code for this action, this will update the values, when we have On-Hand Qty for the stock item but NOT showing any cost details.
Below the source code from OOTB from InventoryItemMaint
Hello Naveen B,
Thanks for this...could you change price to 3 and let us see if the average changes? thank you
mrivera67
Userlevel 7
+17
Average Cost will change, when we create the Purchase Receipt and RELEASE from Purchase Order.
For an instance, I have created a purchase order for this item with a unit cost of 30,000, then Average Cost is changed to 13.25. Please find the screenshot for reference.
Hello Naveen B,
Thank you for your reply!
If it REALLY updates the last cost price [in the screen cst.in20.25.00], when we click the ‘UPDATE COST’ button under the action button, then it should change the average cost already at this point, right? but this does not change anything that is why I am asking if it really works? If it REALLY works, then there should be no need to go to the Purchase Receipt and Release method of updating the cost,
Kind regards,
mrivera67
Userlevel 7
+17
Hi
The “Update Cost” will works, when the Stock Item is having a Valuation Method as “Standard” and will update only “Cost Statistics” fields.
When the Stock Item is having “Qty On Hand” is zero then only we can update the “Standard Cost” fields, by entering the value in the “Pending Cost” field otherwise will get the error like shown in the screenshot.
Hope this helps!!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.