Se rendre au contenu

Cost Breakdown Propagation to JE

Splits COGS into detailed lines matching product cost breakdown.
171,82 € 171,82 € (Hors taxes)
US$ 200,00 (Hors taxes)

  • Versions
Conditions générales
Garantie satisfait ou remboursé de 30 jours
Livraison : 2-3 jours ouvrables
Versions: V18


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 Category

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

3. 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

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


  • Each detail's account matches the 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.