Hi Acumatica Community,
We’re running into a costing behavior that doesn’t match our expectation of how Average Costing should work, and I’d like to understand how to address it properly.
Scenario:
We’re using Average as the costing method on our stock items.
-
We received 5 units on a PO at $9.50 per unit.
-
A Landed Cost was posted afterward for $9.00 per unit, bringing the total unit cost for those 5 units to $18.50.
-
We then received 10 more units at $9.00 each, with no landed cost.
-
The overall average cost at this point should be:
((5 × 18.5) + (10 × 9.00)) ÷ 15 = $11.67
However, when we ship the first 5 units, Acumatica still uses the $18.50 unit cost instead of pulling the average cost of $11.67.
My Question:
-
How can we get Acumatica to always use the actual average cost (e.g., $11.67), not the inflated cost from the landed cost layer?
-
Is there a configuration we’re missing?
-
Do we need to perform a Cost Revaluation after each landed cost?
-
Is this behavior expected even when Average costing is selected?
Would appreciate any guidance on how to achieve consistent average costing behavior in scenarios like this.
Thanks in advance!
