Skip to Content
Menu
This question has been flagged
1 Reply
2142 Views

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?

Avatar
Discard
Author Best Answer

Managed to find a resolution with the use of Open AI. If you are having similar problems and you have Odoo.sh please try problem solve your issue with chatgpt and you will be surprised with the result. Ensure that you initially test proposed solutions in your staging environment and only when you are satisfied and you have verified that the stock valuation layer, stock report, balance sheet and accounting journal are all aligned should you then proceed to implement it in production. 

Avatar
Discard
Related Posts Replies Views Activity
1
Oct 24
1770
3
Jan 24
767
2
Dec 24
37980
0
Oct 17
3208
2
Aug 25
109