One of our users mistakenly set an incorrect cost for a raw material product. This mistake affected both the valuation of raw materials and the valuation of finished goods produced using that raw material.
We corrected the raw material product cost and re-added the raw material, which successfully updated the raw material valuation. However, the finished goods valuation is still showing the old (incorrect) value based on the previous cost, and it has not updated accordingly.
Additional Details:
- Odoo 14 community
- The Manufacturing Order is in Done state.
- We are using FIFO and Automated Inventory Valuation.
Question:
How can we correct the valuation of the finished goods in this scenario without causing inconsistencies in stock and accounting?
Any best practices or suggestions would be appreciated.