Skip to main content

hello everyone!

 

can someone show me how to update unit cost manually for an inventory item?

 

thanks in advance,

mrivera67

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


Hello @mrivera67,

 

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.

 


@Naveen B Doing a receipt will also add qty on hand to the inventory which might not be the route to go if only unit cost needs to be updated.


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

 

 

 

 

 

 


@mrivera67

I concur with @balakrishnak12.

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 @mrivera67 

As mentioned on previous post, 

  • if the valuation method of the item is ‘Standard cost’, then, only the ‘Pending standard cost’ column is available for edit
  • For all other valuation methods, only the ‘Last cost’ column will be active on the ‘Price/Cost info’ tab and available for editing.

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


Hi @mrivera67 

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


Hi @mrivera67 

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


Thanks a lot for verifying and confirming this.


Hi Naveen

Please advise, if the item is active and costing is average, when I assemble the item (Kitting item) is has a cost value in that location because that is where it was receipted into from Vendor purchases. However when i transfer that kit item into another location from where it will be sold the cost value no is Zero. This happens even when I assemble the kit in the second location


Reply