Skip to Content

Product Variants Cost Breakdown

by
Odoo

$ 350.00

v 18.0 Third Party
You bought this module and need support? Click here!


ODOO'S FUNCTION

In Odoo, each product variant shows only a single standard cost, and users must manually dig through stock valuation layers (purchase receipts, landed costs, adjustments, etc.) to understand how this cost is built.

CLUEDOO'S FUNCTION

CLuedoo adds a Cost Breakdown view on the product variant that automatically decomposes the standard cost into its underlying components.

​1️⃣ Cost Breakdown table per product variant, grouping stock valuation layers by category (purchase, landed costs, insurance, adjustments, deliveries, etc.) and showing, for each category, total value, cost per unit, and its ratio (%) in the product cost.

​2️⃣ Auto‑recalculates this breakdown whenever Odoo updates the product’s standard cost (incoming moves, landed cost validation, valuation adjustments), with an extra server action to recompute existing products without new movements.

1. Go to Inventory > Products > Product Variants

Choose an existing/ create a new product variant.


2. On the Product Variant form, go to the Cost Breakdown tab

This tab shows how the product’s standard cost is split across different Stock Valuation Layer categories , such as Purchase, Delivery Fee, Insurance, Adjustments, etc.

CALCULATIONS:
  • Ratio (%) = (Total Value of the category/ Total Value of all categories) x 100%

e.g., Ratio of No Category = 50/ 22,548 x 100  = 0,22


  • Cost Per Unit = Total Value of the component / Remaining Quantity
e.g., Cost Per Unit of the Cost Adjustment = 19,500/75 = 260

You can run the Recalculate Cost Breakdown server action to compute the cost breakdown based on current valuation data for existing product variants without any new stock movement.




Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Discuss (mail)
• Manufacturing (mrp)
• Inventory (stock)
• Purchase (purchase)
• Invoicing (account)
Community Apps Dependencies
Lines of code 1123
Technical Name cds_product_cost_breakdown
LicenseAGPL-3
Websitehttps://www.cluedoo.com/shop/lic-clu-set-pmd-0039-product-variants-cost-breakdown-7125

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.