{"id":32267,"date":"2025-11-14T06:21:48","date_gmt":"2025-11-14T06:21:48","guid":{"rendered":"https:\/\/tenthplanet.in\/odoo\/?p=32267"},"modified":"2025-11-28T12:21:32","modified_gmt":"2025-11-28T12:21:32","slug":"perform-lot-serial-number-costing-calculation-for-product-in-odoo-inventory","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/odoo\/product\/inventory\/perform-lot-serial-number-costing-calculation-for-product-in-odoo-inventory\/","title":{"rendered":"How to perform Lot\/Serial Number Costing calculation for Product in Odoo Inventory"},"content":{"rendered":"\n

Accurate cost and price management are essential for maintaining profitability in any product-based business. Odoo supports this through its Lot\/Serial Master, which tracks cost, margin, and pricing details for each product lot. This ensures complete visibility and control over product-level financials.<\/p>\n\n\n\n

The Lot\/Serial Master enables organizations to monitor cost structures, validate margins, and maintain consistent pricing standards. It supports accurate GR Bill preparation by comparing MRP, basic cost, and margins before finalization. This empowers businesses to perform effective price-variance analysis across multiple lots.<\/p>\n\n\n\n

By applying the outlined formulas and principles, companies can achieve precise cost control and stronger profitability management. The Lot Master ensures transparency in pricing decisions and aligns product costs with profitability targets. It provides the clarity needed to support data-driven, margin-focused pricing strategies.<\/p>\n\n\n\n

Accessing the Lot\/Serial Master in Odoo<\/strong><\/h2>\n\n\n\n

To view and manage lot or serial number details for a product then Open the Inventory<\/strong> module and navigate to the Lot\/Serial Number<\/strong> and select the appropriate lot. The Price Info<\/strong> section displays cost, tax, and margin details for the selected lot.<\/p>\n\n\n\n

Cost Price<\/strong><\/h3>\n\n\n\n

The Cost Price<\/strong> represents the cost or unit value of a single product unit.<\/p>\n\n\n\n

Formula:<\/p>\n\n\n\n

Cost Price = Basic Cost \u2212 Discount Percentage (if any)<\/code><\/pre>\n\n\n\n
Example:<\/p>\n\n\n\n
For a product such as A4 Paper with a Basic Cost<\/strong> of \u20b9236.61 and a discount of 0%, <\/p>\n\n\n\n
Cost Price= 236.61 \u2212 0 = \u20b9236.61<\/code><\/pre>\n\n\n\n
If the discount is 0%, the total discount amount will also be 0.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
FGC (Final Gross Cost)<\/strong><\/h3>\n\n\n\n
The FGC Cost<\/strong> represents the final cost per unit, including any additional charges.<\/p>\n\n\n\n
Formula:<\/p>\n\n\n\n
FGC Cost = Cost Price \u00b1 Additional Cost<\/code><\/pre>\n\n\n\n
If no additional cost is added, the FGC Cost equals the Cost Price.<\/p>\n\n\n\n
Example:<\/p>\n\n\n\n
FGC Cost = 236.61 + 0 = \u20b9236.61<\/code><\/pre>\n\n\n\n
Tax Amount<\/strong><\/h3>\n\n\n\n
The Tax Amount<\/strong> is derived by applying the applicable tax rate to the Final Gross Cost. <\/p>\n\n\n\n
Formula:<\/p>\n\n\n\n
Tax Amount = Final Gross Cost \u00d7 Tax %  <\/code><\/pre>\n\n\n\n
Example:<\/p>\n\n\n\n
Final Gross Cost = \u20b9236.61\nTax Rate = 12%\nTax Amount = 236.61 \u00d7 12% = \u20b928.40  <\/code><\/pre>\n\n\n\n
Net Cost<\/strong> <\/h3>\n\n\n\n
The Net Cost<\/strong> combines the final gross cost and tax amount. <\/p>\n\n\n\n
Formula:<\/p>\n\n\n\n
Net Cost = Final Gross Cost + Tax Amount <\/code><\/pre>\n\n\n\n
Example:<\/p>\n\n\n\n
Net Cost = 236.61 + 28.40 = \u20b9265.01<\/code><\/pre>\n\n\n\n
Markdown for Purchase Cost <\/h2>\n\n\n\n
Markdown<\/strong> represents the reduction from the product\u2019s MRP to its Final Gross Cost.<\/p>\n\n\n\n
Formula:<\/p>\n\n\n\n
Markdown (%) = ((MRP (Taxable) \u2013 Final Gross Cost) \/ MRP (Taxable)) \u00d7 100<\/code><\/pre>\n\n\n\n
Example:<\/p>\n\n\n\n
MRP (Taxable) = \u20b9339.28\nFinal Gross Cost = \u20b9236.61\nMarkdown = ((339.28 \u2013 236.61) \/ 339.28) \u00d7 100 = 30.26%<\/code><\/pre>\n\n\n\n
Markup for Purchase Cost<\/strong> <\/h3>\n\n\n\n
Markup<\/strong> indicates the percentage by which the MRP exceeds the Final Gross Cost.<\/p>\n\n\n\n
Formula:<\/p>\n\n\n\n
Markup (%) = ((MRP (Taxable) \u2013 Final Gross Cost) \/ Final Gross Cost) \u00d7 100<\/code><\/pre>\n\n\n\n
Example:<\/p>\n\n\n\n
MRP (Taxable) = \u20b9339.28\nFinal Gross Cost = \u20b9236.61\nMarkup = ((339.28 \u2013 236.61) \/ 236.61) \u00d7 100 = 43.39%<\/code><\/pre>\n\n\n\n
Sales Price Based on MRP<\/strong> <\/h3>\n\n\n\n
When a pricelist applies a discount to MRP, the Sales Price<\/strong> can be calculated as follows:<\/p>\n\n\n\n
Formula:<\/p>\n\n\n\n
Sales Price = MRP \u2212 Discount %<\/code><\/pre>\n\n\n\n
Example:<\/p>\n\n\n\n
MRP = \u20b9380\nDiscount = 10%\nSales Price = 380 \u2212 10% = \u20b9342<\/code><\/pre>\n\n\n\n
Margin Amount<\/strong><\/h3>\n\n\n\n
The Margin Amount<\/strong> indicates the profit per unit after deducting the Final Gross Cost from the Selling Price. <\/p>\n\n\n\n
Formula:<\/p>\n\n\n\n
Margin Amount = Sales Price (Taxable) \u2212 Final Gross Cost<\/code><\/pre>\n\n\n\n
Example:<\/p>\n\n\n\n
Sales Price (Taxable) = \u20b9305.36\nFinal Gross Cost = \u20b9236.61\nMargin Amount = 305.36 \u2212 236.61 = \u20b968.75<\/code><\/pre>\n\n\n\n
Markdown % for Selling Price<\/strong><\/h3>\n\n\n\n
Markdown %<\/strong> for Selling Price represents the reduction in the selling price relative to the Final Gross Cost.<\/p>\n\n\n\n
Formula:<\/p>\n\n\n\n
Markdown (%) = ((Selling Price (Taxable) \u2212 FGC) \/ Selling Price (Taxable)) \u00d7 100<\/code><\/pre>\n\n\n\n
Example:<\/p>\n\n\n\n
Selling Price (Taxable) = \u20b9305.36\nFGC = \u20b9236.61\nMarkdown = ((305.36 \u2212 236.61) \/ 305.36) \u00d7 100 = 22.51%<\/code><\/pre>\n\n\n\n
Markup % for Selling Price<\/strong><\/h3>\n\n\n\n
Markup %<\/strong> for Selling Price reflects how much higher the selling price is compared to the Final Gross Cost.<\/p>\n\n\n\n
Formula:<\/p>\n\n\n\n
Markup (%) = ((Selling Price (Taxable) \u2212 FGC) \/ FGC) \u00d7 100<\/code><\/pre>\n\n\n\n
Example:<\/p>\n\n\n\n
Selling Price (Taxable) = \u20b9305.36\nFGC = \u20b9236.61    Markup = ((305.36 \u2212 236.61) \/ 236.61) \u00d7 100 = 29.06%<\/code><\/pre>\n\n\n\n
\"Odoo<\/figure>\n","protected":false},"excerpt":{"rendered":"
Accurate cost and price management are essential for maintaining profitability in any product-based business. Odoo supports this through its Lot\/Serial […]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[382],"tags":[448,99,447],"class_list":["post-32267","post","type-post","status-publish","format-standard","hentry","category-inventory","tag-costing-calculation","tag-inventory","tag-lot-serial-number"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/32267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/comments?post=32267"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/posts\/32267\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/media?parent=32267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/categories?post=32267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/odoo\/wp-json\/wp\/v2\/tags?post=32267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}