Hi all,
We are a UK based business who is currently facing an issue in our Odoo 17 instance involving a negative stock and valuation discrepancy for one of our products: Product A. Here's a breakdown of the problem:
- Background:
- We have identified that 24-10-2024, an inventory adjustment of -1814 units with a value of -£6759.74 was made for the product.
- This adjustment caused the cumulative stock to turn negative in the Stock Valuation Layer and resulted in a mismatch between the Inventory Module (showing positive stock of which as at today is at 1511 units) and the Balance Sheet Report in the Accounting Module (showing a negative valuation of -£1379.46).
- Steps Taken So Far:
- When I attempted to revert the inventory adjustment in our staging environment by creating a reversal of +1814 units with a value of +£6759.74.
- While this corrected the Valuation Report and the Balance Sheet, it caused a new issue:
- The Stock Report and Locations Report now show more than 3300 units of the product instead of the correct quantity of 1511 units.
- Current Issues:
- The Inventory Module stock levels are correct but when the reversal of the inventory adjustment is made it's overstated.
- The Stock Valuation Layer and Balance Sheet reports appear to be incorrect and upon reversal get corrected, but the quantity discrepancies above persist.
- Additional Information:
- The issue seems to stem from how the original adjustment and its reversal are treated across the Stock Valuation Layer and Inventory Reports.
- Questions:
- How can I revert the inventory adjustment in a way that:
- Corrects the Stock Valuation Layer.
- Ensures accurate stock levels in the Inventory Module and Stock Reports.
- Maintains proper alignment between the Inventory Module and Accounting Module.
- Is there a known issue in Odoo 17 that could explain this behaviour, or is this a configuration error?
- How can I revert the inventory adjustment in a way that: