Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
      • Get a Tailored Demo
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +32 2 290 34 90
    • Get a Tailored Demo
  • Pricing
  • Help
  1. APPS
  2. Manufacturing
  3. Lot Based Product Split v 19.0
  4. Sales Conditions FAQ

Lot Based Product Split

by Serpent Consulting Services Pvt. Ltd. https://www.serpentcs.com
Odoo

$ 114.20

v 19.0 Third Party
Apps purchases are linked to your Odoo account, please sign in or sign up first.
You bought this module and need support? Click here!
  • Description
  • Manifest
Product Logo
SerpentCS Logo

Lot-Based Product Split

Consolidates split product stock, saleable lots, split/source product ordering, and MRP-backed source-to-split production.

  • Features
  • Screenshots

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

Suggested Products

Business Solutions

Education Management

Education Management

Property Management

Property Management

Singapore Localization

Singapore Localization

Gym Management

Gym Management

Visa Management

Visa Management

Biometrics

Biometrics

HR Management

HR Management

Salon and Spa Management

Salon and Spa Management

Fleet Management

Fleet Management

Hotel Management

Hotel Management

Ring Central

Ring Central

Payment Provider

Payment Provider

Our Odoo Services

Odoo Customization

Odoo Consulting

Odoo Customization

Odoo Implementation

Odoo Customization

Odoo Development

Odoo Implementation

Odoo Testing

Odoo Integration

Odoo Data Migration

Odoo Support

Odoo Training

Odoo Support

Odoo Support

Hire Odoo Developer

Hire Odoo Developers

Help And Support

Ask for Query For any Query
Apps Checkout our Apps
Odoo Demo Check App Demo

rec  WhatsApp
rec (+91) 74860-40227
rec  Email
rec contact@serpentcs.com
rec  Website
rec www.serpentcs.com
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
LicenseLGPL-3
Websitehttps://www.serpentcs.com

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with