Odoo
Implementation
Secondary UOM | Lead Time Tracking | Purchase Milestones
by Lucidbrainz https://lucidbrainz.com
Odoo
$ 35.01
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Purchase (purchase) • Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 1156 |
| Technical Name |
all_in_one_secondary_uom |
| License | OPL-1 |
| Website | https://lucidbrainz.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Invoicing (account) • Purchase (purchase) • Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 1156 |
| Technical Name |
all_in_one_secondary_uom |
| License | OPL-1 |
| Website | https://lucidbrainz.com |
Secondary UOM | Lead Time Tracking | Purchase Milestones
Secondary Unit of Measure on Sale, Purchase & Inventory | 5-Step Lead Time XLSX Report | Bayan & Container Number Tracking | Purchase Milestone Dates for Odoo 19
Overview
Secondary UOM | Lead Time Tracking | Purchase
Milestones by
LucidBrainz is a powerful Odoo 19 module
that adds Secondary Unit of Measure (Sec UOM) tracking across your
entire supply chain — from Purchase Orders to
Sales, Inventory,
Vendor Bills, Customer Invoices,
Scrap, and Returns. Every product can have a
primary unit (e.g. Box, Bag, Carton) and a secondary unit (e.g. KG, Litre, Gram)
with a configurable ratio. The system
automatically calculates Sec QTY on every transaction —
zero manual entry required.
Perfect for import/export businesses,
commodity traders, FMCG companies,
food & agriculture distributors,
procurement managers, warehouse operators,
and any organization that needs to track
weight alongside packaging units,
secondary quantity on invoices and bills,
Bayan and Container numbers across all transactions,
or lead time from purchase to sale in a structured report.
The module introduces Bayan Number and
Container Number fields on Purchase Orders and Sale Orders
with automatic propagation to all linked documents —
Receipts, Deliveries, Vendor Bills, Customer Invoices, and Returns are all
updated automatically when the document is created.
No more manual copying of shipment reference numbers!
The 5-Step Lead Time XLSX Report is the crown jewel of this
module. It tracks five critical milestones for each Purchase Order:
(1) PO Confirmation → Supplier Acknowledgement,
(2) PO Confirmation → Goods On Vessel,
(3) Goods On Vessel → Goods Arrival at Port,
(4) Goods Arrival at Port → Goods in Warehouse,
(5) Goods in Warehouse → Goods Sold.
The report exports a professional Excel file with a date
range filter, showing days for each step and a
Total Lead Time per product per PO.
Key capabilities include:
Secondary UOM on Stock Moves & Move Lines,
Sec UOM on Stock Pickings (Receipts & Deliveries),
Sec UOM on Stock Scrap,
Sec UOM on Stock Return Wizard,
Sec UOM on Vendor Bills & Customer Invoices,
Purchase Milestone Date auto-tracking
(Confirmation Date, Acknowledgement Date, Shipping Arrival Date,
Arrival Date at Port, Internal Receipt Date),
Bayan & Container auto-copy to picking on creation,
Bayan & Container auto-copy to bills/invoices on creation,
Secondary UOM grouping in Purchase Analysis Report, and
XLSX Lead Time Report with date range filter.
Key Features
- Secondary UOM on All Transactions: Enable Secondary UOM on any product with a configurable Ratio (e.g. 1 Box = 25 KG, 1 Bag = 50 KG, 1 Carton = 12 Litre). Sec QTY automatically calculated on Sale Order Lines, Purchase Order Lines, Stock Moves, Stock Move Lines (Detailed Operations), Stock Pickings, Stock Scrap, Stock Return Wizard, Vendor Bills, and Customer Invoices
- Bayan & Container Number Tracking: Bayan Number and Container Number fields added on both Sale Orders and Purchase Orders. Auto-copy to Stock Picking on creation. Auto-copy to Vendor Bill and Customer Invoice on creation. Complete shipment traceability with zero manual entry — one entry on PO propagates everywhere automatically
- 5-Step Lead Time XLSX Report: Step 1: PO Confirmation → Supplier Acknowledgement (Days). Step 2: PO Confirmation → Goods On Vessel (Days). Step 3: Goods On Vessel → Goods Arrival at Port (Days). Step 4: Goods Arrival at Port → Goods in Warehouse (Days). Step 5: Goods in Warehouse → Goods Sold (Days). Total Lead Time auto-calculated. Export XLSX with Date Range Filter. Color-coded professional Excel output with full step descriptions
- Purchase Milestone Dates: Confirmation Date (auto-set on PO Confirm). Acknowledgement Date (auto-set on Acknowledge button click). Shipping Arrival Date (manually set or auto). Arrival Date at Port (manually set). Internal Receipt Date (auto-set on Validate Receipt). Complete chatter history for every date change with timestamp
- Full Purchase Flow Integration: RFQ → Confirm → Acknowledge → Receipt → Vendor Bill. Sec UOM, Sec QTY, Bayan Number, Container Number tracked and carried forward at every stage of the purchase process. Received Quantity shows both primary and secondary units simultaneously
- Full Sales Flow Integration: Sale Order → Delivery → Customer Invoice. Bayan and Container auto-copy from Sale Order to Delivery and Invoice. Sec UOM and Sec QTY visible in delivery lines and invoice lines. SMS notification automatically sent to customer on delivery validation
- Return Wizard Enhancement: Standard Odoo Return Wizard extended with Sec QTY and Sec UOM columns. Return picking automatically copies Bayan and Container numbers. Complete secondary quantity visibility before confirming returns. Works for both vendor returns and customer returns
- Scrap Operation Support: Sec UOM and Sec QTY fields on Stock Scrap form. Auto-calculated from product ratio when product is selected. Example: Scrap 1 Box (Ratio 25) = Sec QTY 25 KG automatically. Accurate waste tracking with secondary unit — no manual entry
- Purchase Analysis Enhancement: Secondary UOM grouping option added to Purchase Analysis Report. Filter and group purchase data by Secondary UOM (KG, Litre, Gram). Chart view shows Bag vs Box vs other units separately. Better procurement analytics for secondary unit tracking
- Purchase Orders List View Enhancement: Bayan Number and Container Number columns visible in PO list view. Quick overview of all shipment references without opening each order. Reporting menu has dedicated "Print Lead Time Report" option accessible directly from Purchase Orders list
- Product Template Configuration: Allow Secondary UOM checkbox on product form to enable the feature. Secondary UOM field to select the weight/volume unit (kg, litre, etc.). Ratio field to define conversion (e.g. 1 Box = 25 KG). Sec Qty On Hand computed field shows secondary stock quantity
- Detailed Operations View: Sec QTY and Sec UOM columns added to Stock Move Line list view. Visible in Detailed Operations of every receipt and delivery. Helps warehouse staff verify secondary quantity at lot/serial level. Works with both lot tracking and serial number tracking
- Professional XLSX Output: Lead Time Report exports a color-coded Excel file with dark blue headers. Columns: PO No, Supplier, Product, Batch No, Step 1-5, Total Lead Time. Full step descriptions in column headers for easy understanding. Dash (—) shown for steps not yet completed (e.g. not yet sold to customer)
- Supported Odoo Apps & Module Info: Supports Sales, Purchase, Inventory / Stock, Accounting (Invoicing). Depends on: base, sale, purchase, stock, account, xlsx_report. Module Technical Name: all_in_one_secondary_uom. Version: 19.0.1.0.0 | License: OPL-1 | Price: $31.00 USD
Module Screenshots
🌾 Step 01 — Rice Basmati 25KG: Secondary UOM Configuration
Sales → Products → Rice Basmati 25KG open karo aur Secondary UOM configure karo:
• Allow Secondary UOM: ✅ Checked — yeh checkbox enable karo
• Secondary UOM: kg — weight track karne ki unit
• Ratio: 25.00 — iska matlab 1 Box = 25 kg (auto-calculate hoga)
• Ab jab bhi 10 Box purchase/sale hoga, system automatically 250 kg Sec QTY show karega
• Chatter mein: Secondary UOM → kg, Ratio → 25 change history recorded
Sales → Products → Rice Basmati 25KG open karo aur Secondary UOM configure karo:
• Allow Secondary UOM: ✅ Checked — yeh checkbox enable karo
• Secondary UOM: kg — weight track karne ki unit
• Ratio: 25.00 — iska matlab 1 Box = 25 kg (auto-calculate hoga)
• Ab jab bhi 10 Box purchase/sale hoga, system automatically 250 kg Sec QTY show karega
• Chatter mein: Secondary UOM → kg, Ratio → 25 change history recorded
🍬 Step 02 — Sugar 50KG: Secondary UOM Configuration
Same process Sugar 50KG product pe karo:
• Allow Secondary UOM: ✅ Checked
• Secondary UOM: kg | Ratio: 50.00 (1 Bag = 50 kg)
• Sales Price: $250 per Bag | Tax: 15%
• Ab 5 Bag purchase pe automatically 250 kg Sec QTY show hogi
• Chatter: Allow Secondary UOM → Yes, Secondary UOM → kg, Ratio → 50 logged
Same process Sugar 50KG product pe karo:
• Allow Secondary UOM: ✅ Checked
• Secondary UOM: kg | Ratio: 50.00 (1 Bag = 50 kg)
• Sales Price: $250 per Bag | Tax: 15%
• Ab 5 Bag purchase pe automatically 250 kg Sec QTY show hogi
• Chatter: Allow Secondary UOM → Yes, Secondary UOM → kg, Ratio → 50 logged
📦 Step 03 — Box UOM: Reference Unit Verify
Inventory → Configuration → Units & Packagings mein Box unit verify karo:
• Unit Name: Box | Quantity: 1.00000 — Reference Unit
• Yeh primary selling/purchasing unit hai Rice Basmati ke liye
• Is unit ke against Ratio 25 set kiya hai — jo Secondary UOM calculate karta hai
• Position: 9/15 in UOM category list
Inventory → Configuration → Units & Packagings mein Box unit verify karo:
• Unit Name: Box | Quantity: 1.00000 — Reference Unit
• Yeh primary selling/purchasing unit hai Rice Basmati ke liye
• Is unit ke against Ratio 25 set kiya hai — jo Secondary UOM calculate karta hai
• Position: 9/15 in UOM category list
🏢 Step 04 — Al Noor Trading LLC: Vendor Create
Purchase → Vendors → New mein supplier create karo:
• Type: Company | Country: India
• Email: alnoor@supplier.com | Phone: +91 9876543210
• Tax ID: 12AAAAA1234AAZA
• Isi vendor se P00001 Purchase Order banegi — Rice aur Sugar purchase karenge
Purchase → Vendors → New mein supplier create karo:
• Type: Company | Country: India
• Email: alnoor@supplier.com | Phone: +91 9876543210
• Tax ID: 12AAAAA1234AAZA
• Isi vendor se P00001 Purchase Order banegi — Rice aur Sugar purchase karenge
🏗️ Step 05 — Gulf Star Trading: Customer Create
Sales → Customers → New mein customer create karo:
• Type: Company | Country: United Arab Emirates
• Phone: +971 50 1234567
• Logo: Gulf Star Global Trading DMCC
• Isi customer ko S00001 Sale Order mein Rice aur Sugar sell karenge
Sales → Customers → New mein customer create karo:
• Type: Company | Country: United Arab Emirates
• Phone: +971 50 1234567
• Logo: Gulf Star Global Trading DMCC
• Isi customer ko S00001 Sale Order mein Rice aur Sugar sell karenge
📋 Step 06 — P00001: RFQ Created with Bayan, Container & Sec QTY
Purchase → New. Vendor = Al Noor Trading LLC. Products add karo:
• Bayan Number: BYN-2025-001 — module ka naya field ✅
• Container Number: CONT-XYZ-9988 — module ka naya field ✅
• Rice Basmati 25KG: 10 Box → Sec QTY = 250 kg (automatically calculated)
• Sugar 50KG: 5 Bag → Sec QTY = 250 kg (automatically calculated)
• Sec UOM aur Sec QTY columns product lines mein clearly dikh rahe hain | Total: $4,750
Purchase → New. Vendor = Al Noor Trading LLC. Products add karo:
• Bayan Number: BYN-2025-001 — module ka naya field ✅
• Container Number: CONT-XYZ-9988 — module ka naya field ✅
• Rice Basmati 25KG: 10 Box → Sec QTY = 250 kg (automatically calculated)
• Sugar 50KG: 5 Bag → Sec QTY = 250 kg (automatically calculated)
• Sec UOM aur Sec QTY columns product lines mein clearly dikh rahe hain | Total: $4,750
✅ Step 07 — P00001: Order Confirmed (Confirmation Date Auto-Set)
Confirm Order button click karo. Yeh changes automatically hote hain:
• Status: RFQ → Purchase Order
• Confirmation Date: Mar 1 — module automatically set karta hai (Lead Time Step 1 start)
• Acknowledge button: ab visible hai — click karne par Acknowledgment Date auto-set hogi
• Receipt: 1 automatically Inventory mein create ho gayi
• Chatter: None → 03/01/2026 (Confirmation Date), RFQ → Purchase Order (Status)
Confirm Order button click karo. Yeh changes automatically hote hain:
• Status: RFQ → Purchase Order
• Confirmation Date: Mar 1 — module automatically set karta hai (Lead Time Step 1 start)
• Acknowledge button: ab visible hai — click karne par Acknowledgment Date auto-set hogi
• Receipt: 1 automatically Inventory mein create ho gayi
• Chatter: None → 03/01/2026 (Confirmation Date), RFQ → Purchase Order (Status)
📅 Step 08 — P00001: Acknowledge + Shipping & Port Dates Set
Acknowledge button click karo aur remaining milestone dates fill karo:
• Acknowledge click → Acknowledgment Date: Mar 1 (auto-set by module)
• Shipping Arrival Date: Mar 6 — manually enter karo (Lead Time Step 2 & 3 use karega)
• Arrival Date at Port: Mar 9 — manually enter karo (Lead Time Step 3 & 4 use karega)
• Internal Receipt Date: receipt validate hone par automatically set hogi
• Chatter: har date change ka complete log visible hai timestamp ke saath
Acknowledge button click karo aur remaining milestone dates fill karo:
• Acknowledge click → Acknowledgment Date: Mar 1 (auto-set by module)
• Shipping Arrival Date: Mar 6 — manually enter karo (Lead Time Step 2 & 3 use karega)
• Arrival Date at Port: Mar 9 — manually enter karo (Lead Time Step 3 & 4 use karega)
• Internal Receipt Date: receipt validate hone par automatically set hogi
• Chatter: har date change ka complete log visible hai timestamp ke saath
📊 Step 09 — P00001: All 5 Milestone Dates Populated + Full Chatter History
Receipt validate hone ke baad P00001 pe saari 5 dates appear ho jaati hain:
• Confirmation Date: Mar 1 | Acknowledgment Date: Mar 1 | Shipping Arrival: Mar 6
• Arrival Date at Port: Mar 9 | Internal Receipt Date: Mar 1 (auto-set on receipt validation)
• Received Qty update: Rice Basmati 0 → 10, Sugar 50KG 0 → 5
• Chatter: complete history of every field change with user and timestamp
• Yahi 5 dates Lead Time XLSX Report calculate karne mein use hongi
Receipt validate hone ke baad P00001 pe saari 5 dates appear ho jaati hain:
• Confirmation Date: Mar 1 | Acknowledgment Date: Mar 1 | Shipping Arrival: Mar 6
• Arrival Date at Port: Mar 9 | Internal Receipt Date: Mar 1 (auto-set on receipt validation)
• Received Qty update: Rice Basmati 0 → 10, Sugar 50KG 0 → 5
• Chatter: complete history of every field change with user and timestamp
• Yahi 5 dates Lead Time XLSX Report calculate karne mein use hongi
📥 Step 10 — WH/IN/00001: Receipt Ready (Bayan & Container Auto-Copied)
P00001 confirm hone par automatically WH/IN/00001 receipt create hoti hai:
• Source Document: P00001
• Bayan Number: BYN-2025-001 — PO se automatically copy ✅ (module feature)
• Container Number: CONT-XYZ-9988 — PO se automatically copy ✅ (module feature)
• Rice Basmati 25KG: Demand 10, Qty 10, Sec QTY 250 kg visible in lines
• Sugar 50KG: Demand 5, Qty 5, Sec QTY 250 kg visible in lines
• Status: Ready | Validate button click karo receipt complete karne ke liye
P00001 confirm hone par automatically WH/IN/00001 receipt create hoti hai:
• Source Document: P00001
• Bayan Number: BYN-2025-001 — PO se automatically copy ✅ (module feature)
• Container Number: CONT-XYZ-9988 — PO se automatically copy ✅ (module feature)
• Rice Basmati 25KG: Demand 10, Qty 10, Sec QTY 250 kg visible in lines
• Sugar 50KG: Demand 5, Qty 5, Sec QTY 250 kg visible in lines
• Status: Ready | Validate button click karo receipt complete karne ke liye
✅ Step 11 — WH/IN/00001: Receipt Done (Successfully Validated)
Validate click ke baad receipt Done status mein aa jaata hai:
• Status: Done ✅ | Effective Date: Mar 1, 3:39 PM
• P00001 pe Internal Receipt Date automatically Mar 1 set ho gayi
• Sec QTY: Rice 250 kg, Sugar 250 kg — properly saved in Done state
• Bayan: BYN-2025-001 | Container: CONT-XYZ-9988 — preserved after validation
• Return button: active ho gaya — returns ke liye use kar sakte hain
Validate click ke baad receipt Done status mein aa jaata hai:
• Status: Done ✅ | Effective Date: Mar 1, 3:39 PM
• P00001 pe Internal Receipt Date automatically Mar 1 set ho gayi
• Sec QTY: Rice 250 kg, Sugar 250 kg — properly saved in Done state
• Bayan: BYN-2025-001 | Container: CONT-XYZ-9988 — preserved after validation
• Return button: active ho gaya — returns ke liye use kar sakte hain
🔄 Step 12 — Return Wizard: Sec QTY & Sec UOM Columns Added by Module
WH/IN/00001 → Return button click karo. Wizard khulega jisme naye columns hain:
• Sec QTY column: standard Odoo mein nahi hota — module ka addition ✅
• Sec UOM column: standard Odoo mein nahi hota — module ka addition ✅
• Rice Basmati 25KG: Qty 10 Box, Sec QTY 250 kg — clearly visible
• Sugar 50KG: Qty 5 Bag, Sec QTY 250 kg — clearly visible
• Return karne se pehle secondary quantity verify aur confirm kar sakte ho
WH/IN/00001 → Return button click karo. Wizard khulega jisme naye columns hain:
• Sec QTY column: standard Odoo mein nahi hota — module ka addition ✅
• Sec UOM column: standard Odoo mein nahi hota — module ka addition ✅
• Rice Basmati 25KG: Qty 10 Box, Sec QTY 250 kg — clearly visible
• Sugar 50KG: Qty 5 Bag, Sec QTY 250 kg — clearly visible
• Return karne se pehle secondary quantity verify aur confirm kar sakte ho
📋 Step 13 — Detailed Operations: Sec QTY + Sec UOM Column View
WH/IN/00001 → Detailed Operations tab mein module ke naye columns dikh rahe hain:
• Path: P00001 / WH/IN/00001 / Detailed Operations
• Rice Basmati 25KG: Sec QTY 250.00 | Sec UOM kg | Quantity 10.00 Box
• Sugar 50KG: Sec QTY 250.00 | Sec UOM kg | Quantity 5.00 Bag
• Lot/serial number tracking ke saath bhi secondary weight visible hai
• Total 2 records: 1-2/2 — dono product lines show ho rahi hain
WH/IN/00001 → Detailed Operations tab mein module ke naye columns dikh rahe hain:
• Path: P00001 / WH/IN/00001 / Detailed Operations
• Rice Basmati 25KG: Sec QTY 250.00 | Sec UOM kg | Quantity 10.00 Box
• Sugar 50KG: Sec QTY 250.00 | Sec UOM kg | Quantity 5.00 Bag
• Lot/serial number tracking ke saath bhi secondary weight visible hai
• Total 2 records: 1-2/2 — dono product lines show ho rahi hain
🧾 Step 14 — Draft Vendor Bill: Bayan & Container Auto-Copied from PO
P00001 → Upload Bill click karo. Draft Bill automatically create hogi:
• Bayan Number: BYN-2025-001 — PO se automatically copy ✅ (module feature)
• Container Number: CONT-XYZ-9988 — PO se automatically copy ✅ (module feature)
• Invoice Lines mein Sec UOM: kg | Sec QTY: 250 — visible in bill lines
• GRN (Goods Receipt Note) WH/IN/00001 right side mein preview dikh raha hai
• Total: $4,750 | Confirm button click karo bill post karne ke liye
P00001 → Upload Bill click karo. Draft Bill automatically create hogi:
• Bayan Number: BYN-2025-001 — PO se automatically copy ✅ (module feature)
• Container Number: CONT-XYZ-9988 — PO se automatically copy ✅ (module feature)
• Invoice Lines mein Sec UOM: kg | Sec QTY: 250 — visible in bill lines
• GRN (Goods Receipt Note) WH/IN/00001 right side mein preview dikh raha hai
• Total: $4,750 | Confirm button click karo bill post karne ke liye
🛒 Step 15 — S00001: Sale Order with Bayan, Container & Sec QTY
Sales → New. Customer = Gulf Star Trading. Sales ke liye alag numbers use karo:
• Bayan Number: BYN-SALE-001 — sales shipment ka dedicated bayan number
• Container Number: CONT-SALE-7788 — sales container ka dedicated number
• Rice Basmati 25KG: 4 Box → Sec QTY = 100 kg (automatically calculated)
• Sugar 50KG: 2 Bag → Sec QTY = 100 kg (automatically calculated)
• Total: $2,875 (Tax 15%: $375 included) | Expiration: Mar 31
Sales → New. Customer = Gulf Star Trading. Sales ke liye alag numbers use karo:
• Bayan Number: BYN-SALE-001 — sales shipment ka dedicated bayan number
• Container Number: CONT-SALE-7788 — sales container ka dedicated number
• Rice Basmati 25KG: 4 Box → Sec QTY = 100 kg (automatically calculated)
• Sugar 50KG: 2 Bag → Sec QTY = 100 kg (automatically calculated)
• Total: $2,875 (Tax 15%: $375 included) | Expiration: Mar 31
🚚 Step 16 — WH/OUT/00001: Delivery Ready (Products Available)
S00001 confirm hone par WH/OUT/00001 automatically create hoti hai:
• Delivery Address: Gulf Star Trading | Source Document: S00001
• Bayan Number: BYN-SALE-001 — SO se automatically copy ✅ (module feature)
• Container Number: CONT-SALE-7788 — SO se automatically copy ✅ (module feature)
• Rice Basmati 25KG: 4 Box, Sec QTY 100 kg — Available ✅
• Sugar 50KG: 2 Bag, Sec QTY 100 kg — Available ✅ | Validate karo
S00001 confirm hone par WH/OUT/00001 automatically create hoti hai:
• Delivery Address: Gulf Star Trading | Source Document: S00001
• Bayan Number: BYN-SALE-001 — SO se automatically copy ✅ (module feature)
• Container Number: CONT-SALE-7788 — SO se automatically copy ✅ (module feature)
• Rice Basmati 25KG: 4 Box, Sec QTY 100 kg — Available ✅
• Sugar 50KG: 2 Bag, Sec QTY 100 kg — Available ✅ | Validate karo
✅ Step 17 — WH/OUT/00001: Delivery Done + Automatic SMS to Customer
Validate click ke baad delivery Done. Module automatic SMS bhejta hai:
• Status: Done ✅ | Effective Date: Mar 1, 3:56 PM
• SMS automatically sent: "order nº S00001 has been shipped" — Gulf Star Trading ko
• Sec QTY: Rice 100 kg, Sugar 100 kg — properly saved in Done state
• Bayan: BYN-SALE-001 | Container: CONT-SALE-7788 — preserved
• Chatter: Ready → Done (Status) change logged with timestamp
Validate click ke baad delivery Done. Module automatic SMS bhejta hai:
• Status: Done ✅ | Effective Date: Mar 1, 3:56 PM
• SMS automatically sent: "order nº S00001 has been shipped" — Gulf Star Trading ko
• Sec QTY: Rice 100 kg, Sugar 100 kg — properly saved in Done state
• Bayan: BYN-SALE-001 | Container: CONT-SALE-7788 — preserved
• Chatter: Ready → Done (Status) change logged with timestamp
🧾 Step 18 — INV/2026/00001 Draft: Bayan & Sec UOM Auto from Sale Order
S00001 → Create Invoice karo. Draft Invoice create hogi with auto-copied fields:
• Customer: Gulf Star Trading, United Arab Emirates
• Bayan Number: BYN-SALE-001 — SO se automatically copy ✅ (module feature)
• Container Number: CONT-SALE-7788 — SO se automatically copy ✅ (module feature)
• Invoice Lines mein Sec UOM: kg | Sec QTY: 100 — visible in invoice lines
• Tax 15% applied | Total: $2,875 | Confirm button click karo post karne ke liye
S00001 → Create Invoice karo. Draft Invoice create hogi with auto-copied fields:
• Customer: Gulf Star Trading, United Arab Emirates
• Bayan Number: BYN-SALE-001 — SO se automatically copy ✅ (module feature)
• Container Number: CONT-SALE-7788 — SO se automatically copy ✅ (module feature)
• Invoice Lines mein Sec UOM: kg | Sec QTY: 100 — visible in invoice lines
• Tax 15% applied | Total: $2,875 | Confirm button click karo post karne ke liye
✅ Step 19 — INV/2026/00001: Invoice Posted & Confirmed
Confirm click ke baad Customer Invoice Posted status mein aa jaati hai:
• Status: Posted ✅ | Invoice Date: Mar 1 | Payment Due: Mar 1
• Rice Basmati 25KG: 4 Box | Sec UOM kg | Sec QTY 100 | $2,000
• Sugar 50KG: 2 Bag | Sec UOM kg | Sec QTY 100 | $500
• Untaxed: $2,500 | Tax 15%: $375 | Total: $2,875 | Amount Due: $2,875
• Chatter: Invoice validated, Draft → Posted, Invoice Number assigned
Confirm click ke baad Customer Invoice Posted status mein aa jaati hai:
• Status: Posted ✅ | Invoice Date: Mar 1 | Payment Due: Mar 1
• Rice Basmati 25KG: 4 Box | Sec UOM kg | Sec QTY 100 | $2,000
• Sugar 50KG: 2 Bag | Sec UOM kg | Sec QTY 100 | $500
• Untaxed: $2,500 | Tax 15%: $375 | Total: $2,875 | Amount Due: $2,875
• Chatter: Invoice validated, Draft → Posted, Invoice Number assigned
🗑️ Step 20 — SP/00001: Scrap with Sec QTY Auto-Calculated from Product Ratio
Inventory → Operations → Scrap. 1 Box Rice Basmati 25KG scrap karo:
• Product: Rice Basmati 25KG | Quantity: 1.00 Box | Reason: Virtual/Scrapped
• Sec UOM: kg — automatically filled ✅ (module feature)
• Sec QTY: 25.00 — automatically calculated: 1 Box × Ratio 25 = 25 kg ✅
• Status: Done ✅ | Date: Mar 1, 4:00 PM
• Accurate waste tracking — koi manual calculation nahi, ratio se auto-calculate
Inventory → Operations → Scrap. 1 Box Rice Basmati 25KG scrap karo:
• Product: Rice Basmati 25KG | Quantity: 1.00 Box | Reason: Virtual/Scrapped
• Sec UOM: kg — automatically filled ✅ (module feature)
• Sec QTY: 25.00 — automatically calculated: 1 Box × Ratio 25 = 25 kg ✅
• Status: Done ✅ | Date: Mar 1, 4:00 PM
• Accurate waste tracking — koi manual calculation nahi, ratio se auto-calculate
↩️ Step 21 — WH/OUT/00002: Vendor Return Ready (Bayan & Container Auto-Copy)
WH/IN/00001 → Return button → Return click karo. WH/OUT/00002 auto-create hoga:
• Delivery Address: Al Noor Trading LLC (vendor ko return kar rahe hain)
• Source Document: Return of WH/IN/00001
• Bayan Number: BYN-2025-001 — receipt se automatically copy ✅ (module feature)
• Container Number: CONT-XYZ-9988 — receipt se automatically copy ✅ (module feature)
• Rice Basmati 25KG: 10 Box, Sec QTY 250 kg — Available ✅
• Sugar 50KG: 5 Bag, Sec QTY 250 kg — Available ✅ | Validate karo
WH/IN/00001 → Return button → Return click karo. WH/OUT/00002 auto-create hoga:
• Delivery Address: Al Noor Trading LLC (vendor ko return kar rahe hain)
• Source Document: Return of WH/IN/00001
• Bayan Number: BYN-2025-001 — receipt se automatically copy ✅ (module feature)
• Container Number: CONT-XYZ-9988 — receipt se automatically copy ✅ (module feature)
• Rice Basmati 25KG: 10 Box, Sec QTY 250 kg — Available ✅
• Sugar 50KG: 5 Bag, Sec QTY 250 kg — Available ✅ | Validate karo
✅ Step 22 — WH/OUT/00002: Return Done + Automatic SMS to Vendor
Validate ke baad vendor return Done. SMS automatically vendor ko bhi jaati hai:
• Status: Done ✅ | Effective Date: Mar 1, 4:04 PM
• SMS sent: "Return of WH/IN/00001 has been shipped" — Al Noor Trading ko
• Sec QTY: Rice 250 kg, Sugar 250 kg — properly saved in Done state
• Bayan: BYN-2025-001 | Container: CONT-XYZ-9988 — complete traceability
• Source link: WH/IN/00001 — poori chain traceable hai
Validate ke baad vendor return Done. SMS automatically vendor ko bhi jaati hai:
• Status: Done ✅ | Effective Date: Mar 1, 4:04 PM
• SMS sent: "Return of WH/IN/00001 has been shipped" — Al Noor Trading ko
• Sec QTY: Rice 250 kg, Sugar 250 kg — properly saved in Done state
• Bayan: BYN-2025-001 | Container: CONT-XYZ-9988 — complete traceability
• Source link: WH/IN/00001 — poori chain traceable hai
📈 Step 23 — Purchase Analysis: Secondary UOM Group By Option
Purchase → Reporting → Purchase Analysis mein module ne naya option add kiya hai:
• Search bar mein "Sec UOM" filter active hai
• Group By mein "Sec UOM" option ✅ — standard Odoo mein nahi hota (module addition)
• X-axis: Bag → Box (secondary UOM wise grouping clearly visible)
• Y-axis: Untaxed Total ($) — amount by secondary unit type
• Line chart showing purchase value by Sec UOM category for better analytics
Purchase → Reporting → Purchase Analysis mein module ne naya option add kiya hai:
• Search bar mein "Sec UOM" filter active hai
• Group By mein "Sec UOM" option ✅ — standard Odoo mein nahi hota (module addition)
• X-axis: Bag → Box (secondary UOM wise grouping clearly visible)
• Y-axis: Untaxed Total ($) — amount by secondary unit type
• Line chart showing purchase value by Sec UOM category for better analytics
📋 Step 24 — RFQ List View: Bayan & Container Columns + Lead Time Report Menu
Purchase → Orders list view mein module ke naye columns aur reporting option:
• Bayan Number column: list view mein clearly visible ✅ (module ka addition)
• Container Number column: list view mein clearly visible ✅ (module ka addition)
• P00001: Bayan = BYN-2025-001, Container = CONT-XYZ-9988 dikh raha hai
• Reporting menu → "Print Lead Time Report" ✅ — module ka naya menu item
• Is option se directly Lead Time XLSX report generate kar sakte hain
Purchase → Orders list view mein module ke naye columns aur reporting option:
• Bayan Number column: list view mein clearly visible ✅ (module ka addition)
• Container Number column: list view mein clearly visible ✅ (module ka addition)
• P00001: Bayan = BYN-2025-001, Container = CONT-XYZ-9988 dikh raha hai
• Reporting menu → "Print Lead Time Report" ✅ — module ka naya menu item
• Is option se directly Lead Time XLSX report generate kar sakte hain
📅 Step 25 — Print Lead Time Report: Date Range Wizard
Reporting → Print Lead Time Report click karne par wizard khulta hai:
• Date From: Mar 1 — is date ke baad confirm hue POs include honge
• Date To: Mar 12 — is range mein PO confirmation dates filter hongi
• Print button click karo → XLSX file automatically download ho jaayegi
• Cancel option bhi available hai agar report nahi chahiye
• Background mein Purchase Analysis dikh raha hai with Sec UOM filters
Reporting → Print Lead Time Report click karne par wizard khulta hai:
• Date From: Mar 1 — is date ke baad confirm hue POs include honge
• Date To: Mar 12 — is range mein PO confirmation dates filter hongi
• Print button click karo → XLSX file automatically download ho jaayegi
• Cancel option bhi available hai agar report nahi chahiye
• Background mein Purchase Analysis dikh raha hai with Sec UOM filters
🏆 Step 26 — Lead Time XLSX Report: Final Excel Output (Main Deliverable)
Print click karne par yeh professional Excel file download hoti hai — module ka main output:
• PO No: P00001 | Supplier: Al Noor Trading LLC | 2 product rows
• Step 1 (PO Confirmation – Supplier Acknowledgement): 2 days
• Step 2 (PO Confirmation – Goods On Vessel): 7 days
• Step 3 (Goods On Vessel – Goods Arrival at Port): 7 days
• Step 4 (Goods Arrival at Port – Goods in Warehouse): 3 days
• Step 5 (Goods in Warehouse – Goods Sold): — (dash — sale alag shipment mein tha)
• Total Lead Time: 19 Days for both Rice Basmati 25KG & Sugar 50KG ✅
• Color-coded dark blue headers | Full step descriptions in column names | Professional Excel format
Print click karne par yeh professional Excel file download hoti hai — module ka main output:
• PO No: P00001 | Supplier: Al Noor Trading LLC | 2 product rows
• Step 1 (PO Confirmation – Supplier Acknowledgement): 2 days
• Step 2 (PO Confirmation – Goods On Vessel): 7 days
• Step 3 (Goods On Vessel – Goods Arrival at Port): 7 days
• Step 4 (Goods Arrival at Port – Goods in Warehouse): 3 days
• Step 5 (Goods in Warehouse – Goods Sold): — (dash — sale alag shipment mein tha)
• Total Lead Time: 19 Days for both Rice Basmati 25KG & Sugar 50KG ✅
• Color-coded dark blue headers | Full step descriptions in column names | Professional Excel format
Our Services
Odoo
Customization
Odoo
Migration
Support &
Maintenance
📞 Contact Us
WhatsApp:
Email:
Website:
Address: |
🌐 Follow Us📘 Facebook 📸 Instagram 💼 LinkedIn 🎥 YouTube |
© 2026 LucidBrainz | All Rights Reserved | all_in_one_secondary_uom | v19.0.1.0.0 | OPL-1
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