Problem

Inventory-Accounting Mismatch

In Odoo, two systems track inventory:

• Stock Quants: Physical inventory quantities in warehouses
• Stock Valuation Layers (SVL): Financial records for inventory accounting

Common Issues:

• Quant quantities ≠ SVL quantities → Inaccurate financial reports
• Negative SVL values in locations → Accounting errors
• Misallocated inventory across locations → Operational inefficiencies
• Manual reconciliation is time-consuming and error-prone

Business Impact:

• Incorrect inventory valuation on balance sheets
• Inaccurate COGS calculations
• Failed audits due to quantity discrepancies
• Poor inventory allocation decisions

Solution

This module automates detection and correction of inventory-accounting mismatches:

1. Detection & Reporting

• Compare quant quantities vs SVL quantities per product/location
• Export Excel reports highlighting mismatches
• Calculate correct unit costs from SVL data

2. Automated Reconciliation

• Purchase Orders: Auto-create POs for locations with negative SVL (missing stock value)
• Sale Orders: Auto-create SOs for locations with positive SVL (excess stock value)
• Internal Transfers: Auto-generate stock moves to rebalance inventory between locations

3. Cost Correction

• Automatically update product standard prices based on actual SVL values
• Ensure accurate costing for future transactions

How It Works

Product-Level Analysis

Action: Click “Export Quant” on product form

Output:

• Excel report comparing quant vs SVL quantities
• Match status for each product
• Calculated unit costs
• Auto-created sale order for inventory distribution

Location-Level Analysis

Actions: Available on location form

1. View SVL Summary → Visual analysis of SVL records by product
2. Create PO → Generates purchase orders for negative SVL corrections
3. Create SO → Generates sale orders for positive SVL distribution
4. Create Tr → Exports report + creates internal transfers to rebalance stock