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. Inventory
  3. Inventory Lot Costing With Landed Cost v 18.0
  4. Sales Conditions FAQ

Inventory Lot Costing With Landed Cost

by Serpent Consulting Services Pvt. Ltd.
Odoo

$ 150.26

v 18.0 Third Party
Apps purchases are linked to your Odoo account, please sign in or sign up first.
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Purchase (purchase)
• Invoicing (account)
• Discuss (mail)
• Inventory (stock)
Lines of code 103
Technical Name inventory_lot_costing_with_landed_cost
LicenseLGPL-3
Versions 17.0 18.0 19.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Purchase (purchase)
• Invoicing (account)
• Discuss (mail)
• Inventory (stock)
Lines of code 103
Technical Name inventory_lot_costing_with_landed_cost
LicenseLGPL-3
Versions 17.0 18.0 19.0
Product Logo
SerpentCS Logo

Lot-wise Purchase & Landed Cost Tracking

This module enhances Odoo’s inventory management by providing detailed lot/serial number–level costing, combining both purchase price and landed costs into clear, actionable metrics. It automatically calculates the purchase cost per unit, distributes additional landed expenses such as shipping or duties proportionally, and computes the total cost based on available stock for each lot. By linking stock moves, purchase orders, and landed cost adjustments, it ensures accurate cost visibility directly from the lot view, helping businesses track true inventory value, improve cost analysis, and make more informed operational and financial decisions without requiring manual calculations.

  • Features
  • Screenshots
  • User Guide
  • FAQs

Highlighted Features

Accurate Purchase Cost per Lot

Automatically calculates the exact purchase cost per unit for each lot using linked purchase orders and incoming stock data, ensuring precise lot-level costing.

Landed Cost Allocation

Proportionally distributes additional expenses such as shipping, duties, and handling across lot quantities to reflect the true landed cost.

Real-Time Stock Value

Dynamically computes the total cost based on available stock for each lot, giving instant visibility into current inventory value.

Costing Visibility in Lot View

Adds a dedicated “Purchase Costing” section in the lot form, allowing users to easily view all cost-related information in one place.

Detailed Features

Purchase Cost per Lot Calculation

The system calculates the purchase cost per unit for each lot based only on completed incoming stock move lines linked with purchase orders.

Landed Cost Aggregation per Lot

Landed costs are computed and summed for each lot by proportionally distributing additional landed cost values from related stock moves.

Total Cost Based on Available Quantity

The module calculates the total cost of a lot using the available stock quantity multiplied by the computed purchase cost per unit.

Automatic Computation from Stock Data

  • All values are automatically derived from stock move lines, quantities, and valuation data without any manual input, ensuring consistency with Odoo’s base inventory flow.

Screenshots

Create Purchase Order with Lot-based Product

Path :- Purchase → Orders → Purchase Orders → Create

A purchase order is created for products configured with lot tracking, where the unit price defines the base purchase cost. Once confirmed, the system generates a receipt for incoming stock, which is later used to assign lot numbers. This purchase data serves as the foundation for calculating lot-wise purchase cost and integrating with landed cost computations.

Validate Receipt and Assign Lot Details

Path :- Purchase → Orders → Purchase Orders → Open PO → Receipt → Validate

After confirming the purchase order, the receipt is processed to record incoming stock. By opening the Details option, users can assign or verify lot/serial numbers for the received quantities. Once validated, this step ensures that stock is properly recorded with lot information, which is essential for enabling accurate lot-wise purchase and landed cost calculations in the system.

Assign Lot/Serial Number to Incoming Stock

Path :- Purchase → Orders → Purchase Orders → Open PO → Receipt → Details

In the detailed operations window, users assign a lot/serial number to the received quantity of the product. This step links the incoming stock to a specific lot, which is essential for enabling lot-wise tracking and cost calculation. The assigned lot number is later used by the system to compute purchase cost and allocate landed costs accurately at the lot level.

Access Landed Cost Records

