Odoo 19 Backdated Inventory in AVCO Perpetual – Shocking Valuation Changes Explained! | Is it a BUG?

Описание: How does Backdated Inventory really work in Odoo 19 when using AVCO (Average Cost) with Perpetual Valuation?

In this practical deep-dive tutorial, we test real-time accounting behavior with backdated Purchase Orders, unlocked receipts, and Sales Orders — and analyze why COGS and Stock Valuation Reports show different values!

If you're an Odoo Functional Consultant, Accountant, or ERP Implementer, this video will clarify whether this is a system bug or normal AVCO behavior.

🔎 Case 1 Explained:
✔️ Purchase Order created on 23 Feb 2026 – Received & Billed
✔️ Another PO backdated to 10 Feb – Received & Billed
✔️ Receipt date changed from 23 Feb to 10 Feb (after unlock)
✔️ Sales Order created, delivered & invoiced

👉 Result:
Odoo calculates COGS correctly based on product valuation
But Stock Valuation Report shows a different value
Why does this mismatch happen in AVCO?
We break down the accounting layer logic step-by-step.

🔎 Case 2 Explained:
✔️ New Product created with Cost = ₹10
✔️ PO created at ₹15 – Received & Billed
✔️ Stock valuation updated correctly
✔️ Sales Order delivered & invoiced (COGS calculated using AVCO)

Now the twist:
✔️ Another PO backdated to 10 Feb
✔️ Received, Billed & Receipt date modified

👉 Result:
Inventory valuation account updated correctly
BUT Product master cost resets to ₹10
Stock valuation report shows different unit value
Is this a bug in Odoo 19? Or expected AVCO recalculation behavior?

We analyze:
AVCO recalculation logic
Accounting move generation
Inventory valuation layer impact
Backdated stock move consequences

Advantages of Backdated Inventory in Odoo 19
✔️ Accurate historical stock correction
✔️ Proper financial period adjustment
✔️ Correct AVCO recalculation for past entries
✔️ Useful for late vendor bills and delayed GRNs
✔️ Maintains audit trail with perpetual valuation

Limitations & Risks
❌ Can change historical average cost unexpectedly
❌ May create mismatch between product cost & valuation report
❌ Impacts COGS for already delivered products
❌ Risky if accounting periods are already closed
❌ Requires strict date control policy

Important Conclusion
In AVCO with Perpetual valuation:
Odoo recalculates average cost based on chronological stock moves.
When you backdate receipts, the system reorders valuation layers.
Product cost field may not always reflect historical recalculations instantly.
Stock Valuation Report depends on valuation layers, not just product cost.

This is generally normal AVCO behavior, not a bug — but must be handled carefully in live environments.

Perfect for:
Odoo Functional Consultants
ERP Implementers
Accountants
Finance Controllers
Odoo Partners

#Odoo19 #OdooInventory #AVCO #PerpetualInventory #StockValuation #OdooAccounting #ERPImplementation #OdooFunctional #InventoryManagement #COGS #OdooTutorial