Odoo
Implementation
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Purchase (purchase) • Sales (sale_management) • Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 1163 |
| Technical Name |
lb_albadr_custom |
| License | OPL-1 |
| Website | https://lucidbrainz.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Purchase (purchase) • Sales (sale_management) • Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 1163 |
| Technical Name |
lb_albadr_custom |
| License | OPL-1 |
| Website | https://lucidbrainz.com |
Lucidbrainz Supply Chain & Secondary UOM Management
Professional Dual Unit of Measure Tracking System with Complete Supply Chain Integration, Lead Time Analysis, Document Tracking & Comprehensive Reporting for Odoo 19
Module Overview
Lucidbrainz Supply Chain & Secondary UOM Management by Lucidbrainz Infotech is a comprehensive and professional supply chain management module for Odoo 19 that enables dual unit of measure (UOM) tracking across your entire business operations. This powerful system allows businesses to track products in two different units simultaneously - for example, tracking both pallets and individual items, rolls and meters, or boxes and pieces - providing complete visibility and control throughout the purchase-to-sale lifecycle. Perfect for wholesale distributors, importers, exporters, manufacturers, trading companies, and any business requiring multi-unit inventory management, customs documentation tracking, and detailed lead time analysis. The module seamlessly integrates secondary UOM calculations across Purchase Orders, Stock Movements, Inventory Adjustments, Sales Orders, Delivery Orders, Returns, Scraps, and Invoices, ensuring data consistency and automatic conversion throughout all business processes. Additionally, it provides Bayan Number and Container Number tracking for customs and shipping documentation, comprehensive lead time analysis with 5-step tracking from purchase order confirmation to final sale, and professional Excel reports for detailed supply chain analytics. Built on clean Odoo 19 architecture with automatic ratio-based calculations, real-time UOM conversions, multi-company support, and seamless integration with native Odoo modules including Purchase, Sales, Inventory, and Accounting. Ideal for businesses that want to improve inventory accuracy, streamline import/export operations, maintain dual-unit pricing and documentation, track customs clearance efficiently, analyze procurement lead times, and ensure regulatory compliance in international trade!
Complete Features & Capabilities
- Dual UOM System: Track products in two units simultaneously with configurable conversion ratios - perfect for wholesale (pallets + items), textiles (rolls + meters), or bulk materials (tons + pieces)
- Automatic Ratio Calculation: Define conversion ratio once at product level - system automatically calculates secondary quantities across all transactions with real-time updates on quantity changes
- Purchase Order Integration: Secondary UOM fields on PO lines with auto-calculation based on ordered quantities, automatic propagation to receipts, and vendor bill integration
- Complete Stock Operations: Secondary UOM tracking in receipts, deliveries, internal transfers, inventory adjustments, returns, and scrap orders with full traceability
- Sales Order Support: Secondary UOM fields on quotations and sales orders, automatic quantity calculation on product selection, seamless flow to delivery orders and customer invoices
- Invoice Integration: Secondary quantities automatically appear on customer and vendor bills, proper accounting documentation with dual-unit visibility, and PDF report compatibility
- Customs Documentation: Bayan Number and Container Number fields on Purchase Orders, Sales Orders, Stock Pickings, and Invoices with automatic propagation from source documents
- Date Tracking System: Comprehensive date tracking including PO Confirmation Date, Vendor Acknowledgment Date, Shipping Arrival Date, Port Arrival Date, and Internal Receipt Date
- 5-Step Lead Time Analysis: Detailed breakdown of lead times - (1) PO Confirmation to Acknowledgment, (2) Confirmation to Goods on Vessel, (3) Vessel to Arrival, (4) Arrival to Warehouse, (5) Warehouse to Sale
- Professional Excel Reports: Lead Time Report with wizard-based date filtering, batch/lot number tracking, vendor-wise analysis, and product-level lead time breakdown
- Lot/Batch Tracking: Secondary UOM tracking by lot numbers, batch-wise lead time analysis from purchase to sale, and complete product traceability throughout supply chain
- Return Management: Secondary UOM support in customer returns and vendor returns, automatic recalculation on return quantity, and proper inventory adjustment with dual units
- Scrap Order Integration: Dual UOM tracking in scrap operations, automatic secondary quantity calculation based on scrapped amount, and proper inventory write-off documentation
- Inventory Adjustment Support: Secondary UOM visibility in stock quant adjustments, physical inventory counts with dual units, and accurate reconciliation between systems
- Product On-Hand Calculation: Computed secondary quantity on-hand field on product forms, real-time updates on stock movements, and accurate dual-unit inventory reporting
- Purchase Analysis Enhancement: Secondary UOM grouping in purchase analysis reports, pivot table support with dual-unit metrics, and comprehensive purchasing analytics
- Automatic Status Updates: PO confirmation date auto-filled on confirm button, acknowledgment date captured on vendor acknowledgment, and receipt dates updated on stock validation
- Data Flow Automation: Bayan/Container numbers automatically copy from PO to Receipt to Invoice, secondary UOM flows from PO lines to stock moves to invoices, and zero manual data entry required
- Product Configuration: Easy secondary UOM activation with checkbox, flexible UOM selection from existing Odoo units, and simple ratio definition for conversion
- Optional Field Visibility: Secondary UOM columns available as optional in tree views, users can show/hide based on requirements, and clean interface for non-secondary UOM products
- Multi-Company Compatible: Full Odoo 19 multi-company support, company-specific secondary UOM configurations, and independent tracking per company
- Clean Architecture: Built using Odoo model inheritance best practices, minimal core modifications, no conflicts with other modules, and easy future updates
- Performance Optimized: Efficient @api.onchange decorators for real-time calculations, proper @api.depends for computed fields, and minimal database overhead
- Seamless Integration: Works with existing Odoo workflows without modification, compatible with standard purchase/sales/inventory processes, and supports custom invoice templates
- User-Friendly Interface: Intuitive field placement in standard Odoo forms, clear field labels and tooltips, and logical data flow matching business processes
- Data Integrity: Automatic calculation prevents manual entry errors, consistent data across all related documents, and proper audit trail with activity tracking
- Extensible Design: Easy to extend for additional custom requirements, well-structured code for developer modifications, and comprehensive inline documentation
- International Trade Ready: Perfect for import/export businesses, supports customs documentation workflows, and handles multi-currency transactions with dual UOM
- Manufacturing Compatible: Works with Bill of Materials (BoM) for dual-unit components, supports work orders with secondary UOM, and handles by-products tracking
- Report Customization: Secondary UOM fields ready for inclusion in QWeb reports, compatible with custom invoice/PO templates, and proper PDF export support
Live Module Screenshots - Odoo 19
Inventory → Products → ABC Product:
• Product Type: Goods (storable product)
• Sales & Purchase: Both checkboxes enabled
• Track Inventory: By Quantity enabled
• Allow Secondary UOM: Checkbox unchecked (default state)
Standard product form before enabling secondary UOM functionality
Product ABC with dual UOM configuration:
• Allow Secondary UOM: ✓ Checked
• Secondary UOM: Field now visible for selection
• Ratio: Conversion ratio field (e.g., 1 pallet = 50 pieces)
• Sec Qty On Hand: Computed field showing secondary unit inventory
Activity log shows the change from "No → Yes" for Allow Secondary UOM
Product variant with secondary UOM disabled:
• Allow Secondary UOM: Unchecked by default
• Track Inventory: Unchecked (consumable/service product)
• Shows that secondary UOM is optional per product/variant
Useful for companies with mixed product types (some requiring dual UOM, others not)
ABC variant with complete secondary UOM setup:
• Allow Secondary UOM: ✓ Enabled
• Secondary UOM: "g" (grams) selected
• Ratio: 0.00 (conversion factor)
• Sec Qty On Hand: 0.00 (computed secondary inventory)
Activity tracking shows: "No → Yes" for Allow Secondary UOM
Purchase Order P00012 with custom fields:
• Vendor: ABC supplier selected
• Bayan Number: Custom field for customs documentation
• Container Number: Shipping container tracking
• Date Fields: Confirmation Date, Acknowledgment Date, Shipping Arrival Date, etc.
• Order Lines: Sec QTY and Sec UOM columns visible in product table
RFQ status - ready to send to vendor for confirmation
PO P00014 confirmed with complete data:
• Vendor: ABC
• Confirmation Date: Jan 3, 11:04 AM (auto-filled on confirm)
• Bayan Number: BAY-2026-001
• Container Number: CONT-SH-45678
• Order Lines: Cotton Fabric Roll - Qty: 10.00, Sec QTY: 0.00, Sec UOM visible
• Total Amount: $5,000.00 (Untaxed), Tax 15%, Total: $5,750.00
Activity log shows status changes and Bayan/Container number assignments
Purchase orders dashboard showing multiple POs:
• Columns: Reference, Confirmation Date, Vendor, Company, Buyer, Activities, Source, Total, Billing Status, Expected Arrival
• Example POs:
→ P00014: ABC, $5,750.00, Nothing to Bill, Jan 3, 11:03 AM
→ P00011: Ready Mat, $7,976.40, Nothing to Bill, Jan 4, 11:42 AM
→ P00010: Azure Interior, $2,880.75, Purchase Order status
→ P00009: Gemini Furniture, $12,500.00
→ P00008: Wood Corner, $7,435.33
• Total Value: $36,542.48 across all displayed POs
Clean interface for tracking multiple purchase orders with critical dates
Receipt WH/IN/00011 linked to PO:
• Receive From: ABC vendor
• Operation Type: My Company: Receipts
• Scheduled Date: Jan 3, 11:16 AM
• Bayan Number: Automatically inherited from PO (empty in draft)
• Container Number: Automatically inherited from PO (empty in draft)
• Operations Product, Demand, Sec QTY, Sec UOM columns visible
Status: Draft → Ready for validation
Delivery WH/OUT/00025 in Done status:
• Operation Type: My Company: Delivery Orders
• Scheduled Date: Jan 2, 2024, 11:42 AM
• Effective Date: Jan 2, 2024, 11:42 AM
• Bayan Number: Tracking field available
• Container Number: Tracking field available
• Product: Desk Combination, Demand: 110.00, Quantity: 110.00
• Sec QTY & Sec UOM: 0.00 (columns visible for tracking)
Activity log shows transfer creation and status change to Done
Inventory adjustment view with dual UOM columns:
• Columns: Product, Lot/Serial Number, Scheduled, User, On Hand, Counted, Difference, Sec UOM, Sec QTY, History
• Sample Products:
→ Customizable Desk: 65.00, 70.00, 50.00, 45.00, 55.00 (multiple locations)
→ Large Cabinet: 500.00
→ Storage Box: 18.00
→ Cabinet with Doors: 33.00
→ Conference Chair: 26.00, 30.00
→ Office Chair Black: 10.00
→ Desk Combination: 235.00
→ Drawer (Lot: 0000000000029): 80.00
→ Cable Management Box (CM-BOX-00001, CM-BOX-00002): 50.00, 40.00
• Sec UOM & Sec QTY: All showing 0.00 (ready for configuration)
Scheduled for Dec 31 inventory count
New scrap order with secondary UOM fields:
• Product: Customizable Desk
• Quantity: 1.00
• Replenish Quantities: ✓ Checked (will replenish)
• Scrap Reason: Field available for documentation
• Sec UOM: Secondary unit of measure field
• Sec QTY: 0.00 (automatically calculated based on ratio)
• Company: My Company (San Francisco)
Status: Draft → Ready to validate
Activity log shows scrap creation timestamp
New quotation with custom fields:
• Customer: Field to select customer
• Quotation Date: Jan 3, 11:59 AM
• Expiration: Feb 2
• Payment Terms: Immediate
• Bayan Number: Custom tracking field
• Container Number: Custom tracking field
• Order Lines Table:
→ Columns: Product, Quantity, Unit Price, Allow Secondary UOM, Sec QTY, Sec UOM, Taxes, Amount
→ "Add a product", "Add a section", "Add a note" options available
→ Catalog button for quick product selection
• Totals: Untaxed Amount: $0.00, Total: $0.00
Three tabs: Order Lines, Other Info, Customer Signature
Draft invoice with complete tracking:
• Customer: ABC
• Invoice Date: Today
• Due Date: Jan 3 or Payment Terms selector
• Currency: in USD
• Bayan Number: Customs documentation field
• Container Number: Shipping container tracking
• Invoice Lines Table:
→ Columns: Product, Quantity, Price, Sec UOM, Sec QTY, Taxes, Amount
→ "Add a line", "Add a section", "Add a note" options
→ Catalog button for quick item addition
• Totals: Untaxed Amount: $0.00, Total: $0.00, Amount Due: $0.00
Two tabs: Invoice Lines, Other Info
Activity panel shows invoice creation at 12:00 PM
Purchase → Reporting → Print Lead Time Report:
• Date From: Required field (select start date for analysis)
• Date To: Required field (select end date for analysis)
• Print Button: Generate Excel report with comprehensive lead time breakdown
• Cancel Button: Close wizard without generating report
Simple two-field wizard for powerful supply chain analytics
Report includes: PO No, Supplier, Product, Batch No, 5-step lead times, Total Lead
Settings for invoice/report customization:
• Layout Styles: Light (selected), Boxed, Bold, Striped, Bubble, Wave, Folder
• Background: Blank (dropdown with color options)
• Text: Lato font
• Logo: "Your logo" upload placeholder
• Colors: Purple and black color scheme selectors
• Address: My Company (San Francisco), 8000 Marina Blvd, Suite 300, Brisbane CA 94005, United States
• Tagline: e.g. Global Business Solutions
• Footer: Contact info (+1 555-555-5556 info@yourcompany.com http://www.example.com)
• Paper format: A4
Live preview shows invoice INV/2023/00003 with selected styling
Continue/Discard buttons for applying changes
Purchase → Reporting → Purchase Analysis:
• Filter Applied: Purchase Orders OR Confirmation Date: January 2026
• View Options: Bar chart, Line chart, Pie chart, Table, List, Calendar, Activity views
• Measures Dropdown: Access to various metrics including Sec QTY
• Insert in Spreadsheet: Export functionality
• Graph Display: Area chart showing Untaxed Total over time (Dec 15, 2025 - Jan 3, 2026)
• Data Points: Multiple peaks showing purchase order values
→ Peak 1: ~$2,500 (Dec 15)
→ Peak 2: ~$6,500 (Dec 23-24)
→ Peak 3: ~$12,500 (Dec 28)
→ Peak 4: ~$7,000 (Jan 2-3)
• Table/Pivot View: Available for detailed secondary UOM analysis
Search functionality with advanced filters for comprehensive purchasing insights
How It Works - Simple 4-Step Process
Configure Products
Go to Product form → Enable "Allow Secondary UOM" → Select Secondary Unit (e.g., Rolls, Pallets) → Set Conversion Ratio → Save
Create Purchase Order
Create PO → Add product with secondary UOM → Enter quantity → Secondary quantity auto-calculates → Add Bayan/Container numbers → Confirm
Process Stock & Sales
Receive goods → Secondary UOM flows to receipt → Create sales orders → Deliver products → Secondary quantities tracked throughout
Analyze & Report
Generate Lead Time Reports → View purchase analysis with Sec UOM → Track customs documentation → Monitor supply chain performance
Our Professional Services
Odoo
Customization
Odoo
Migration
Support &
Maintenance
📞 Contact Us
WhatsApp:
Email:
Website: |
🌐 Follow Us📘 Facebook 📸 Instagram 💼 LinkedIn 🎥 YouTube |
© 2025 Lucidbrainz Infotech | Professional Odoo 19 Supply Chain Solutions | All Rights Reserved
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