Lot Based Real Costing | MRP Lot Costing | Manufacturing Lot Cost Tracking
by Odoo GlobalOps https://apps.odoo.com/apps/modules/browse?search=globalops$ 50.01
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Invoicing (account) • Discuss (mail) • Inventory (stock) |
| Lines of code | 188 |
| Technical Name |
stock_real_costing_go |
| License | OPL-1 |
| Website | https://apps.odoo.com/apps/modules/browse?search=globalops |
| Versions | 16.0 17.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Invoicing (account) • Discuss (mail) • Inventory (stock) |
| Lines of code | 188 |
| Technical Name |
stock_real_costing_go |
| License | OPL-1 |
| Website | https://apps.odoo.com/apps/modules/browse?search=globalops |
| Versions | 16.0 17.0 |
Lot Based Real Costing
Capture the actual purchase cost on every lot at receipt time and use it to drive exact stock valuation on outgoing shipments -- eliminating FIFO queue blending and delivering true per-lot cost accuracy.
Why This Module?
Odoo's standard FIFO costing pulls cost from the oldest incoming layer -- regardless of which specific lot you actually shipped. When the same product is purchased across multiple orders at different prices, this blending makes COGS entries inaccurate and gross margins impossible to trust at the lot level.
- Lots bought at different prices are merged into the same FIFO queue
- Deliveries draw cost from the queue order, not from the lot actually shipped
- No visibility of the real cost or value held inside each individual lot
- Stock valuation journal entries do not reflect the true procurement cost of the delivered lot
Lot Based Real Costing solves this by automatically recording the actual unit purchase cost on each lot at receipt validation and using that exact cost when generating the outgoing Stock Valuation Layer and its accounting journal entry -- bypassing the FIFO queue entirely for lot-tracked products.
Per-Lot Cost Capture
Automatically records the actual purchase cost on each lot or serial number at receipt validation -- no manual entry required.
Exact Outgoing Valuation
Outgoing stock moves read the specific lot's recorded cost to generate the SVL and journal entry, completely bypassing the FIFO queue.
Lot Cost & Value Visibility
Each lot displays its per-unit cost and total current stock value directly on the lot form for instant cost intelligence.
Category-Level Activation
Enable lot-wise costing per product category with a single toggle -- only visible when FIFO is the active costing method.
FIFO Ledger Consistency
Incoming SVL remaining quantities are properly decremented so the FIFO ledger stays balanced and fully audit-ready.
Graceful Fallback
If no lot is assigned or no cost is on record, the module falls back to the product's standard price automatically.
1. Configure Product Tracking & Enable Lot Wise Costing
Set the product's tracking to By Lots or By Serial Number. Then, on the product's category under Inventory Valuation, set the costing method to First In First Out (FIFO) and enable the Lot Wise Costing toggle. This toggle only appears when FIFO is selected and activates per-lot cost capture for every product in that category.
Product configured with lot tracking
Lot Wise Costing toggle enabled on the product category
2. Create Purchase Orders at Different Prices
Purchase orders are created at different unit prices across separate orders. In this example, the first order is placed at 150 per unit and the second at 100 per unit. This price difference across lots is exactly the scenario where standard FIFO produces inaccurate valuations -- and where this module delivers its core value.
First purchase order -- unit price 150
Second purchase order -- unit price 100
3. Validate Receipts -- Cost Captured Automatically on Each Lot
When each receipt is validated, the module reads the unit cost from the newly created Stock Valuation Layer and automatically writes it to the lot's Per Unit Cost field. No manual input is needed. After both receipts are validated, LOT1 carries a cost of 150 and LOT2 carries a cost of 100 -- each lot's form clearly shows the per-unit cost and the total current stock value.
Receipt -- LOT1 quantity received
LOT1 -- per unit cost 150 and stock value
LOT2 -- per unit cost 100 and stock value
4. Deliver from LOT1 -- Valuation Created at Cost 150
When a delivery is created and the detail line is assigned to LOT1, the system bypasses the FIFO queue and reads LOT1's recorded cost of 150. On validation, the outgoing Stock Valuation Layer is created with unit cost = 150 -- generating an accurate, lot-specific accounting journal entry that matches the true procurement cost of the goods shipped.
Delivery order -- 1 unit to ship
Detail line assigned to LOT1 -- unit price 150
Stock valuation layer -- unit cost 150 from LOT1
5. Deliver from LOT2 -- Valuation Created at Cost 100
In a subsequent delivery, when the operator assigns LOT2 to the detail line, the module reads LOT2's stored cost of 100 and creates the outgoing valuation layer with unit cost = 100. The two deliveries now carry precisely different costs matching their actual procurement prices -- enabling true gross margin analysis at the individual lot level.
Second delivery -- 1 unit to ship
Detail line assigned to LOT2 -- unit price 100
Stock valuation layer -- unit cost 100 from LOT2
Accurate Cost of Goods Sold
COGS entries reflect the exact procurement cost of the lot delivered -- not an averaged FIFO estimate -- critical for correct P&L reporting.
True Lot-Level Margins
Compare sale price against the real cost of the delivered lot to calculate precise gross margins for every individual shipment.
Inventory Value Transparency
Each lot shows its per-unit cost and total stock value, giving warehouse and finance teams immediate, reliable stock intelligence.
No Accounting Drift
The FIFO ledger is properly balanced -- incoming SVL remaining quantities are decremented proportionally to keep accounts fully reconcilable.
Zero Configuration Overhead
Cost capture is fully automatic at receipt validation. No custom price lists, landed costs, or manual adjustments needed.
Selective Activation
Enable only for the categories that require lot-wise costing. All other categories continue using standard FIFO with zero impact.
Precise Lot-Level Stock Valuation for Every Shipment
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