hello everyone!
can someone show me how to update unit cost manually for an inventory item?
thanks in advance,
mrivera67
Best answer by Naveen B
Hello
To change the Unit Cost of an item, you can create the Inventory Receipt with with new “Unit Cost”, accordingly it will update the Unit Cost. Please find the screenshot for reference.
Below links will help you to understand and update the unit cost.
https://www.augforums.com/forums/acumatica-distribution-modules/default-purchase-order-unit-cost-last-vendor-price-stock-items/
https://help-2019r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=4aa635bc-2723-49fc-8ce0-41d035e5821e
+1
Hello
To change the Unit Cost of an item, you can create the Inventory Receipt with with new “Unit Cost”, accordingly it will update the Unit Cost. Please find the screenshot for reference.
Thanks Naveen B!
Hello,
If Valuation Method is “Standard”, then you can enter desired Unit Cost in Price tab. After adding the Cost and date, please perform Update Cost from Actions menu
+1
I concur with
When we change the “Valuation Method” as Standard then the “Standard Cost” section will be enabled under the “Price/Cost Info” tab and we can able to provide the values. (it will not enable for other methods).
After providing the values and click on the “Update” Action, then it will update the “Standard Cost” fields only. but not the “Cost Statistics” fields.
Just FYI, For the existing stock items, we can not change the “Valuation Method”, until the Stock Item Qty On Hand is Zero.
Below code from OOTB, for the Update Cost action for your reference.
Hi
As mentioned on previous post,
One can manually update this if it's for individual items, else, one can use an ‘Import scenario’ to update multiple records in bulk.
Hope this helps,
Regards,
Hello Everyone,
So I did an inventory receipt to update the unit cost as I have the ‘AVERAGE’ valuation enabled, but when I check the stock item...the cost is not update at all...I am using 2020 R1, I don’t understand why it is not updating the unit cost...am I not doing something right? Could someone please try this on their test environment? Many thanks.
Kind rgards,
mrivera67
+1
Hi
Have you provided new Unit cost in Inventory Receipt. ?
Hi Naveen B,
Yes, I did and I released the inventory receipt...there were several items on the receipt and none of them were updated...and I did several receipts too just to confirm, and none of the inventory receipts that I created and released updated any of the unit cost.
Kind regards,
mrivera67
+1
Hi
I did a small test in my test environment. Please check the attached video recording in zip format for your reference.
Thanks for this Naveen B, this means that there is something wrong with my system.
Kind regards,
mrivera67
+1
Thanks a lot for verifying and confirming this.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
