| 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 |
| License | LGPL-3 |
| Versions | 17.0 18.0 19.0 |
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.
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
No, third-party apps can not be used on Odoo Online. Unfortunately, Odoo SaaS blocks such a possibility.
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.
Yes, the module is fully compatible with Odoo Community and Enterprise editions.
You will get 30 Days of free support on any doubts, queries, bug fixing, or any issue related to 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.
Our Odoo Services
Odoo Consulting
Odoo Implementation
Odoo Development
Odoo Testing
Odoo Data Migration
Odoo Training
Odoo Support
Features
Screenshots
User Guide
FAQs
WhatsApp
Email
Website
Please log in to comment on this module