We fairly recently went live.
Our items use the "weight average" costing method.
One of the items was brought in during data migration with incorrect value. (say, $5 per unit instead of $60 per unit)
I cannot adjust the original inventory transaction of counting in, since that fiscal year is already closed.
How can I fix the inventory value?
I tried counting out the full quantity, and then using inventory adjustment journal to "count in" the item using the correct value, however when I close inventory the system will re-calculate the cost based on the weighted average of the cost before these 2 adjustment.
So what is the best practice to fix the inventory value of one item (or several items?)