Lot-Based Product Split
Consolidates split product stock, saleable lots, split/source product ordering, and MRP-backed source-to-split production.
Highlighted Features
Split Product Configuration
Configure products as split products and define whether they are source product or split product. Split products can be linked to their source product.
Saleable and Not Saleable Stock Separation
The module separates split product inventory into saleable stock and not saleable stock, helping users clearly identify which lots are ready for sale and which are still waiting for approval or maturation.
Lot-Based Saleability Control
Each split product lot has a saleability status: Not Saleable or Saleable. Users can manually change the lot status or allow the system to make lots saleable automatically based on the configured date.
Master Details Order Flow
A dedicated Master Details screen is added to manage customer orders with product, quantity, units, price, lot, and subtotal details.
Automatic Sale Order Creation
When a Master Details order is saved, the module automatically creates or updates a linked Odoo Sale Order in the backend.
Lot Selection for Auto-Split Product Sales
Sales and Master Details order lines support lot selection, ensuring that split products are sold from the correct lot.
Split Product Production Using MRP
When a split product is sold and stock is not available, the module automatically creates and completes a manufacturing order by consuming the related source product lot.
Return and Credit Note Handling
Negative unit lines in Master Details are treated as customer returns. The module creates return pickings and prepares customer credit notes accordingly.
Invoice and Delivery Automation
The Create Invoice button validates returns, reserves delivery stock, validates pickings, creates customer invoices, and marks the Master Details order as done.
Detailed Features
Split Product Identification
The module adds a Auto-Split Product checkbox on the product form. This allows the system to identify products that should follow the product split on demand stock and sale flow.
Split Product Product Setup
A product can be marked as Split Product. For split products, the user must configure the related Source Product, which represents the source product used for production.
Original Auto-Split Product Link
The Source Product field links a split product to its source product. This link is used when the system needs to manufacture split product from source product stock.
Saleable Stock Quantity
For split products, the standard available quantity is treated as saleable stock. Only stock from lots marked as Saleable is considered available for sale.
Not Saleable Stock Quantity
The module adds a separate Not Saleable Stock quantity. This shows stock available in lots that are not yet ready for sale.
Product Stock Buttons
On the product form, the module adds separate stat buttons for Saleable and Not Saleable stock. These buttons open stock quants filtered by lot status.
Lot Status Management
Each lot gets a status field with two values: Not Saleable and Saleable. New lots are created as Not Saleable by default.
Manual Saleable/Not Saleable Action
Users can manually click Set Saleable/Not Saleable on a lot to make it available for sale/not sale immediately.
Saleable From Date
Each lot has a Saleable From date. This defines when the lot should become available for sale.
Daily Saleability Cron
A scheduled action runs daily and checks all not-saleable lots. If automatic saleability is enabled and the saleable date has arrived, the lot is changed to Saleable.
Saleable Stock Reservation Restriction
For split product deliveries, reservation is restricted to saleable lots only. This prevents non-saleable split product stock from being delivered.
Lot-Based Delivery Preparation
When sale order lines have selected lots, the stock move lines are prepared with the correct lot information during reservation.
Master Details Menu
The module adds a new Product Split on Demand menu with a Master Details submenu for managing product split on demand customer orders.
Master Details Header Information
The Master Details form includes customer, order date, pricelist, reference, state, invoice status, and untaxed amount.
Master Details Order Lines
Users can enter products, quantities, UoM, units, price, lot, and subtotal in the Master Details order line grid.
Unit Calculation from Quantity
The module calculates units based on the selected quantity and UoM, using the product’s default UoM.
Automatic Linked Sale Order
When Master Details lines are saved, the module automatically creates a linked sale order for positive unit lines.
Return Line Handling
Lines with negative units are treated as returns. These lines are used to create incoming return pickings from the customer location.
Return Picking Creation
The module automatically creates return pickings for returned products and assigns the selected lot to the return move lines.
Credit Note Creation
For returned lines, the module creates customer credit notes with product, quantity, price, account, and tax details.
Split Product Lot Selection
When selling a split product, the user can select either an existing split product lot or the related saleable source product lot.
Matching Split Lot Creation
If a split product lot does not exist, the module can create one using the same lot name as the source product lot.
Automatic Split Product BoM Creation
If no BoM exists for the split product, the module automatically creates a normal BoM that produces 1 split product from 0.5 source product.
Split Product Stock Check
Before invoicing, the module checks whether enough saleable split product stock exists for the selected lot.
Automatic Manufacturing Order
If split product stock is short, the module automatically creates a manufacturing order to produce the required split product quantity.
Source Product Lot Consumption
The manufacturing order consumes the matching source product lot. The source and split lots are matched by lot name.
Whole Auto-Split Product Consumption Logic
The module rounds source product consumption upward, meaning odd split product demand may consume a source product and leave extra split product stock.
Screenshots
Source Product Configuration
Configure products as split-enabled products and enable lot tracking to manage split product stock batch-wise.
Split Product Configuration
Mark products as split product and link them with the source product for automatic production flow.
Saleable and Not Saleable Stock Overview
View separate stock quantities for saleable and not saleable split product directly from the product form.
Lot-Based Saleability Status
Manage split product lots by status, such as Not Saleable and Saleable, for better stock control.
Source Product Stock Availability
Track available source product stock by lot before sale, delivery, or split production.
Split Product Stock Availability
View available split product stock by lot and identify whether additional production is required.
Master Details Order Entry
Create customer orders from a dedicated Master Details screen with product, quantity, units, price, and lot information. When a Split Product product lot does not have enough available quantity, the system automatically creates and completes an MRP order by consuming the related Source product lot.
Completed Master Details Order
Once processed, the Master Details order is marked as done and linked with generated sales, delivery, and invoice records.
Automatic Sale Order Creation
It automatically generates a confirmed sale order from Master Details lines with selected lots and pricing.
Automatic Delivery Processing
It creates and validate delivery orders for split products based on selected lots and ordered quantities.
Automatic Split Product Manufacturing
It automatically creates and processes a manufacturing order to produce split product by consuming the related source product lot.
Source Product Stock Consumption
Source product stock is reduced automatically after split production and delivery processing.
Split Product Stock Update
Split product stock is automatically increased after manufacturing and reduced after sale delivery.
Automatic Customer Invoice
It generates customer invoices automatically from the linked sale order using delivered split product quantities.
Return Order Handling
Negative quantity lines in Master Details are treated as customer returns and processed separately.
Automatic Credit Note Creation
It creates customer credit notes automatically for returned split products with correct product, quantity, price, and taxes.
User Guide
FAQ
Our Odoo Services
Odoo Consulting
Odoo Implementation
Odoo Development
Odoo Testing
Odoo Data Migration
Odoo Training
Odoo Support
Hire Odoo Developers
Help And Support
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Manufacturing (mrp) • Sales (sale_management) • Discuss (mail) • Inventory (stock) |
| Lines of code | 1467 |
| Technical Name |
mrp_product_lot_split |
| License | LGPL-3 |
| Website | https://www.serpentcs.com |
Features
Screenshots
WhatsApp
Email
Website
Please log in to comment on this module