📦 Serial Tracking Status Report

Odoo Instance: enterprise.omnivoltaic.com · Generated: 2026-06-03 · Odoo 18.0+e Enterprise

✅

Serial Tracking IS Active

26 products configured · 139 stock moves · 50+ serial-numbered lots recorded

Serial-Tracked Products
26
0.7% of all products
Lot-Tracked Products
123
3.3% of all products
Untracked Products
3,540
96.0% of all products
Stock Moves (Serial)
139
Active operations confirmed
Serial-Numbered Lots
50+
In stock.lot table
⚠️
Data Quality Issue: Serial-tracked products with no serial numbers assigned
Some serial-tracked products have on-hand quantities >1 with lot_id=None.
This happens when a product is switched to serial tracking after stock is already on-hand.
Affected products: E-VCU-C (qty=238), 12345 (qty=31), E-Mob-Bat30Ah (qty=6)
Fix: Use Odoo's "Assign Serial Numbers" wizard to split into individual serial-numbered lots.

📊 Tracking Type Distribution

🏢 Serial-Tracked Products by Company

🔢 Serial-Tracked Products by Company (Detail)

🏢 Company Breakdown: Serial-Tracked Products

Company Serial Products Status
Shared (No Company — visible to all) 15 ⚠️ Review: may be intentional (global products) or config issue
Test Company 8 ✅ Active implementation
Oves Shenzhen (HM) 2 ✅ Active implementation
OV Kenya (Test) 1 ⚠️ Minimal usage

📦 Serial-Tracked Products (Full List)

Default Code Product Name Company
HM110110Test Company
OVES-B00-0001CEHP-100AH48Test Company
OVES-B00-13-110UBP2KTest Company
OVES-B03-0073XT90CCTest Company
OVES-B03-0074OVEX5_4mm2Oves Shenzhen (HM)
OVES-B04-0033JCN-MC550W-72Oves Shenzhen (HM)
OVES-B07-0164BD-228DVTest Company
OVES-B96-0098PET-3D_ATest Company
OVES-B96-0142E-VCU-CTest Company
OVES-B96-0214E-Mob-Bat100AhTest Company
OVES-test-0001S0001Shared
OVES-test-0002S0002Shared
OVES-test-0003S0003Shared
SY0001SY001 testShared
1234512345Shared
12W PV Cable-LUMN HOME12W PV Cable-LUMN HOMEShared
ACBACBShared
Bat30Ah48V_BLEE-Mob-Bat30AhShared
E-3 MAXE-3 MAXShared
E-Mob-Bat70AhE-Mob-Bat70AhShared
0-Brake Assembly0-Brake AssemblyShared
12Ah SHS12Ah SHSShared
Bolt & Nut 6Bolt & Nut 6Shared
Ovego BAT70AhOvego BAT70AhShared
N/ATest productOV Kenya (Test)

🔬 How Serial Tracking Works in Odoo 18+

1
Configure Product
Inventory tab → Tracking = "Unique Serial Number"
2
Receiving
Odoo forces entry of individual serial numbers on arrival
3
Delivery
Odoo forces selection of which serial number(s) to deliver
4
Traceability
Full forward/backward traceability via stock.lot records
Note: In Odoo 18+, both Lot and Serial Number tracking use the same stock.lot model. The difference: Lot allows qty >1 per lot; Serial requires qty=1 per lot.

📋 Recommendations for Team Action

1
Fix lot_id=None quants (P0)
Run Odoo's "Assign Serial Numbers" wizard on E-VCU-C, 12345, and E-Mob-Bat30Ah to split >1 qty quants into individual serial-numbered lots.
2
Review "Shared" serial-tracked products (P1)
15 serial-tracked products have no company_id. Confirm whether they should be company-specific or truly shared globally.
3
Consider expanding serial tracking (P2)
Only 26/3,689 products (0.7%) use serial tracking. High-value items may be missing proper traceability — review with warehouse team.
4
Plan Lot → Serial transition (P2)
123 products use Lot tracking. For items needing individual item traceability (warranty, service), plan transition to Serial tracking.
Generated by WorkBuddy AI · Data sourced from live Odoo XML-RPC query · No Odoo models or data were modified
⚠️ This report is for internal use only. Verify all findings in Odoo before taking action.