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:

1. 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).
2. 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.
3. 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.
4. 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.
5. 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?