| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 363 |
| Technical Name |
stock_valuation_avco_recalc |
| License | OPL-1 |
| Website | https://www.ganemo.co |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Discuss (mail) |
| Lines of code | 363 |
| Technical Name |
stock_valuation_avco_recalc |
| License | OPL-1 |
| Website | https://www.ganemo.co |
Stock Valuation
Average Cost (AVCO) Recalculation
Retroactive Cost Adjustments, finally made easy. Fix valuation errors from the past with mathematical precision. Our Waterfall Engine rebuilds your history automatically, saving you hours of manual spreadsheet work.
What We're Solving
----------------
Broken Combinations
Odoo allows editing past incoming moves (like purchases or inventory adjustments), but it does not automatically update the cost of subsequent outgoing deliveries. This leaves your valuation strictly inconsistent.
The Waterfall Solution
Our module calculates the exact stock state at a specific past date and re-plays every single transaction sequentially. It propagates the correct Average Cost from the past to the present, fixing all discrepancies.
Setup & User Manual
Step-by-Step implementation
Prerequisites
- User must belong to the Inventory / Administrator group to access the Recalculation menu.
- The target product(s) must use the Average Cost (AVCO) costing method.
1. How to Execute
Fix your product valuation in 3 steps:
- Go to Inventory > Reporting > Moves Analysis.
- Filter via Product.
- Select the moves showing incorrect values (or all moves for that product).
- Click Action (Gear) > Recalculate AVCO Valuation.
- Verify the Initial Balance in the Wizard.
- Click Confirm & Execute.
2. Key Features
Built for reliability:
Smart Start Date
You don't need to guess the date. The system automatically detects the oldest moving part of your inventory history to ensure a complete fix from the root cause.
Silent SQL Update
We use a proprietary Recursion Bypass technique to update costs without triggering Odoo's native revaluation chaos. Your corrected history stays corrected.
Odoo 19 Certified
Fully compatible with Odoo 19's new architecture, including native JSONB storage for standard prices and company-dependent fields.
Multi-Currency Support
The algorithm respects company currency and unit price conversions automatically.
Global Ready | Multi-Language Support
This module is fully translated into English and Spanish (en_US, es_ES, es_PE, es_MX), ensuring a professional experience for international organizations.
Why Choose Ganemo?
----------------
Ganemo is the world's leading Odoo App developer and a multi-award-winning Gold Partner. For over 5 years, we have been recognized as the #1 seller of high-quality apps on the Odoo App Store. Trusted as the "Best Partner" in USA, Mexico, Chile, Spain, Colombia, Ecuador, and Peru, we deliver robust, secure, and localization-compliant solutions for global businesses.
Get a Quote & Resolve Commercial Doubts
Join thousands of satisfied clients on Odoo. Contact our sales team directly.
Official WhatsApp
Fastest response time.
LINK
+1 (828) 672-6150
Book a Demo
Let's explore your needs.
LINK
Schedule Meeting
Need More? We Do It All
Professional Odoo Services
ERP Implementation
Transform your business with a full Odoo implementation. We analyze, configure, and train your team to maximize productivity. From Accounting to Inventory, we handle the complexity so you can focus on growth.
Module Dev & Migration
Need a custom feature? Or stuck on an older version? We develop high-performance custom modules and migrate your existing code to Odoo 19 with zero data loss. Expert developers at your service.
QA / User Testing Scenarios
Enterprise Validation Plan
Scenario 1: Backdated Purchase Recalculation
- Create a Product with AVCO costing.
- Process a Purchase for 10 units @ $10 (Day 1).
- Process a Delivery for 5 units (Day 3). Checks cost is $10.
- Retrospectively Purchase 10 units @ $20 dated Day 2.
- Notice the Delivery on Day 3 is still $10.
- Run Recalculate AVCO Valuation.
- Verify: Day 3 Delivery cost is updated to $15.
Scenario 2: Safety Block
- Select a Product with FIFO method.
- Click Recalculate AVCO Valuation.
- Result: System raises a UserError blocking the operation.
Scenario 3: Audit Log Traceability
- Execute a recalculation for any product.
- Go to the generated Audit Log record.
- Verify: The log contains the User, Date, Total Correction Amt, and Count of moves affected.
- This ensures you have proof of who changed the valuation and when.
Scenario 4: Sales Return Correction
- Precondition: A Delivery exists with a WRONG cost ($10). A linked Return exists, also at ($10).
- Action: Run Recalculation (which corrects Delivery to $12).
- Verify: The Return move is also automatically updated to $12 to match its origin.
FAQ & Troubleshooting
Common Resolutions
Does this change Account Moves?
No. It strictly updates stock.move Unit Price and Total Value. Your posted Journal Entries (Debits/Credits) remain untouched to preserve legal accounting records. You must create a manual journal entry for the difference if needed.
Why is my Initial Balance wrong?
Reason: If your stock history has gaps or migrated data errors, the SQL 'Genesis' calculation might be off.
Fix: Use the God Mode in the wizard to manually override the values.
Can I undo a Recalculation?
Not directly. The operation permanently updates the values in the database. However, since it is deterministic, you can re-run the calculation or manually adjust the Initial Balance in the wizard again to "correct" a mistake.
How does it handle different UoMs?
The Waterfall Algorithm automatically converts all quantities to the Product's Base Unit of Measure before calculating the Average Cost, ensuring mathematical accuracy regardless of purchase/sale units.
Evaluation of Returns (Best Practices)
- Purchase Returns (Vendor): Treated as an Exit at Current AVCO. This fully relieves the asset account of the item's current carrying cost, preventing "phantom value" on the balance sheet.
- Sales Returns (Customer): Treated as an Entry at Original Cost* (if linked). This reverses the original COGS impact accurately and updates the running average. (*If standard Odoo links it).
Commercial & Sales
For inquiries about licenses, demos, or partnerships.
Official WhatsApp
Fastest response time.
LINK
+1 (828) 672-6150
Book a Demo
Let's explore your needs.
LINK
Technical Support
Existing customers regarding module functionality.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module