Skip to Content

Cost Breakdown Propagation to JE

by
Odoo

$ 550.00

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


ODOO'S FUNCTION

In Odoo, each delivery posts one single COGS line per product, which hides the cost structure and makes it difficult to see which components really impact your margins.


CLUEDOO'S FUNCTION

CLuedoo’s uses the Cost Breakdown on the product variants to split COGS when you deliver goods automatically.

​1️⃣ On each delivery, it divides the COGS amount proportionally across several lines (purchase, freight, insurance, etc.), using the cost accounts defined on each valuation category.

​2️⃣ With AVCO, every delivery generates a multi-line COGS entry that mirrors the real cost structure of the product.

CONFIGURATION

1. Go to Inventory > Configuration > Detail Stock > SVL Category

2. Set the Cost Account in the SVL Categories

3. Choose/create a goods product that has variants, is tracked By Quantity, and define a Category for it

4. Make sure the Inventory Valuation of the product category is set up correctly:

  • Costing Method: Average Cost (AVCO)
  • Inventory Valuation: Automated

USAGE

1. Create a Sales Order > Add the product(s) > Confirm > Validate the delivery out transfer.




2. Go back to the SO form > Create Invoice > Confirm

3. Go to the Journal Items tab on the invoice > We can see the cost breakdown:


  • Each detail's account matches the Cost Account configured in the SVL Category.
  • The details match the prorata in the Cost Breakdown table on the product variant form.
For example:
  • Component 1: Purchase Receipt = $8.75* 133.33% = $11.67

→ positive , Odoo places it in the Debit column.

  • Component 2: Delivery Order = $8.75* (-33.33%) = -$2.92

→ negative , Odoo places $2.92 in the Credit column.




Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Invoicing (account)
• Discuss (mail)
• Manufacturing (mrp)
• Inventory (stock)
• Purchase (purchase)
Community Apps Dependencies
Lines of code 1309
Technical Name cds_product_cost_breakdown_propagate
LicenseAGPL-3
Websitehttps://www.cluedoo.com/shop/lic-clu-set-pmd-0040-cost-breakdown-propagation-to-je-7127

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.