Solved

Update Average Cost for Stock Items

  • 5 April 2024
  • 6 replies
  • 134 views
J
Rank
Userlevel 3
Badge

I am trying to update the average cost for stock items that were migrated into Acumatica without an average cost.  To do this, I did a quantity adjustment with Ext Cost what I want the average cost to be and the quantity zero.  I am getting the following error.

 

 

 

 

I tried doing this again with a quantity of 1 which worked, but then when I did the adjustment for a quantity of -1 to make our actualy on hand inventory accurate the average cost went back to zero.

 

How do I update the average cost for a stock item without changing the quantity on hand?

icon

Best answer by andrestamour43 13 June 2024, 16:31

View original

6 replies

Laura02
Rank
Badge +18

Hello, 

I don’t see an error above. Can you type in the text of your error or paste a screen shot?

I think the items must be adjusted out at their current cost of $0 and then received in with their correct average cost (with inventory migration mode on - Update GL not checked in IN Preferences).

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ AUG Forums Episode130 ~
J
Rank
Userlevel 3
Badge

Here is a screenshot.

Manikanta Dhulipudi
Rank
Userlevel 7
Badge +12

Hi 

The corrective action would be to change the Cost on the document to some amount equal to (or below) the overall Inventory cost.

Please check the cost in the Inventory valuation report of the particular item.

I found this is a Known issue AC-245370 caused by negative quantity in Return order types.

Please create a case with your VAR/ Acumatica

Acumatica Functional Consultant
J
Rank
Userlevel 3
Badge

The cost is zero.  The problem is I cannot add a receipt with only a cost and not a quantity.

Chris Hackett
Rank
Userlevel 7
Badge

Hi @josborn were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
A
Rank
Userlevel 5
Badge +3

@josborn - a receipt with a cost and no quantity would leave a value on the shelf with no goods to back the value.

The Average Cost statistic on the stock item is displaying the average cost of the inventory currently on hand. If you have 0 inventory on hand the average cost will be zero.

Example of item with 0 on hand inventory


For future adjustments/ receipts when the average cost is 0.00, then the system will use the last cost. You can manually update the last cost without having to do an adjustment. 

 

Andre St. Amour

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved