- All products
- Stock Valuation Avco Recalc
- All products
Average Cost (AVCO) Recalculation
Retroactive cost adjustments, finally easy. Correct past valuation errors with mathematical precision. Our Waterfall engine rebuilds your history automatically.
The Historical Reconstruction Engine
The Problem: Disconnected Costs
Odoo lets you edit past moves (purchases or adjustments), but it does not automatically update the cost of subsequent outgoing moves. This creates serious inconsistencies in your inventory value and cost of goods sold (COGS).
The Solution: Cascade Effect
Our module calculates the exact stock state on a past date and "re-runs" every transaction sequentially. It propagates the correct Average Cost from the root to the present, eliminating any discrepancy.
Execution Guide
Correct your valuation in just 3 steps:
- 1. Move Selection: Go to Inventory > Reporting > Moves Analysis and filter the product you want.
- 2. Recalculation Action: Select the records and click Action > Recalculate AVCO Valuation.
- 3. Confirmation (God Mode): Check the calculated opening balance. If your history is very complex, you can manually edit the initial quantity and value in the wizard to force a new "point of truth".
Odoo 19 Technology
Compatible with the new Odoo 19 architecture, including JSONB storage for standard prices and company-dependent fields.
Validation Scenarios (QA)
| Test Scenario | Resultado Esperado | Validation |
|---|---|---|
| Compra Retroactiva | When a purchase with a past date and higher cost is inserted, subsequent deliveries must update their value automatically after the recalculation. | |
| FIFO Safety Lock | The system must raise a UserError if you try to run the recalculation on a product that does not use the AVCO method. | |
| Returns Correction | If a delivery is corrected from $10 to $12, its linked return must update automatically to keep parity. | |
| Audit Log | Each run must generate a record with the user, total corrected amount and number of affected moves for accounting purposes. |
Preguntas Frecuentes
Does it modify my journal entries?
No. It strictly updates the value and unit price in stock.move. Your already posted entries remain untouched; you will need to post a manual entry for the difference if your accountant requires it.
How does it handle different UoMs?
The algorithm automatically converts all quantities to the product's base Unit of Measure before calculating, ensuring full mathematical accuracy.
WhatsApp Sales
CHAT +1 828 672 6150Servicios ERP
EMAIL leads@ganemo.comTechnical Support & Accounting Audit
Do you need to make a mass correction due to a fiscal year change, or require help validating your inventory balance? Our technical team is here to help you keep your data intact.
ayuda@ganemo.comAverage Cost (AVCO) Recalculation
Retroactive cost adjustments, finally easy. Correct past valuation errors with mathematical precision. Our Waterfall engine rebuilds your history automatically.
The Historical Reconstruction Engine
The Problem: Disconnected Costs
Odoo lets you edit past moves (purchases or adjustments), but it does not automatically update the cost of subsequent outgoing moves. This creates serious inconsistencies in your inventory value and cost of goods sold (COGS).
The Solution: Cascade Effect
Our module calculates the exact stock state on a past date and "re-runs" every transaction sequentially. It propagates the correct Average Cost from the root to the present, eliminating any discrepancy.
Execution Guide
Correct your valuation in just 3 steps:
- 1. Move Selection: Go to Inventory > Reporting > Moves Analysis and filter the product you want.
- 2. Recalculation Action: Select the records and click Action > Recalculate AVCO Valuation.
- 3. Confirmation (God Mode): Check the calculated opening balance. If your history is very complex, you can manually edit the initial quantity and value in the wizard to force a new "point of truth".
Odoo 19 Technology
Compatible with the new Odoo 19 architecture, including JSONB storage for standard prices and company-dependent fields.
Validation Scenarios (QA)
| Test Scenario | Resultado Esperado | Validation |
|---|---|---|
| Compra Retroactiva | When a purchase with a past date and higher cost is inserted, subsequent deliveries must update their value automatically after the recalculation. | |
| FIFO Safety Lock | The system must raise a UserError if you try to run the recalculation on a product that does not use the AVCO method. | |
| Returns Correction | If a delivery is corrected from $10 to $12, its linked return must update automatically to keep parity. | |
| Audit Log | Each run must generate a record with the user, total corrected amount and number of affected moves for accounting purposes. |
Preguntas Frecuentes
Does it modify my journal entries?
No. It strictly updates the value and unit price in stock.move. Your already posted entries remain untouched; you will need to post a manual entry for the difference if your accountant requires it.
How does it handle different UoMs?
The algorithm automatically converts all quantities to the product's base Unit of Measure before calculating, ensuring full mathematical accuracy.
WhatsApp Sales
CHAT +1 828 672 6150Servicios ERP
EMAIL leads@ganemo.comTechnical Support & Accounting Audit
Do you need to make a mass correction due to a fiscal year change, or require help validating your inventory balance? Our technical team is here to help you keep your data intact.
ayuda@ganemo.comSpecifications
| Version | 19.0 |