Path :- Inventory → Operations → Landed Costs

This menu allows users to view and manage all landed cost records in the system. From here, users can create new landed cost entries, review existing ones, and validate them. These records are used to allocate additional expenses to incoming stock, which are later utilized by the system to compute accurate lot-wise landed costs.

Create and Compute Landed Cost

Path :- Inventory → Operations → Landed Costs → Create

A landed cost record is created by selecting the संबंधित receipt (transfer) and adding additional cost lines using a landed cost product. Users enter the cost amount and choose a split method to distribute expenses across the received products. By clicking Compute, the system calculates how the additional cost will be allocated to the stock moves. This computed data is then used to update valuation and enables accurate lot-wise landed cost calculation.

Review Landed Cost Allocation

Path :- Inventory → Operations → Landed Costs → Open Record → Valuation Adjustments Tab

After computing the landed cost, the Valuation Adjustments tab displays how the additional cost is distributed across the selected products. It shows the original value, added landed cost, and the new total value after allocation. This step allows users to review and verify cost distribution before validating, ensuring accurate inventory valuation and correct lot-wise cost calculation.

View Lot-wise Purchase and Landed Cost

Path :- Purchase → Products → Lots/Serial Numbers → Open Lot

This screen displays the computed purchase and landed cost details at the lot level. It shows the purchase cost per unit, total landed cost applied, and the total cost based on available stock quantity. These values are automatically calculated from purchase orders, stock moves, and landed cost records, providing complete visibility into the actual cost of inventory for each lot.


User Guide

Enable Lot Tracking for Product

Path :- Purchase → Products → Open Product → General Information Tab

To enable lot-wise costing, the product must be configured as a storable (Goods) product and inventory tracking should be set to By Lots. This ensures that each incoming quantity is assigned to a specific lot, allowing the system to track purchase and landed costs at the lot level. Without lot tracking, the module will not be able to compute cost values per lot accurately.

Configure Landed Cost Product Type and Category

Path :-  Purchase → Products → Open Product → General Information Tab

To use a product for landed cost allocation, it should be configured as a Service type product since it does not represent physical stock movement. Additionally, assigning it to an appropriate category such as Expenses ensures proper accounting treatment. This configuration allows the product to be used for adding extra costs like freight or insurance without affecting inventory quantities.

Enable Product as Landed Cost

Path :-  Purchase → Products → Open Product → Purchase Tab

This setting allows you to mark a product as a Landed Cost. When enabled, the product can be used in landed cost records to allocate additional expenses such as shipping, freight, insurance, or customs duties to purchased goods. These costs are then distributed across the related stock moves, which directly impacts the lot-wise costing calculations in the system.

FAQ

May I install the app on my Odoo Online (SaaS) database?

No, third-party apps can not be used on Odoo Online. Unfortunately, Odoo SaaS blocks such a possibility.

Can I try the app before purchasing?

In many cases, yes. We offer Demo videos, Screenshots, Live demo links (for selected apps) If you need a personalized demo, you can contact our support team.

Is this module compatible with Odoo Enterprise?

Yes, the module is fully compatible with Odoo Community and Enterprise editions.

What Kind of support will you get after the Module purchase?

You will get 30 Days of free support on any doubts, queries, bug fixing, or any issue related to this addon.

What if I need any additional customization or extra feature with this addon?

We request you contact our team via contact@serpentcs.com to discuss the features and customization required so that we can provide you assistance with your request.

Suggested Products

Import Export Inventory Report

Go to store

Inventory ABC Analysis

Go to store

Multi Package Inventory Report Product Packaging Report

Go to store

Non Moving Stock Report

Go to store

Product Low Stock Alert by Report

Go to store

Warehouse Restrictions

Go to store

Odoo RingCentral Integration

Go to store

Microsoft Azure SSO Integration

Go to store

Web Auto Refresh and Reload

Go to store

Freight Management

Go to store

3CX CRM Odoo Connector

Go to store

Account Analytic Filter in distribution

Go to store

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

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